Alfresco Upgrade 3.4e to 4.0.a DB scheme update [URGENT]

[nickbsd]

Can someone please help me with the DB upgrade process. I've been struggling to upgrade the MySQL database which results in Alfresco failing to start. I've attached the alfresco.log for reference.

I understand there are additional errors here which I'm still working out.

I can provide access to a WebEx session if someone can spare a few minutes to show me what's going on. I have a production environment in 3.X that I need to migrate over to 4.X and all attempts to do so in the dev environment has failed.

09:13:14,377 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]09:13:14,443 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete09:13:19,577 WARN  [org.springframework.core.io.support.PathMatchingResourcePatternResolver] Skipping [/usr/local/apache-tomcat-6.0/shared/classes/alfresco/extension/subsystems/Authentication/alfrescoNtlm/alfrescoNtlm1] because it does not denote a directory09:13:32,629 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]09:13:32,630 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]09:13:32,634 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activitiParseListener' defined in class path resource [alfresco/activiti-context.xml]: Cannot resolve reference to bean 'activitiCreateTaskListener' while setting bean property 'createTaskListener'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activitiWorkflowManager' defined in class path resource [alfresco/activiti-context.xml]: Cannot resolve reference to bean 'activitiProcessEngine' while setting bean property 'processEngine'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activitiProcessEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_TASK add OWNER_ varchar(64)   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)   at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)   at org.apache.catalina.core.StandardService.start(StandardService.java:525)   at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)   at org.apache.catalina.startup.Catalina.start(Catalina.java:595)   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:289)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activitiWorkflowManager' defined in class path resource [alfresco/activiti-context.xml]: Cannot resolve reference to bean 'activitiProcessEngine' while setting bean property 'processEngine'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activitiProcessEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_TASK add OWNER_ varchar(64)   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:281)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)   … 40 moreCaused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activitiProcessEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_TASK add OWNER_ varchar(64)   at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)   at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)   at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1429)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)   … 52 moreCaused by: org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_TASK add OWNER_ varchar(64)   at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:832)   at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:760)   at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpgrade(DbSqlSession.java:739)   at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:656)   at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:901)   at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:33)   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)   at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:80)   at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:282)   at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:60)   at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56)   at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)   at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)   … 57 moreCaused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'OWNER_'   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)   at java.lang.reflect.Constructor.newInstance(Constructor.java:513)   at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)   at com.mysql.jdbc.Util.getInstance(Util.java:384)   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562)   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2512)   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:781)   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:624)   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)   at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:806)   … 74 more09:13:47,804 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl09:13:48,394 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js09:13:48,395 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl09:13:48,398 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js09:13:50,070 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 302 Web Scripts (+0 failed), 312 URLs09:13:50,070 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 09:13:50,071 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 09:13:50,729 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2326.315ms)09:13:50,734 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl09:13:50,738 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js09:20:27,032 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]09:20:27,102 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete09:20:32,207 WARN  [org.springframework.core.io.support.PathMatchingResourcePatternResolver] Skipping [/usr/local/apache-tomcat-6.0/shared/classes/alfresco/extension/subsystems/Authentication/alfrescoNtlm/alfrescoNtlm1] because it does not denote a directory09:20:42,757 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled09:20:42,923 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]09:20:42,924 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]09:20:42,928 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'avmRemoteService' defined in class path resource [alfresco/remote-services-context.xml]: Invocation of init method failed; nested exception is java.rmi.server.ExportException: internal error: ObjID already in use   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)   at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1276)   at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:625)   at org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:136)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)   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.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:186)   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:563)   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:291)   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)   at java.lang.Thread.run(Thread.java:619)Caused by: java.rmi.server.ExportException: internal error: ObjID already in use   at sun.rmi.transport.ObjectTable.putTarget(ObjectTable.java:169)   at sun.rmi.transport.Transport.exportObject(Transport.java:74)   at sun.rmi.transport.tcp.TCPTransport.exportObject(TCPTransport.java:229)   at sun.rmi.transport.tcp.TCPEndpoint.exportObject(TCPEndpoint.java:393)   at sun.rmi.transport.LiveRef.exportObject(LiveRef.java:129)   at sun.rmi.server.UnicastServerRef.exportObject(UnicastServerRef.java:190)   at sun.rmi.registry.RegistryImpl.setup(RegistryImpl.java:92)   at sun.rmi.registry.RegistryImpl.<init>(RegistryImpl.java:68)   at java.rmi.registry.LocateRegistry.createRegistry(LocateRegistry.java:222)   at org.springframework.remoting.rmi.RmiServiceExporter.getRegistry(RmiServiceExporter.java:371)   at org.springframework.remoting.rmi.RmiServiceExporter.getRegistry(RmiServiceExporter.java:336)   at org.springframework.remoting.rmi.RmiServiceExporter.prepare(RmiServiceExporter.java:268)   at org.springframework.remoting.rmi.RmiServiceExporter.afterPropertiesSet(RmiServiceExporter.java:229)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)   … 36 more09:23:28,983 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]09:23:29,061 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete09:23:34,366 WARN  [org.springframework.core.io.support.PathMatchingResourcePatternResolver] Skipping [/usr/local/apache-tomcat-6.0/shared/classes/alfresco/extension/subsystems/Authentication/alfrescoNtlm/alfrescoNtlm1] because it does not denote a directory09:23:49,217 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled09:23:49,506 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]09:23:49,507 INFO  [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]09:23:49,511 ERROR [org.springframework.web.context.ContextLoader] Context initialization failedorg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'avmRemoteService' defined in class path resource [alfresco/remote-services-context.xml]: Invocation of init method failed; nested exception is java.rmi.server.ExportException: internal error: ObjID already in use   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)   at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)   at org.apache.catalina.core.StandardService.start(StandardService.java:525)   at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)   at org.apache.catalina.startup.Catalina.start(Catalina.java:595)   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:289)   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: java.rmi.server.ExportException: internal error: ObjID already in use   at sun.rmi.transport.ObjectTable.putTarget(ObjectTable.java:169)   at sun.rmi.transport.Transport.exportObject(Transport.java:74)   at sun.rmi.transport.tcp.TCPTransport.exportObject(TCPTransport.java:229)   at sun.rmi.transport.tcp.TCPEndpoint.exportObject(TCPEndpoint.java:393)   at sun.rmi.transport.LiveRef.exportObject(LiveRef.java:129)   at sun.rmi.server.UnicastServerRef.exportObject(UnicastServerRef.java:190)   at sun.rmi.registry.RegistryImpl.setup(RegistryImpl.java:92)   at sun.rmi.registry.RegistryImpl.<init>(RegistryImpl.java:68)   at java.rmi.registry.LocateRegistry.createRegistry(LocateRegistry.java:222)   at org.springframework.remoting.rmi.RmiServiceExporter.getRegistry(RmiServiceExporter.java:371)   at org.springframework.remoting.rmi.RmiServiceExporter.getRegistry(RmiServiceExporter.java:336)   at org.springframework.remoting.rmi.RmiServiceExporter.prepare(RmiServiceExporter.java:268)   at org.springframework.remoting.rmi.RmiServiceExporter.afterPropertiesSet(RmiServiceExporter.java:229)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)   … 37 more09:24:03,527 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl09:24:04,169 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js09:24:04,170 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl09:24:04,173 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js09:24:05,850 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 302 Web Scripts (+0 failed), 312 URLs09:24:05,851 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 8 Package Description Documents (+0 failed) 09:24:05,851 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 0 Schema Description Documents (+0 failed) 09:24:06,481 INFO  [org.springframework.extensions.webscripts.AbstractRuntimeContainer] Initialised Spring Surf Container Web Script Container (in 2303.793ms)09:24:06,486 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl09:24:06,489 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Repository Schema Information

   Property   ValueInstalled Schema   4113Installed Version   3.4.0 (d 3370)Server Schema   4113Server Version   3.4.0 (e 3419)patch.AVMGuidPatch   Fri Jul 08 14:46:42 PDT 2011 - Set GUIDs on AVM nodes. - Succeededpatch.AVMLayeredSnapshot   Fri Jul 08 14:46:42 PDT 2011 - Set indirectionVersion on Layered Nodes. - Succeededpatch.InvalidNameEnding   Fri Jul 08 14:46:42 PDT 2011 - Fixes names ending with a space or full stop. - Succeededpatch.LinkNodeFileExtension   Fri Jul 08 14:46:42 PDT 2011 - Fixes link node file extensions to have a .url extension. - Succeededpatch.ReadmeTemplate   Fri Jul 08 14:46:42 PDT 2011 - Deployed ReadMe Template - Succeededpatch.actionRuleDecouplingPatch   Fri Jul 08 14:46:42 PDT 2011 - Migrate existing rules to the updated model where rules are decoupled from actions. - Succeededpatch.actions.scheduledfolder   Fri Jul 08 14:46:43 PDT 2011 - Creates the scheduled actions folder in the Data Dictionary. - Succeededpatch.authorityDefaultZonesPatch   Fri Jul 08 14:46:43 PDT 2011 - Adds groups and people to the appropriate zones for wcm, share and everything else. - Succeededpatch.authorityMigration   Fri Jul 08 14:46:43 PDT 2011 - Copies any old authorities from the user store to the spaces store. - Succeededpatch.avmFormPropertyIdentifier   Fri Jul 08 14:46:42 PDT 2011 - Reindex wca:webform to make wca:formname an identifier - Succeededpatch.avmStoreAsIdentifier   Fri Jul 08 14:46:42 PDT 2011 - Reindex wca:webfolder to make wca:avmstore an identifier - Succeededpatch.avmWebProjectInheritPermissions02   Fri Jul 08 14:46:42 PDT 2011 - Break inheritance of permissions on wca:webfolder object to hide access by default. - Succeededpatch.calendarNamespaceUri   Fri Jul 08 14:46:43 PDT 2011 - Update the Calendar model namespace URI and reindex all calendar objects. - Succeededpatch.categoryRootPermission   Fri Jul 08 14:46:42 PDT 2011 - Sets required permissions on 'Category Root' folder. - Succeededpatch.contentFormFolderType   Fri Jul 08 14:46:42 PDT 2011 - Update WCM Content Form folder type. - Succeededpatch.contentPermission   Fri Jul 08 14:46:42 PDT 2011 - Update permission entries from 'cm:content' to 'sys:base'. - Succeededpatch.convertContentUrls   Fri Jul 08 14:46:43 PDT 2011 - Converts pre-3.2 content URLs to use the alf_content_data table. The conversion work can also be done on a schedule; please contact Alfresco Support for further details. - Succeededpatch.createSiteStore   Fri Jul 08 14:46:42 PDT 2011 - Create the AVM store for site data structure for 3.0 web-tier clients. - Succeededpatch.customMessages   Fri Jul 08 14:46:42 PDT 2011 - Adds 'Messages' folder to Data Dictionary - Succeededpatch.customModels   Fri Jul 08 14:46:42 PDT 2011 - Adds 'Models' folder to Data Dictionary - Succeededpatch.customWebClientExtension   Fri Jul 08 14:46:42 PDT 2011 - Adds 'Web Client Extension' folder to Data Dictionary - Succeededpatch.customWorkflowDefs   Fri Jul 08 14:46:42 PDT 2011 - Adds 'Workflow Definitions' folder to Data Dictionary. - Succeededpatch.db-V1.4-TxnCommitTimeIndex   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.0-ContentUrls   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.1-AuditPathIndex   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.1-JBPMProcessKey   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.1-JBPMUpdate   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.1-NotNullColumns   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.1-RemoveWcmSubmittedAspect   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.1-VersionColumns2   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.2-0-CreateMissingTables   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.2-2-MoveQNames   Fri Jul 08 14:46:42 PDT 2011 - A placeholder patch; usually marks a superceded patch. - Succeededpatch.db-V2.2-ACL   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.2-ACL-From-2.1-A   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.2-CleanNodeStatuses   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.2-Person-3   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.2-Upgrade-From-2.1   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V2.2-Upgrade-From-2.2SP1   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.0-0-CreateActivitiesExtras   Fri Jul 08 14:46:42 PDT 2011 - Replaced by 'patch.db-V3.0-ActivityTables', which must run first. - Succeededpatch.db-V3.0-ActivityTables   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.0: Activity Tables - Succeededpatch.db-V3.1-Allow-IPv6   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.2-AddFKIndexes   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.2-AddFKIndexes-2   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.2-AuditTables   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.2: Audit Tables - Succeededpatch.db-V3.2-AvmTables   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.2: AVM Tables - Succeededpatch.db-V3.2-Child-Assoc-QName-CRC   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.2-ContentTables   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.2: Content Tables - Succeededpatch.db-V3.2-ContentTables2   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.2-LockTables   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.2: Lock Tables - Succeededpatch.db-V3.2-Modify-AVM-MimeType   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.2-PropertyValueTables   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.2: PropertyValue Tables - Succeededpatch.db-V3.2-Remove-AVM-Issuer   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.2-Upgrade-JBPM   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.3-Fix-AVM-Seqs   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.3-Fix-Repo-Seqs   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.3-JBPM-Extra   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.3 fix problems in JBPM tables - Succeededpatch.db-V3.3-Node-Prop-Serializable   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.3-Remove-VersionCount   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.3-modify-index-permission_id   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.4-UsageTables   Fri Jul 08 14:46:42 PDT 2011 - Manually executed script upgrade V3.4: Usage Tables - Succeededpatch.db-V3.4-child-assoc-indexes   Fri Jul 08 14:46:43 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.db-V3.4-property-unique-ctx-value   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.deploySubmitDirectProcess   Fri Jul 08 14:46:43 PDT 2011 - Deploy WCM Direct Submit Process Definition. - Succeededpatch.deploymentMigration   Fri Jul 08 14:46:42 PDT 2011 - Migrates deployment data to the new model. - Succeededpatch.descriptorUpdate   Fri Jul 08 14:46:42 PDT 2011 - Update Repository descriptor - Succeededpatch.eliminateDuplicates   Fri Jul 08 14:46:43 PDT 2011 - Fixes ALF-4203: Searches for AVM duplicate nodes and changes their name - Succeededpatch.emailInviteAndNotifyTemplatesFolder   Fri Jul 08 14:46:43 PDT 2011 - Ensures the existence of the 'Email Invite Templates' and 'Email Notify Templates' folders. - Succeededpatch.emailTemplatesContent   Fri Jul 08 14:46:42 PDT 2011 - Loads the email templates into the Email Templates folder. - Succeededpatch.emailTemplatesFolder   Fri Jul 08 14:46:42 PDT 2011 - Ensures the existence of the 'Email Templates' folder. - Succeededpatch.fixAuthoritiesCrcValues   Fri Jul 08 14:46:43 PDT 2011 - Fixes authority CRC32 values to match UTF-8 encoding. - Succeededpatch.fixNameCrcValues-2   Fri Jul 08 14:46:42 PDT 2011 - Fixes name and qname CRC32 values to match UTF-8 encoding. - Succeededpatch.fixNodeSerializableValues   Fri Jul 08 14:46:42 PDT 2011 - Ensure that property values are not stored as Serializable if at all possible - Succeededpatch.formsFolder   Fri Jul 08 14:46:42 PDT 2011 - Adds 'Forms' folder to Data Dictionary. - Succeededpatch.forumsIcons   Fri Jul 08 14:46:42 PDT 2011 - Updates forums icon references - Succeededpatch.groupMembersAsIdentifiers   Fri Jul 08 14:46:42 PDT 2011 - Reindex usr:authorityContainer members as identifiers - Succeededpatch.groupNamesAsIdentifiers   Fri Jul 08 14:46:42 PDT 2011 - Reindex usr:authorityContainer gids as identifiers - Succeededpatch.guestPersonPermission   Fri Jul 08 14:46:42 PDT 2011 - Change Guest Person permission from 'Consumer' to 'Read' - Succeededpatch.guestPersonPermission2   Fri Jul 08 14:46:42 PDT 2011 - Change Guest Person permission to visible by all users as 'Consumer'. - Succeededpatch.guestUser   Fri Jul 08 14:46:42 PDT 2011 - Add the guest user, guest home space; and fix permissions on company home, guest home and guest person. - Succeededpatch.imapFolders   Fri Jul 08 14:46:43 PDT 2011 - Creates folders tree necessary for IMAP functionality - Succeededpatch.invalidUserPersonAndGroup   Fri Jul 08 14:46:42 PDT 2011 - Fix up invalid uids for people and users; and invalid gids for groups - Succeededpatch.invitationMigration   Fri Jul 08 14:46:43 PDT 2011 - Migrate invitations from old invite service to invitation service - Succeededpatch.inviteEmailTemplate   Fri Jul 08 14:46:43 PDT 2011 - Adds invite email template to invite space - Succeededpatch.migrateAttrAVMLocks   Fri Jul 08 14:46:43 PDT 2011 - Migrate old AVM Lock attributes - Succeededpatch.migrateAttrChainingURS   Fri Jul 08 14:46:43 PDT 2011 - Migrate old Chaining User Registry Synchronizer attributes - Succeededpatch.migrateAttrDelete   Fri Jul 08 14:46:43 PDT 2011 - Delete old attributes (if any) after they have been migrated - Succeededpatch.migrateAttrPropBackedBeans   Fri Jul 08 14:46:43 PDT 2011 - Migrate old Property-Backed Bean component attributes - Succeededpatch.migrateAttrTenants   Fri Jul 08 14:46:42 PDT 2011 - Migrate old Tenant attributes - Succeededpatch.migrateVersionStore   Fri Jul 08 14:46:43 PDT 2011 - Version Store migration (from lightWeightVersionStore to version2Store) - Succeededpatch.moveWCMToGroupBasedPermissionsPatch   Fri Jul 08 14:46:43 PDT 2011 - A placeholder patch; usually marks a superceded patch. - Succeededpatch.mtShareExistingTenants   Fri Jul 08 14:46:43 PDT 2011 - Update existing tenants for MT Share. - Succeededpatch.multilingualBootstrap   Fri Jul 08 14:46:42 PDT 2011 - Bootstraps the node that will hold the multilingual containers. - Succeededpatch.personUsagePatch   Fri Jul 08 14:46:43 PDT 2011 - Add person 'cm:sizeCurrent' property (if missing). - Succeededpatch.redeployInvitationProcess   Fri Jul 08 14:46:43 PDT 2011 - Re-deploy Invitation Process Definitions. - Succeededpatch.redeployNominatedInvitationProcessWithPropsForShare   Fri Jul 08 14:46:43 PDT 2011 - Redeploy nominated invitation workflow - Succeededpatch.redeploySubmitProcess   Fri Jul 08 14:46:42 PDT 2011 - Re-deploy WCM Submit Process Definition. - Succeededpatch.redeploySubmitProcess4   Fri Jul 08 14:46:43 PDT 2011 - Re-deploy WCM Submit Process Definition. - Succeededpatch.redeploySubmitProcess5   Fri Jul 08 14:46:43 PDT 2011 - Re-deploy WCM Submit Process Definition. - Succeededpatch.redeploySubmitProcess6   Fri Jul 08 14:46:43 PDT 2011 - Re-deploy WCM Submit Process Definition. - Succeededpatch.redeploySubmitProcess7   Fri Jul 08 14:46:43 PDT 2011 - Re-deploy WCM Submit Process Definition. - Succeededpatch.rendition.rendering_actions   Fri Jul 08 14:46:43 PDT 2011 - Creates the Rendering Actions folder. - Succeededpatch.replication.replication_actions   Fri Jul 08 14:46:43 PDT 2011 - Creates the Replication Actions folder. - Succeededpatch.resetWCMToGroupBasedPermissionsPatch   Fri Jul 08 14:46:43 PDT 2011 - Reset WCM to group based permissions. - Succeededpatch.rssFolder   Fri Jul 08 14:46:42 PDT 2011 - Ensures the existence of the 'RSS Templates' folder. - Succeededpatch.savedSearchesFolder   Fri Jul 08 14:46:42 PDT 2011 - Ensures the existence of the 'Saved Searches' folder. - Succeededpatch.savedSearchesPermission   Fri Jul 08 14:46:42 PDT 2011 - Sets required permissions on 'Saved Searches' folder. - Succeededpatch.schemaUpdateScript-V1.4-1   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.schemaUpdateScript-V1.4-2   Fri Jul 08 14:46:42 PDT 2011 - Ensures that the database upgrade script has been run. - Succeededpatch.scriptsFolder   Fri Jul 08 14:46:42 PDT 2011 - Ensures the existence of the 'Scripts' folder. - Succeededpatch.sitePermissionRefactorPatch   Fri Jul 08 14:46:43 PDT 2011 - Create permission groups for sites. - Succeededpatch.sitesFolder   Fri Jul 08 14:46:43 PDT 2011 - Adds 'Sites' folder to Company Home. - Succeededpatch.spacesRootPermission   Fri Jul 08 14:46:42 PDT 2011 - Change Spaces store root permission from 'Consumer' to 'Read' - Succeededpatch.spacesStoreGuestPermission   Fri Jul 08 14:46:43 PDT 2011 - Sets READ permissions for GUEST on root node of the SpacesStore. - Succeededpatch.systemDescriptorContent   Fri Jul 08 14:46:42 PDT 2011 - Adds the version properties content to the system descriptor. - Succeededpatch.systemRegistryBootstrap   Fri Jul 08 14:46:42 PDT 2011 - Bootstraps the node that will hold system registry metadata. - Succeededpatch.systemWorkflowFolderPatch   Fri Jul 08 14:46:42 PDT 2011 - Ensures the existence of the system workflow container. - Succeededpatch.tagRootCategory   Fri Jul 08 14:46:42 PDT 2011 - Adds 'Tags' as new top-level category root. - Succeededpatch.thumbnailsAssocQName   Fri Jul 08 14:46:42 PDT 2011 - Update the 'cm:thumbnails' association QName to 'rn:rendition'. - Succeededpatch.topLevelGroupParentChildAssociationTypePatch   Fri Jul 08 14:46:42 PDT 2011 - Ensure top level groups have the correct child association type. - Succeededpatch.transfer.targetrule   Fri Jul 08 14:46:43 PDT 2011 - Creates the transfer target rule for the default transfer group. - Succeededpatch.transfer.targetrulefolder   Fri Jul 08 14:46:43 PDT 2011 - Creates the transfer target rule folder for the default transfer group. - Succeededpatch.transferServiceFolder   Fri Jul 08 14:46:43 PDT 2011 - Add transfer definitions folder to data dictionary. - Succeededpatch.uifacetsTemplates   Fri Jul 08 14:46:42 PDT 2011 - Removes the incorrectly applied uifacets aspect from presentation template files. - Succeededpatch.uniqueChildName   Fri Jul 08 14:46:42 PDT 2011 - Checks and renames duplicate children. - Succeededpatch.updateAvmPermissionData   Fri Jul 08 14:46:42 PDT 2011 - Update avm permissions from 'webfolder' to 'cmobject'. - Succeededpatch.updateDmPermissions   Fri Jul 08 14:46:42 PDT 2011 - Update ACLs on all DM node objects to the new 3.0 permission model - Succeededpatch.updateGuestPermission   Fri Jul 08 14:46:42 PDT 2011 - Rename guest permission from 'Guest' to 'Consumer' - Succeededpatch.updateMimetypes1   Fri Jul 08 14:46:43 PDT 2011 - Fix mimetypes for Excel and Powerpoint. - Succeededpatch.updateMimetypes2   Fri Jul 08 14:46:43 PDT 2011 - Fix mimetypes for Excel and Powerpoint. - Succeededpatch.updatePermissionData   Fri Jul 08 14:46:42 PDT 2011 - Update permissions from 'folder' to 'cmobject' [JIRA: AR-344]. - Succeededpatch.userAndPersonUserNamesAsIdentifiers   Fri Jul 08 14:46:42 PDT 2011 - Reindex usr:user and cm:person uids as identifiers - Succeededpatch.versionHistoryPerformance   Fri Jul 08 14:46:42 PDT 2011 - Improves the performance of version history lookups. - Succeededpatch.wcmPostPermissionSnapshotPatch2   Fri Jul 08 14:46:43 PDT 2011 - A placeholder patch; usually marks a superceded patch. - Succeededpatch.wcmPostPermissionSnapshotPatch3   Fri Jul 08 14:46:43 PDT 2011 - Snapshot stores (after fixing ACLs so they are only set on the staging area store). - Succeededpatch.webScriptsReadme   Fri Jul 08 14:46:42 PDT 2011 - Applied ReadMe template to Web Scripts folders - Succeededpatch.webSiteAddModerated   Fri Jul 08 14:46:43 PDT 2011 - Changing Web Site visibility from a boolean to enum. - Succeededpatch.webscripts   Fri Jul 08 14:46:42 PDT 2011 - Adds Web Scripts to Data Dictionary. - Succeededpatch.webscripts2   Fri Jul 08 14:46:42 PDT 2011 - Adds Web Scripts (second set) to Data Dictionary. - Succeededpatch.webscripts3   Fri Jul 08 14:46:42 PDT 2011 - Update Web Scripts ReadMe. - Succeededpatch.webscriptsExtension   Fri Jul 08 14:46:42 PDT 2011 - Adds Web Scripts Extension to Data Dictionary. - Succeededpatch.zonedAuthorities   Fri Jul 08 14:46:43 PDT 2011 - Adds the remodelled cm:authority container to the spaces store - Succeeded‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[loftux]

It look like the account your are using to connect alfresco the db does not have alter permissions

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'activitiProcessEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_TASK add OWNER_ varchar(64)‍‍

[rmacian]

be careful, I think 3.4e was never considered a production version, it was  experimental to support firsts versions of Activiti. I don't know if the upgrade process has been tested. Can you check with a clean installation the upgrade process form 3.4e to 4.0d to see if it works?

[nickbsd]

Having the same issue after doing the following.

SERVER A running ALF 3.4e

-stopped alfresco+share
-shutdown tomcat
-performed a mysql dump of the 'alfresco' database
-tarred the alf_data directory

SERVER B running ALF 4.0d (latest)
-tested I could logon using admin/admin
-shutdown tomcat
-installed mysql-server
-edited alfresco-global.properties to use mysql instead of postgres
-uploaded the jar mysql connector into the tomcat/lib directory
-untarred alf_data backup and placed it in the folder location that was configured in alfresco-global.properties
-removed the 'contentstore' directory in the alf_data folder
-since this is a new mysql installation, the alfresco table did not exist.
-created alfresco database and assigned alfresco permissions

create database alfresco DEFAULT CHARACTER SET utf8;
grant all on alfresco.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfresco.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;

crossed my fingers and toes and started alfresco.. still, received the same error message.

INFO: Starting Servlet Engine: Apache Tomcat/6.0.29Mar 2, 2012 4:40:05 PM org.apache.catalina.startup.HostConfig deployDescriptorINFO: Deploying configuration descriptor alfresco.xmlMar 2, 2012 4:40:05 PM org.apache.catalina.core.StandardContext addApplicationListenerINFO: The listener "org.apache.myfaces.webapp.StartupServletContextListener" is already configured for this context. The duplicate definition has been ignor$2012-03-02 16:40:17,988  INFO  [management.subsystems.ChildApplicationContextFactory] [main] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default] 2012-03-02 16:40:18,043  INFO  [management.subsystems.ChildApplicationContextFactory] [main] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] compl$ 2012-03-02 16:40:24,795  WARN  [alfresco.util.AbstractTriggerBean] [main] Job ehCacheTracerJob is not active/enabled 2012-03-02 16:40:27,623  INFO  [extensions.webscripts.TemplateProcessorRegistry] [main] Registered template processor Repository Template Processor for ext$ 2012-03-02 16:40:27,625  INFO  [extensions.webscripts.ScriptProcessorRegistry] [main] Registered script processor Repository Script Processor for extension$ 2012-03-02 16:40:33,045  INFO  [domain.schema.SchemaBootstrap] [main] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect. 2012-03-02 16:40:34,031  ERROR [domain.schema.SchemaBootstrap] [main] Schema auto-update failed org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_RU_TASKadd OWNER_ varchar(64)        at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:826)        at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:753)        at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpgrade(DbSqlSession.java:732)        at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:647)        at org.activiti.engine.impl.ManagementServiceImpl$1.execute(ManagementServiceImpl.java:73)        at org.activiti.engine.impl.ManagementServiceImpl$1.execute(ManagementServiceImpl.java:68)        at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)        at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)        at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)        at org.activiti.engine.impl.ManagementServiceImpl.databaseSchemaUpgrade(ManagementServiceImpl.java:68)        at org.alfresco.repo.domain.schema.SchemaBootstrap.initialiseActivitiDBSchema(SchemaBootstrap.java:871)        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:844)        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1479)        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)        at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)        at org.apache.catalina.core.StandardService.start(StandardService.java:519)        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)        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:289)        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'OWNER_'        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)        at com.mysql.jdbc.Util.getInstance(Util.java:384)        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562)        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2512)        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:781)        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:624)        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)        at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:800)        … 46 more2012-03-02 16:40:34,035  ERROR [web.context.ContextLoader] [main] Context initialization failed org.alfresco.error.AlfrescoRuntimeException: 02020000 Schema auto-update failed        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1612)        at org.springframework.extensions.surf.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:56)        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEventInternal(SafeApplicationEventMulticaster.java:209)        at org.alfresco.repo.management.SafeApplicationEventMulticaster.multicastEvent(SafeApplicationEventMulticaster.java:180)        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:303)        at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:911)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:428)        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍