topic Migration from 2.2 to 3.2 Issue in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216420#M169550 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>I'm currently working on a migration from Alfresco 2.2 to 3.2. I did a fresh install of 3.2, ran it, and Alfresco automatically created the db and file repository. I then followed the cold restore/backup procedure, and replaced the repository and database with the 2.2 data. </SPAN><BR /><BR /><SPAN>The migration began fine, as the schema started getting patched upon start. However, I've been running into the following fatal exception:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>13:58:19,592 User:System ERROR [web.context.ContextLoader] Context initialization failed<BR />org.alfresco.error.AlfrescoRuntimeException: 08090000 Workflow deployment failed<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:336)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer$1.doWork(WorkflowDeployer.java:443)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.onBootstrap(WorkflowDeployer.java:439)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:516)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:583)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)<BR />Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [org.jbpm.instantiation.Delegation]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.instantiation.Delegation]<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:621)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.springmodules.workflow.jbpm31.JbpmTemplate.execute(JbpmTemplate.java:80)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.jbpm.JBPMEngine.deployDefinition(JBPMEngine.java:308)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowServiceImpl.deployDefinition(WorkflowServiceImpl.java:174)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy44.deployDefinition(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.WorkflowDeployer.init(WorkflowDeployer.java:306)<BR />&nbsp;&nbsp;&nbsp;… 38 more<BR />Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.instantiation.Delegation]<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:322)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:218)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascade(Cascade.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.cascadeBeforeSave(AbstractSaveEventListener.java:431)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:265)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:218)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascade(Cascade.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:218)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.Cascade.cascade(Cascade.java:130)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:456)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:334)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1202)<BR />&nbsp;&nbsp;&nbsp;at $Proxy74.save(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:87)<BR />&nbsp;&nbsp;&nbsp;at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.workflow.jbpm.JBPMEngine$1.doInJbpm(JBPMEngine.java:316)<BR />&nbsp;&nbsp;&nbsp;at org.springmodules.workflow.jbpm31.JbpmTemplate$1.doInHibernate(JbpmTemplate.java:87)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)<BR />&nbsp;&nbsp;&nbsp;… 61 more<BR />Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`alfresco`.`JBPM_DELEGATION`, CONSTRAINT `FK_DELEGATION_PRCD` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`))<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:513)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Util.getInstance(Util.java:381)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)<BR />&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)<BR />&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:33)<BR />&nbsp;&nbsp;&nbsp;… 140 more<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Any insight would be helpful.</SPAN><BR /><BR /><SPAN>Thank-you!</SPAN></BODY></HTML> Wed, 09 Sep 2009 18:14:45 GMT keidoo 2009-09-09T18:14:45Z Migration from 2.2 to 3.2 Issue https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216420#M169550 Hello,I'm currently working on a migration from Alfresco 2.2 to 3.2. I did a fresh install of 3.2, ran it, and Alfresco automatically created the db and file repository. I then followed the cold restore/backup procedure, and replaced the repository and database with the 2.2 data. The migration began Wed, 09 Sep 2009 18:14:45 GMT https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216420#M169550 keidoo 2009-09-09T18:14:45Z Re: Migration from 2.2 to 3.2 Issue https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216421#M169551 <HTML><HEAD></HEAD><BODY><SPAN>What you can use is an ETL tool. There are open source tools available for free.</SPAN><BR /><SPAN>Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user.</SPAN><BR /><BR /><SPAN>What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes. For more information: </SPAN><A href="http://www.talend.com/" rel="nofollow noopener noreferrer">http://www.talend.com/</A></BODY></HTML> Fri, 11 Sep 2009 10:12:19 GMT https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216421#M169551 groutal 2009-09-11T10:12:19Z Re: Migration from 2.2 to 3.2 Issue https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216422#M169552 <HTML><HEAD></HEAD><BODY><SPAN>Your problem is related to the JPBM tables.&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><BR /><SPAN>Are you perhaps missing a workflow definition on your new installation?</SPAN></BODY></HTML> Fri, 11 Sep 2009 13:55:42 GMT https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216422#M169552 mrogers 2009-09-11T13:55:42Z Re: Migration from 2.2 to 3.2 Issue https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216423#M169553 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Your problem is related to the JPBM tables.&nbsp;&nbsp;&nbsp;&nbsp; <BR /><BR />Are you perhaps missing a workflow definition on your new installation?</BLOCKQUOTE><BR /><SPAN>I believe we are missing workflows from the original installation. When we configured 2.2, we deleted some workflows not pertinent to us (not knowing the consequences). The new 3.2 installation is a full installation, no customizations.</SPAN></BODY></HTML> Sat, 12 Sep 2009 03:02:54 GMT https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216423#M169553 keidoo 2009-09-12T03:02:54Z Re: Migration from 2.2 to 3.2 Issue https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216424#M169554 <HTML><HEAD></HEAD><BODY><SPAN>Take a look at the JBMP tables and see if there is any data that you can clear out.&nbsp;&nbsp;&nbsp;&nbsp; Do you have any "in flight" workflows that you care about, if not experiment with dropping the&nbsp; content in the tables beginning with JBPM_.</SPAN></BODY></HTML> Sat, 12 Sep 2009 10:07:18 GMT https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216424#M169554 mrogers 2009-09-12T10:07:18Z Re: Migration from 2.2 to 3.2 Issue https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216425#M169555 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">Take a look at the JBMP tables and see if there is any data that you can clear out.&nbsp;&nbsp;&nbsp;&nbsp; Do you have any "in flight" workflows that you care about, if not experiment with dropping the&nbsp; content in the tables beginning with JBPM_.</BLOCKQUOTE><BR /><SPAN>Thanks! Clearing the JBPM tables seemed to do the trick. We were able to startup alfresco 3.2 and access some of our documents.</SPAN></BODY></HTML> Sun, 13 Sep 2009 03:18:09 GMT https://connect.hyland.com/t5/alfresco-archive/migration-from-2-2-to-3-2-issue/m-p/216425#M169555 keidoo 2009-09-13T03:18:09Z