cancel
Showing results for 
Search instead for 
Did you mean: 

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

nickbsd
Champ in-the-making
Champ in-the-making
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] complete
09: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 directory
09: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 failed
org.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 more
Caused 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 more
Caused 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 more
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:806)
   … 74 more
09:13:47,804 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
09:13:48,394 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
09:13:48,395 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
09:13:48,398 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
09:13:50,070 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 302 Web Scripts (+0 failed), 312 URLs
09: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 ftl
09:13:50,738 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
09: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] complete
09: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 directory
09:20:42,757 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
09: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 failed
org.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 more
09: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] complete
09: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 directory
09:23:49,217 WARN  [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
09: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 failed
org.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 more
09:24:03,527 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
09:24:04,169 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
09:24:04,170 INFO  [org.springframework.extensions.webscripts.TemplateProcessorRegistry] Registered template processor freemarker for extension ftl
09:24:04,173 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js
09:24:05,850 INFO  [org.springframework.extensions.webscripts.DeclarativeRegistry] Registered 302 Web Scripts (+0 failed), 312 URLs
09: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 ftl
09:24:06,489 INFO  [org.springframework.extensions.webscripts.ScriptProcessorRegistry] Registered script processor javascript for extension js

Repository Schema Information

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

loftux
Star Contributor
Star Contributor
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
Champ in-the-making
Champ in-the-making
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
Champ in-the-making
Champ in-the-making
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.29
Mar 2, 2012 4:40:05 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor alfresco.xml
Mar 2, 2012 4:40:05 PM org.apache.catalina.core.StandardContext addApplicationListener
INFO: 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_TASK
add 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 more
2012-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)