AnsweredAssumed Answered

Failed to Load/Error Loading Items after adding SSL

Question asked by andrew.l on Jul 5, 2016
Latest reply on Jun 16, 2017 by nirali.shah2
Hello,

I have an issue with Alfresco Community 5.1 where I cannot see any items loaded in My Documents on the user dashboard, sites cant load the site content on the site's dashboard, and search does not function properly. This happen after adding an SSL certificate.

I inspected the error in the browser and found this:


{
    "status" :
  {
    "code" : 500,
    "name" : "Internal Error",
    "description" : "An error inside the HTTP server which prevented it from fulfilling the request."
  }, 
 
  "message" : "06040072 Wrapped Exception (with status template): 06040242 Failed to execute script 'classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js': 06040241 Failed to execute search: +PATH:\"\/app:company_home\/st:sites\/cm:_x0031_2345\/cm:documentLibrary\/\/*\" +@cm\\:modified:[2016\\-6\\-27T00\\:00\\:00.000 TO 2016\\-7\\-4T23\\:59\\:59.999] +@cm\\:modifier:\"alukonin\" +TYPE:\"cm:content\" -TYPE:\"cm:systemfolder\" -TYPE:\"fm:forums\" -TYPE:\"fm:forum\" -TYPE:\"fm:topic\" -TYPE:\"fm:post\" +(TYPE:\"content\" OR TYPE:\"app:filelink\" OR TYPE:\"folder\")", 
  "exception" : "org.springframework.extensions.webscripts.WebScriptException - 06040072 Wrapped Exception (with status template): 06040242 Failed to execute script 'classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js': 06040241 Failed to execute search: +PATH:\"\/app:company_home\/st:sites\/cm:_x0031_2345\/cm:documentLibrary\/\/*\" +@cm\\:modified:[2016\\-6\\-27T00\\:00\\:00.000 TO 2016\\-7\\-4T23\\:59\\:59.999] +@cm\\:modifier:\"alukonin\" +TYPE:\"cm:content\" -TYPE:\"cm:systemfolder\" -TYPE:\"fm:forums\" -TYPE:\"fm:forum\" -TYPE:\"fm:topic\" -TYPE:\"fm:post\" +(TYPE:\"content\" OR TYPE:\"app:filelink\" OR TYPE:\"folder\")",
 
  "callstack" :
  [
       ""      ,"sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"
      ,"sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:146)"
      ,"sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:131)"
      ,"java.security.cert.CertPathBuilder.build(CertPathBuilder.java:280)"
      ,"sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:382)"
      ,"sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:292)"
      ,"sun.security.validator.Validator.validate(Validator.java:260)"
      ,"sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:324)"
      ,"sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:229)"
      ,"sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:124)"
      ,"sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1491)"
      ,"sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)"
      ,"sun.security.ssl.Handshaker.processLoop(Handshaker.java:979)"
      ,"sun.security.ssl.Handshaker.process_record(Handshaker.java:914)"
      ,"sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1062)"
      ,"sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1375)"
      ,"sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:747)"
      ,"sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)"
      ,"java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)"
      ,"java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)"
      ,"org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:506)"
      ,"org.apache.commons.httpclient.HttpMethodBase.writeRequest(HttpMethodBase.java:2114)"
      ,"org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1096)"
      ,"org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)"
      ,"org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)"
      ,"org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)"
      ,"org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)"
      ,"org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postQuery(SolrQueryHTTPClient.java:679)"
      ,"org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postSolrQuery(SolrQueryHTTPClient.java:644)"
      ,"org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:605)"
      ,"org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:51)"
      ,"org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)"
      ,"org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:77)"
      ,"sun.reflect.GeneratedMethodAccessor649.invoke(Unknown Source)"
      ,"sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)"
      ,"java.lang.reflect.Method.invoke(Method.java:497)"
      ,"org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)"
      ,"org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)"
      ,"org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)"
      ,"com.sun.proxy.$Proxy22.query(Unknown Source)"
      ,"org.alfresco.repo.search.impl.SearchServiceSubSystemDelegator.query(SearchServiceSubSystemDelegator.java:126)"
      ,"sun.reflect.GeneratedMethodAccessor649.invoke(Unknown Source)"
      ,"sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)"
      ,"java.lang.reflect.Method.invoke(Method.java:497)"
      ,"org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)"
      ,"org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)"
      ,"org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)"
      ,"net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)"
      ,"org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)"
      ,"org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)"
      ,"org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)"
      ,"org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:159)"
      ,"org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)"
      ,"org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)"
      ,"org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)"
      ,"org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)"
      ,"org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)"
      ,"org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)"
      ,"com.sun.proxy.$Proxy22.query(Unknown Source)"
      ,"org.alfresco.repo.jscript.Search.queryResultMeta(Search.java:928)"
      ,"org.alfresco.repo.jscript.Search.queryResultSet(Search.java:770)"
      ,"org.alfresco.repo.jscript.Search.query(Search.java:551)"
      ,"sun.reflect.GeneratedMethodAccessor977.invoke(Unknown Source)"
      ,"sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)"
      ,"java.lang.reflect.Method.invoke(Method.java:497)"
      ,"org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)"
      ,"org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)"
      ,"org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32)"
      ,"org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_3._c_getDoclist_20(classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js:1127)"
      ,"org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_3.call(classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js)"
      ,"org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)"
      ,"org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_3._c_script_0(classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js:1348)"
      ,"org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_3.call(classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js)"
      ,"org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:394)"
      ,"org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3091)"
      ,"org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_3.call(classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js)"
      ,"org.mozilla.javascript.gen.classpath__alfresco_templates_webscripts_org_alfresco_slingshot_documentlibrary_doclist_get_js_3.exec(classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js)"
      ,"org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:502)"
      ,"org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:200)"
      ,"org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)"
      ,"org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:174)"
      ,"org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)"
      ,"org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1376)"
      ,"org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)"
      ,"org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:505)"
      ,"org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)"
      ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:580)"
      ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:649)"
      ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:421)"
      ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:301)"
      ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)"
      ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)"
      ,"org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)"
      ,"javax.servlet.http.HttpServlet.service(HttpServlet.java:727)"
      ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)"
      ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"
      ,"org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)"
      ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"
      ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"
      ,"org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)"
      ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"
      ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"
      ,"org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)"
      ,"org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)"
      ,"org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)"
      ,"org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)"
      ,"org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)"
      ,"org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)"
      ,"org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)"
      ,"org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)"
      ,"org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1074)"
      ,"org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)"
      ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2466)"
      ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2455)"
      ,"java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)"
      ,"java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)"
      ,"org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)"
      ,"java.lang.Thread.run(Thread.java:745)"
      ,"sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"
      ,"sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:387)"
      ,"javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"
      ,"sun.security.ssl.Alerts.getSSLException(Alerts.java:192)"
      ,"org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 06040240 "
      ,"org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:625)"
      ,"org.alfresco.error.AlfrescoRuntimeException: 06040241 Failed to execute search: +PATH:\"\/app:company_home\/st:sites\/cm:_x0031_2345\/cm:documentLibrary\/\/*\" +@cm\\:modified:[2016\\-6\\-27T00\\:00\\:00.000 TO 2016\\-7\\-4T23\\:59\\:59.999] +@cm\\:modifier:\"alukonin\" +TYPE:\"cm:content\" -TYPE:\"cm:systemfolder\" -TYPE:\"fm:forums\" -TYPE:\"fm:forum\" -TYPE:\"fm:topic\" -TYPE:\"fm:post\" +(TYPE:\"content\" OR TYPE:\"app:filelink\" OR TYPE:\"folder\")"
      ,"org.alfresco.repo.jscript.Search.queryResultMeta(Search.java:1019)"
      ,"org.alfresco.scripts.ScriptException: 06040242 Failed to execute script 'classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js': 06040241 Failed to execute search: +PATH:\"\/app:company_home\/st:sites\/cm:_x0031_2345\/cm:documentLibrary\/\/*\" +@cm\\:modified:[2016\\-6\\-27T00\\:00\\:00.000 TO 2016\\-7\\-4T23\\:59\\:59.999] +@cm\\:modifier:\"alukonin\" +TYPE:\"cm:content\" -TYPE:\"cm:systemfolder\" -TYPE:\"fm:forums\" -TYPE:\"fm:forum\" -TYPE:\"fm:topic\" -TYPE:\"fm:post\" +(TYPE:\"content\" OR TYPE:\"app:filelink\" OR TYPE:\"folder\")"
      ,"org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:204)"
      ,"org.springframework.extensions.webscripts.WebScriptException: 06040072 Wrapped Exception (with status template): 06040242 Failed to execute script 'classpath*:alfresco\/templates\/webscripts\/org\/alfresco\/slingshot\/documentlibrary\/doclist.get.js': 06040241 Failed to execute search: +PATH:\"\/app:company_home\/st:sites\/cm:_x0031_2345\/cm:documentLibrary\/\/*\" +@cm\\:modified:[2016\\-6\\-27T00\\:00\\:00.000 TO 2016\\-7\\-4T23\\:59\\:59.999] +@cm\\:modifier:\"alukonin\" +TYPE:\"cm:content\" -TYPE:\"cm:systemfolder\" -TYPE:\"fm:forums\" -TYPE:\"fm:forum\" -TYPE:\"fm:topic\" -TYPE:\"fm:post\" +(TYPE:\"content\" OR TYPE:\"app:filelink\" OR TYPE:\"folder\")"
      ,"org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1138)"

  ],
 
  "server" : "Community v5.1.0 (r122274-b3) schema 9,016",
  "time" : "Jul 4, 2016 4:50:07 PM"
}


The Alfresco log also has some entries about the ValidatorException: PKIX path building failed.

Not sure if that has something to do with this though.

Outcomes