AnsweredAssumed Answered

My task [Error loading items]

Question asked by doucouredave on Sep 28, 2012
Latest reply on Oct 16, 2012 by doucouredave
Hello All

I encounter an error in My Alfresco tasks list page and taks list dashlet.
I am using alfresco community 4.0.d Mysql 5.5 on MS server 2008.

Description:
When a user goes to the page "My Taks", he gets the error "Error loading items".
Similarly, the dashlet "My Task" shows all the time "Loading …".

My log:


2012-09-26 13:03:49,115  ERROR [extensions.webscripts.AbstractRuntime] [http-8080-16] Exception from executeScript - redirecting to status template error: 08260043 Wrapped Exception (with status template): 08264485 Error during processing of the template 'Expression jsonUtils.encodeJSONString(status.message) is undefined on line 11, column 18 in json.status.ftl.'. Please contact your system administrator.
org.springframework.extensions.webscripts.WebScriptException: 08260043 Wrapped Exception (with status template): 08264485 Error during processing of the template 'Expression jsonUtils.encodeJSONString(status.message) is undefined on line 11, column 18 in json.status.ftl.'. Please contact your system administrator.
   at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:970)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
   at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:393)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)
   at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:316)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:372)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
   at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
   at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
   at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
   at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
   at java.lang.Thread.run(Thread.java:662)
Caused by: org.alfresco.service.cmr.repository.TemplateException: 08264485 Error during processing of the template 'Expression jsonUtils.encodeJSONString(status.message) is undefined on line 11, column 18 in json.status.ftl.'. Please contact your system administrator.
   at org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:206)
   at org.springframework.extensions.webscripts.AbstractWebScript.renderTemplate(AbstractWebScript.java:800)
   at org.springframework.extensions.webscripts.AbstractWebScript.sendStatus(AbstractWebScript.java:899)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:96)
   … 25 more
Caused by: freemarker.core.InvalidReferenceException: Expression jsonUtils.encodeJSONString(status.message) is undefined on line 11, column 18 in json.status.ftl.
   at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:125)
   at freemarker.core.Expression.getStringValue(Expression.java:118)
   at freemarker.core.Expression.getStringValue(Expression.java:93)
   at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
   at freemarker.core.Environment.visit(Environment.java:221)
   at freemarker.core.MixedContent.accept(MixedContent.java:92)
   at freemarker.core.Environment.visit(Environment.java:221)
   at freemarker.core.Environment.process(Environment.java:199)
   at org.alfresco.repo.template.FreeMarkerProcessor.process(FreeMarkerProcessor.java:202)
   … 28 more

Trying to debug, I see that via firebug, the ajax callback (link bellow) returns an error 500.
http://localhost:8080/share/proxy/alfresco/api/task-instances?authority=username&properties=bpm_priority,bpm_status,bpm_dueDate,bpm_description&exclude=wcmwf:*&skipCount=0&maxItems=50

ajax callback return:

{
    "status" :
  {
    "code" : 500,
    "name" : "Internal Error",
    "description" : "An error inside the HTTP server which prevented it from fulfilling the request."
  }, 
 
  "message" : "08262695 Wrapped Exception (with status template): null", 
  "exception" : "org.springframework.extensions.webscripts.WebScriptException - 08262695 Wrapped Exception (with status template): null",
 
  "callstack" :
  [
       ""      ,"java.lang.StackOverflowError"
      ,"java.util.HashMap.get(HashMap.java:300)"
      ,"org.springframework.transaction.support.TransactionSynchronizationManager.doGetResource(TransactionSynchronizationManager.java:153)"
      ,"org.springframework.transaction.support.TransactionSynchronizationManager.getResource(TransactionSynchronizationManager.java:137)"
      ,"org.alfresco.repo.transaction.AlfrescoTransactionSupport.getTransactionId(AlfrescoTransactionSupport.java:114)"
      ,"org.alfresco.repo.cache.TransactionalCache.get(TransactionalCache.java:337)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:995)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.alfresco.repo.security.authority.AuthorityDAOImpl.isAuthorityContained(AuthorityDAOImpl.java:1007)"
      ,"org.springframework.extensions.webscripts.WebScriptException: 08262695 Wrapped Exception (with status template): null"
      ,"org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:970)"

  ],
 
  "server" : "Community v4.0.0 (4003) schema 5,025",
  "time" : "Sep 26, 2012 4:27:18 PM"
}

I encounter this issue on a recently upgraded instance (3.4.d to 4.0.d).

Help is very appreciated.

thanks

Outcomes