topic TimerStartEvent Process causes error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/timerstartevent-process-causes-error/m-p/172020#M125252 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I work with TimerStartEvent before and it works fine.&nbsp; This particular process has TimerStartEvent.&nbsp; It start a JavaServiceTask.&nbsp; There was a problem with the JavaServiceTask (I have not figured out yet).&nbsp; However, if I shut down Tomcat, and restart Tomcat, it gives me this error.&nbsp;&nbsp;&nbsp; My question is, what would cause this error?</SPAN><BR /><BR /><SPAN>Oct 22, 2013 1:49:47 PM org.apache.catalina.core.ApplicationContext log</SPAN><BR /><SPAN>INFO: No Spring WebApplicationInitializer types detected on classpath</SPAN><BR /><SPAN>Oct 22, 2013 1:49:47 PM org.apache.catalina.core.ApplicationContext log</SPAN><BR /><SPAN>INFO: Initializing Spring root WebApplicationContext</SPAN><BR /><SPAN>Oct 22, 2013 1:49:52 PM org.apache.catalina.core.StandardContext listenerStart</SPAN><BR /><SPAN>SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener</SPAN><BR /><SPAN>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'demoDataGenerator' defined in ServletContext resource [/WEB-INF/activiti-standalone-context.xml]: Cannot resolve reference to bean 'processEngine' while setting bean property 'processEngine'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_HI_TASKINST </SPAN><BR /><SPAN>add CLAIM_TIME_ datetime</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1113)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1671)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.FutureTask.run(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Unknown Source)</SPAN><BR /><SPAN>Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine': FactoryBean threw exception on object creation; nested exception is org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_HI_TASKINST </SPAN><BR /><SPAN>add CLAIM_TIME_ datetime</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1442)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:305)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 28 more</SPAN><BR /><SPAN>Caused by: org.activiti.engine.ActivitiException: couldn't upgrade db schema: alter table ACT_HI_TASKINST </SPAN><BR /><SPAN>add CLAIM_TIME_ datetime</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:954)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:879)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpgrade(DbSqlSession.java:858)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:736)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1013)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:61)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.ProcessEngineImpl.&lt;init&gt;(ProcessEngineImpl.java:76)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:365)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:64)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 33 more</SPAN><BR /><SPAN>Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Duplicate column name 'CLAIM_TIME_'</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at com.mysql.jdbc.Statement.execute(Statement.java:727)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.activiti.engine.impl.db.DbSqlSession.executeSchemaResource(DbSqlSession.java:928)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;… 50 more</SPAN><BR /><BR /><SPAN>Oct 22, 2013 1:49:52 PM org.apache.catalina.core.ApplicationContext log</SPAN><BR /><SPAN>INFO: Closing Spring root WebApplicationContext</SPAN><BR /><SPAN>Oct 22, 2013 1:49:56 PM org.apache.catalina.core.ApplicationContext log</SPAN><BR /><SPAN>INFO: ContextListener: contextInitialized()</SPAN><BR /><SPAN>Oct 22, 2013 1:49:56 PM org.apache.catalina.core.ApplicationContext log</SPAN><BR /><SPAN>INFO: SessionListener: contextInitialized()</SPAN><BR /><SPAN>Oct 22, 2013 1:49:56 PM org.apache.catalina.core.ApplicationContext log</SPAN><BR /><SPAN>INFO: ContextListener: attributeAdded('org.apache.jasper.compiler.TldLocationsCache', 'org.apache.jasper.compiler.TldLocationsCache@23b21e3')</SPAN><BR /></BODY></HTML> Tue, 22 Oct 2013 20:55:05 GMT houstoniasian 2013-10-22T20:55:05Z TimerStartEvent Process causes error https://connect.hyland.com/t5/alfresco-archive/timerstartevent-process-causes-error/m-p/172020#M125252 Hi,I work with TimerStartEvent before and it works fine.&nbsp; This particular process has TimerStartEvent.&nbsp; It start a JavaServiceTask.&nbsp; There was a problem with the JavaServiceTask (I have not figured out yet).&nbsp; However, if I shut down Tomcat, and restart Tomcat, it gives me this error.&nbsp;&nbsp;&nbsp; My question Tue, 22 Oct 2013 20:55:05 GMT https://connect.hyland.com/t5/alfresco-archive/timerstartevent-process-causes-error/m-p/172020#M125252 houstoniasian 2013-10-22T20:55:05Z Re: TimerStartEvent Process causes error https://connect.hyland.com/t5/alfresco-archive/timerstartevent-process-causes-error/m-p/172021#M125253 <HTML><HEAD></HEAD><BODY><SPAN>it seems that update script is trying to create already existing column in the table</SPAN><BR /><CODE><BR />Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Duplicate column name 'CLAIM_TIME_'<BR /></CODE></BODY></HTML> Wed, 23 Oct 2013 08:39:46 GMT https://connect.hyland.com/t5/alfresco-archive/timerstartevent-process-causes-error/m-p/172021#M125253 martin_grofcik 2013-10-23T08:39:46Z Re: TimerStartEvent Process causes error https://connect.hyland.com/t5/alfresco-archive/timerstartevent-process-causes-error/m-p/172022#M125254 <HTML><HEAD></HEAD><BODY><SPAN>Thank you.&nbsp; This is indeed a side effect of a different problem.&nbsp; I have Activiti-Explorer using 5.13.&nbsp; I have a Java app using 5.11.&nbsp; As soon as I run something in my Java app, it "upgrade" database from 5.13 to 5.11.&nbsp; Activitii-Explorer in turn decides to upgrade the database and that's when this happens.&nbsp; So for everyone else, make sure you use the same versions for both Activiti-Explorer and your own app or you will run to this problem like mine.</SPAN></BODY></HTML> Wed, 23 Oct 2013 17:35:58 GMT https://connect.hyland.com/t5/alfresco-archive/timerstartevent-process-causes-error/m-p/172022#M125254 houstoniasian 2013-10-23T17:35:58Z