I am trying to execute this simple query to Alfresco with CMIS WORKBENCH and I am getting some errors:
SELECT * FROM cmis:document
When I check the log, there is a lot of exceptions. These are (to me) the relevants:
The Web Script /alfresco/service/cmis/queries has responded with a status of 500 - Internal Error.
Message: 09180065 Wrapped Exception (with status template): 09185424 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 09185423
Exception: java.security.cert.CertificateExpiredException - NotAfter: Fri Aug 17 07:34:11 VET 2012 Exception: java.security.cert.CertPathValidatorException - timestamp check failed Exception: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException - 09185423 Exception: org.alfresco.scripts.ScriptException - 09185424 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': Exception: org.springframework.extensions.webscripts.WebScriptException - 09180065 Wrapped Exception (with status template): 09185424 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 09185423
Does anybody knows what this exceptions means? Thanks for any help!
Here is an offical post from the Alfresco Forum, which is related to this problem.
It says that the default SSL certificate, which was delivered with your Alfresco will expire on the 17th August 2012 - that matches the exception in the log file:
The post also links to an article in the Alfresco Wiki, where the generation of new SSL certificates for SOLR (which handles the CMIS queries) is explained.
This error is caused by Alfresco and should not be CMIS-related.
Additional information
Blog post about creating self-signed certificates for SOLR.