AnsweredAssumed Answered

Migration to MySQL from Ingres

Question asked by kmehta31 on Sep 6, 2010
Latest reply on Sep 9, 2010 by mrogers
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] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Failed to initialise org.alfresco.enterprise.heartbeat.HeartBeat
   at org.alfresco.repo.descriptor.DescriptorServiceImpl.constructSpecialService(DescriptorServiceImpl.java:280)
   at org.alfresco.repo.descriptor.DescriptorServiceImpl.access$100(DescriptorServiceImpl.java:51)
   at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:198)
   at org.alfresco.repo.descriptor.DescriptorServiceImpl$1.execute(DescriptorServiceImpl.java:172)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:322)
   at org.alfresco.repo.descriptor.DescriptorServiceImpl$2.doWork(DescriptorServiceImpl.java:215)
   at org.alfresco.repo.descriptor.DescriptorServiceImpl$2.doWork(DescriptorServiceImpl.java:213)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)
   at org.alfresco.repo.descriptor.DescriptorServiceImpl.onBootstrap(DescriptorServiceImpl.java:211)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   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:525)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.lang.reflect.InvocationTargetException
   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 org.alfresco.repo.descriptor.DescriptorServiceImpl.constructSpecialService(DescriptorServiceImpl.java:265)
   … 42 more
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.
   at org.alfresco.enterprise.heartbeat.HeartBeat.<init>(HeartBeat.java:203)
   at org.alfresco.enterprise.heartbeat.HeartBeat.<init>(HeartBeat.java:132)
   … 47 more
Caused by: org.quartz.ObjectAlreadyExistsException: Unable to store Job with name: 'heartbeat' and group: 'DEFAULT', because one already exists with this identification.
   at org.quartz.simpl.RAMJobStore.storeJob(RAMJobStore.java:222)
   at org.quartz.simpl.RAMJobStore.storeJobAndTrigger(RAMJobStore.java:195)
   at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:703)
   at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:255)
   at org.alfresco.enterprise.heartbeat.HeartBeat.<init>(HeartBeat.java:195)
   … 48 more

Outcomes