Upgrade Error: Cache update failed (webScriptsRegistryCache). NullPointerException

[kyle shepherdson]

Hello all. 

I'm attempting to upgrade a (clustered) 4.0e Community Instance to 4.2e (I will attempt version f next, I just already had version e available at the time.)

During start up I hit this error:

 2014-04-01 13:56:07,158  ERROR [repo.cache.AbstractAsynchronouslyRefreshedCache] [asynchronouslyRefreshedCacheThreadPool1] Cache update failed (webScriptsRegistryCache).

 java.lang.NullPointerException

        at org.alfresco.repo.web.scripts.RepoStore.findNodeRef(RepoStore.java:315)

        at org.alfresco.repo.web.scripts.RepoStore$7$1.execute(RepoStore.java:686)

        at org.alfresco.repo.web.scripts.RepoStore$7$1.execute(RepoStore.java:683)

        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)

        at org.alfresco.repo.web.scripts.RepoStore$7.doWork(RepoStore.java:682)

        at org.alfresco.repo.web.scripts.RepoStore$7.doWork(RepoStore.java:679)

        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)

        at org.alfresco.repo.web.scripts.RepoStore.getDocument(RepoStore.java:678)

        at org.springframework.extensions.webscripts.DeclarativeRegistry.initWebScripts(DeclarativeRegistry.java:375)

        at org.springframework.extensions.webscripts.DeclarativeRegistry.reset(DeclarativeRegistry.java:183)

        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.doBuildCache(RegistryAsynchronouslyRefreshedCache.java:83)

        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.access$000(RegistryAsynchronouslyRefreshedCache.java:41)

        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache$1.execute(RegistryAsynchronouslyRefreshedCache.java:72)

        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache$1.execute(RegistryAsynchronouslyRefreshedCache.java:68)

        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:452)

        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.buildCache(RegistryAsynchronouslyRefreshedCache.java:67)

        at org.alfresco.repo.web.scripts.RegistryAsynchronouslyRefreshedCache.buildCache(RegistryAsynchronouslyRefreshedCache.java:41)

        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.doRefresh(AbstractAsynchronouslyRefreshedCache.java:464)

        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.doCall(AbstractAsynchronouslyRefreshedCache.java:449)

        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.call(AbstractAsynchronouslyRefreshedCache.java:414)

        at org.alfresco.repo.cache.AbstractAsynchronouslyRefreshedCache.call(AbstractAsynchronouslyRefreshedCache.java:45)

        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

        at java.util.concurrent.FutureTask.run(FutureTask.java:166)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

        at java.lang.Thread.run(Thread.java:724)

I have edited: alfresco-global.properties, server.xml, and ctl.sh. I have reviewed these files and am unsure if any of them are involved in this issue.

I have attached catalina.out as well. Any pointers would be much appreciated. Thanks.

[sujay pillai]

Hello Kyle,

Can you please try to change the value for "db.pool.statements.enable" to false and give it a try.

Regards,

Sujay Pillai 

--
You received this message because you are subscribed to the Google Groups "Alfresco Technical Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to alfresco-technical-d...@googlegroups.com.
To post to this group, send email to alfresco-techn...@googlegroups.com.
Visit this group at http://groups.google.com/group/alfresco-technical-discussion.
For more options, visit https://groups.google.com/d/optout.

[Igor Blanco]

Clusteref?

As far as I know in Alfresco Community 4.2 the clustering code has been removed.

http://ecmarchitect.com/archives/2012/10/17/1745

Bye

[Douglas C. R. Paes]

Alfresco Community "clustered"?

That functionality is not supported on Community, at least, not in the latest versions.

Douglas C. R. Paes

"Done is better than perfect"

Zuckerberg

--

[Kyle Shepherdson]

@ Sujay: Thank you for the suggestion. I disabled the pool statements, but the output was identical.

@ Douglas: Sorry for not being clear. We are moving from a clustered 4.0d to a non-clustered 4.2. As you said, clustering is removed as of Community 4.2.