AnsweredAssumed Answered

ERROR: Upgrade from 2.1CE to 2.9B CE (OracleDB)

Question asked by unknown-user on Feb 7, 2008
Latest reply on Feb 7, 2008 by unknown-user
Env: RHEL 5(x86_32), Tomcat 6.0.13, Java6u2, Alfresco 2.9B CE, OracleDB


The upgrade scripts execute but then the initialization fails with:
org.alfresco.error.AlfrescoRuntimeException: The store 'user://alfrescoUserStore' has a duplicate root node entry.

Anyone else encounter this error and have a remedy? Thanks.

14:56:14,398 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.Oracle9Dialect.
14:56:16,966 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29771.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-2.1-NotNullColumns.sql).
14:56:57,182 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29772.sql (Generated).
14:56:57,959 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29773.sql (Copied from classpath:alfresco/dbscripts/upgrade/1.4/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-1.4-TxnCommitTimeIndex.sql).
14:56:58,723 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29774.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-2.1-FKIndexes.sql).
14:56:59,300 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29775.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-2.1-ExplicitIndexes.sql).
14:56:59,615 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29776.sql (Copied from classpath:alfresco/dbscripts/upgrade/1.4/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-1.4-PerfIndexes02.sql).
14:56:59,810 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29777.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-2.1-VersionColumns.sql).
14:56:59,976 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29778.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-2.1-JBPMProcessKey.sql).
14:56:59,987 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29779.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.1/org.hibernate.dialect.Oracle9Dialect/AlfrescoSchemaUpdate-2.1-RemoveWcmSubmittedAspect.sql).
14:56:59,997 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements written to file /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-All_Statements-29780.sql.
14:57:02,337 WARN  [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
14:57:02,384 WARN  [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
14:57:02,410 WARN  [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
14:57:02,426 WARN  [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment
14:57:04,850 INFO  [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /alf/alf_data
14:57:04,898 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: The store 'user://alfrescoUserStore' has a duplicate root node entry.
        at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:268)
        at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)
        at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:236)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:185)
        at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:516)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:566)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)

Outcomes