topic ERROR: Upgrade from 2.1CE to 2.9B CE (OracleDB) in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-upgrade-from-2-1ce-to-2-9b-ce-oracledb/m-p/151536#M106284 <HTML><HEAD></HEAD><BODY><SPAN>Env: </SPAN><STRONG>RHEL 5(x86_32), Tomcat 6.0.13, Java6u2, Alfresco 2.9B CE, OracleDB<BR /></STRONG><BR /><BR /><SPAN>The upgrade scripts execute but then the initialization fails with:</SPAN><BR /><STRONG>org.alfresco.error.AlfrescoRuntimeException: The store 'user://alfrescoUserStore' has a duplicate root node entry.</STRONG><BR /><BR /><SPAN>Anyone else encounter this error and have a remedy? Thanks.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>14:56:14,398 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.Oracle9Dialect.<BR />14:56:16,966 INFO&nbsp; [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).<BR />14:56:57,182 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.Oracle9Dialect-29772.sql (Generated).<BR />14:56:57,959 INFO&nbsp; [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).<BR />14:56:58,723 INFO&nbsp; [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).<BR />14:56:59,300 INFO&nbsp; [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).<BR />14:56:59,615 INFO&nbsp; [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).<BR />14:56:59,810 INFO&nbsp; [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).<BR />14:56:59,976 INFO&nbsp; [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).<BR />14:56:59,987 INFO&nbsp; [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).<BR />14:56:59,997 INFO&nbsp; [org.alfresco.repo.domain.schema.SchemaBootstrap] All executed statements written to file /alf/tmp/tomcat/Alfresco/AlfrescoSchemaUpdate-All_Statements-29780.sql.<BR />14:57:02,337 WARN&nbsp; [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment<BR />14:57:02,384 WARN&nbsp; [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment<BR />14:57:02,410 WARN&nbsp; [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment<BR />14:57:02,426 WARN&nbsp; [org.jbpm.jpdl.xml.JpdlXmlReader] process xml warning: swimlane 'initiator' does not have an assignment<BR />14:57:04,850 INFO&nbsp; [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /alf/alf_data<BR />14:57:04,898 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed<BR />org.alfresco.error.AlfrescoRuntimeException: The store 'user://alfrescoUserStore' has a duplicate root node entry.<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.admin.ConfigurationChecker.check(ConfigurationChecker.java:268)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.admin.ConfigurationChecker.access$000(ConfigurationChecker.java:72)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.admin.ConfigurationChecker$1.execute(ConfigurationChecker.java:178)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:236)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:185)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.repo.admin.ConfigurationChecker.onBootstrap(ConfigurationChecker.java:182)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:241)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardService.start(StandardService.java:516)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Catalina.start(Catalina.java:566)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Thu, 07 Feb 2008 21:06:44 GMT unknown-user 2008-02-07T21:06:44Z ERROR: Upgrade from 2.1CE to 2.9B CE (OracleDB) https://connect.hyland.com/t5/alfresco-archive/error-upgrade-from-2-1ce-to-2-9b-ce-oracledb/m-p/151536#M106284 Env: RHEL 5(x86_32), Tomcat 6.0.13, Java6u2, Alfresco 2.9B CE, OracleDBThe upgrade scripts execute but then the initialization fails with<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />rg.alfresco.error.AlfrescoRuntimeException: The store 'user://alfrescoUserStore' has a duplicate root node entry.Anyone else encounter this error and have a reme Thu, 07 Feb 2008 21:06:44 GMT https://connect.hyland.com/t5/alfresco-archive/error-upgrade-from-2-1ce-to-2-9b-ce-oracledb/m-p/151536#M106284 unknown-user 2008-02-07T21:06:44Z Re: ERROR: Upgrade from 2.1CE to 2.9B CE (OracleDB) https://connect.hyland.com/t5/alfresco-archive/error-upgrade-from-2-1ce-to-2-9b-ce-oracledb/m-p/151537#M106285 <HTML><HEAD></HEAD><BODY><SPAN>Doah. Removed the Lucene index directories, dropped the DB and re-initialized. Past this error.</SPAN></BODY></HTML> Thu, 07 Feb 2008 23:05:31 GMT https://connect.hyland.com/t5/alfresco-archive/error-upgrade-from-2-1ce-to-2-9b-ce-oracledb/m-p/151537#M106285 unknown-user 2008-02-07T23:05:31Z