topic Migration to MySQL from Ingres in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/migration-to-mysql-from-ingres/m-p/218028#M171158 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am using Alfresco Enterprise 3.0 and I am trying to migrate databsase to MySQL from Ingres. All data and tables have been copied but I am getting following error when I start Alfresco:</SPAN><BR /><BR /><SPAN>Any help or pointers are highly appreciated.</SPAN><BR /><BR /><SPAN>08:55:57,366 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed</SPAN><BR /><SPAN>org.alfresco.error.AlfrescoRuntimeException: Failed to initialise org.alfresco.enterprise.heartbeat.HeartBeat</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl.constructSpecialService(DescriptorServiceImpl.java:280)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl.access$100(DescriptorServiceImpl.java:51)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:198)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:172)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:322)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl$2.doWork(DescriptorServiceImpl.java:215)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl$2.doWork(DescriptorServiceImpl.java:213)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl.onBootstrap(DescriptorServiceImpl.java:211)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:516)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:578)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)</SPAN><BR /><SPAN>Caused by: java.lang.reflect.InvocationTargetException</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.reflect.Constructor.newInstance(Constructor.java:513)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.repo.descriptor.DescriptorServiceImpl.constructSpecialService(DescriptorServiceImpl.java:265)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 42 more</SPAN><BR /><SPAN>Caused by: java.lang.RuntimeException: org.quartz.ObjectAlreadyExistsException: Unable to store Job with name: 'heartbeat' and group: 'DEFAULT', because one already exists with this identification.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.enterprise.heartbeat.HeartBeat.&lt;init&gt;(HeartBeat.java:203)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.enterprise.heartbeat.HeartBeat.&lt;init&gt;(HeartBeat.java:132)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 47 more</SPAN><BR /><SPAN>Caused by: org.quartz.ObjectAlreadyExistsException: Unable to store Job with name: 'heartbeat' and group: 'DEFAULT', because one already exists with this identification.</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.simpl.RAMJobStore.storeJob(RAMJobStore.java:222)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.simpl.RAMJobStore.storeJobAndTrigger(RAMJobStore.java:195)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:703)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:255)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.alfresco.enterprise.heartbeat.HeartBeat.&lt;init&gt;(HeartBeat.java:195)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 48 more</SPAN></BODY></HTML> Mon, 06 Sep 2010 21:00:27 GMT kmehta31 2010-09-06T21:00:27Z Migration to MySQL from Ingres https://connect.hyland.com/t5/alfresco-archive/migration-to-mysql-from-ingres/m-p/218028#M171158 Hi,I am using Alfresco Enterprise 3.0 and I am trying to migrate databsase to MySQL from Ingres. All data and tables have been copied but I am getting following error when I start Alfresco:Any help or pointers are highly appreciated.08:55:57,366 ERROR [org.springframework.web.context.ContextLoader] Mon, 06 Sep 2010 21:00:27 GMT https://connect.hyland.com/t5/alfresco-archive/migration-to-mysql-from-ingres/m-p/218028#M171158 kmehta31 2010-09-06T21:00:27Z Re: Migration to MySQL from Ingres https://connect.hyland.com/t5/alfresco-archive/migration-to-mysql-from-ingres/m-p/218029#M171159 <HTML><HEAD></HEAD><BODY><SPAN>Please help..Any input is highly appreciated</SPAN></BODY></HTML> Thu, 09 Sep 2010 13:20:20 GMT https://connect.hyland.com/t5/alfresco-archive/migration-to-mysql-from-ingres/m-p/218029#M171159 kmehta31 2010-09-09T13:20:20Z Re: Migration to MySQL from Ingres https://connect.hyland.com/t5/alfresco-archive/migration-to-mysql-from-ingres/m-p/218030#M171160 <HTML><HEAD></HEAD><BODY><SPAN>Since you are using Alfresco Enterprise then please contact Alfresco support.</SPAN></BODY></HTML> Thu, 09 Sep 2010 13:52:08 GMT https://connect.hyland.com/t5/alfresco-archive/migration-to-mysql-from-ingres/m-p/218030#M171160 mrogers 2010-09-09T13:52:08Z