topic Critical in Activiti Engine - 5.11 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/critical-in-activiti-engine-5-11/m-p/167654#M121166 <HTML><HEAD></HEAD><BODY><SPAN>Hi All,</SPAN><BR /><BR /><SPAN>A very critical exception here, please help me out:</SPAN><BR /><BR /><BR /><SPAN>My Process Engine configuration is as follows:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessEngineConfiguration configuration = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; configuration.setDataSourceJndiName("java:jboss/datasources/workflowV2");</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; configuration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; configuration.setJobExecutorActivate(true);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; configuration.setTransactionsExternallyManaged(true);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; _processEngine = configuration.buildProcessEngine();</SPAN><BR /><BR /><SPAN>The total no.of records in act_hi_procinst are : 10479</SPAN><BR /><SPAN> </SPAN><BR /><BR /><SPAN>14:12:23,118 SEVERE [org.activiti.engine.impl.interceptor.CommandContext] (jmsContainer-14) Error while closing command context: org.apache.ibatis.exceptions.PersistenceException:</SPAN><BR /><BR /><SPAN>### Error updating database.&nbsp; Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full</SPAN><BR /><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.HistoricProcessInstanceEntity.insertHistoricProcessInstance-Inline</SPAN><BR /><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><BR /><SPAN>### SQL: insert into ACT_HI_PROCINST (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_INST_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BUSINESS_KEY_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_DEF_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DURATION_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_USER_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_ACT_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_ACT_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUPER_PROCESS_INSTANCE_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE_REASON_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>### Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full</SPAN><BR /><BR /><SPAN> </SPAN><BR /><BR /><SPAN> </SPAN><BR /><BR /><SPAN>14:12:23,287 WARN&nbsp; [org.springframework.jms.listener.DefaultMessageListenerContainer] (jmsContainer-13) Execution of JMS message listener failed, and no ErrorHandler has been set.: org.springframework.jms.listener.adapter.ListenerExecutionFailedException: Listener method 'receive' threw exception; nested exception is org.springframework.integration.MessageDeliveryException: failed to send Message to channel 'PubSubChannel'</SPAN><BR /><BR /><SPAN> </SPAN><BR /><BR /><SPAN>Caused by: org.apache.ibatis.exceptions.PersistenceException:</SPAN><BR /><BR /><SPAN>### Error updating database.&nbsp; Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full</SPAN><BR /><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.HistoricProcessInstanceEntity.insertHistoricProcessInstance-Inline</SPAN><BR /><BR /><SPAN>### The error occurred while setting parameters</SPAN><BR /><BR /><SPAN>### SQL: insert into ACT_HI_PROCINST (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_INST_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BUSINESS_KEY_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PROC_DEF_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_TIME_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DURATION_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_USER_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; START_ACT_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; END_ACT_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SUPER_PROCESS_INSTANCE_ID_,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DELETE_REASON_&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ) values (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )</SPAN><BR /><BR /><SPAN>### Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full</SPAN><BR /><BR /></BODY></HTML> Fri, 18 Oct 2013 12:48:53 GMT c_arunrathnakum 2013-10-18T12:48:53Z Critical in Activiti Engine - 5.11 https://connect.hyland.com/t5/alfresco-archive/critical-in-activiti-engine-5-11/m-p/167654#M121166 Hi All,A very critical exception here, please help me out:My Process Engine configuration is as follows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ProcessEngineConfiguration configuration = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; configuration.setDataSourceJndiName("java:jboss/d Fri, 18 Oct 2013 12:48:53 GMT https://connect.hyland.com/t5/alfresco-archive/critical-in-activiti-engine-5-11/m-p/167654#M121166 c_arunrathnakum 2013-10-18T12:48:53Z Re: Critical in Activiti Engine - 5.11 https://connect.hyland.com/t5/alfresco-archive/critical-in-activiti-engine-5-11/m-p/167655#M121167 <HTML><HEAD></HEAD><BODY><SPAN>I get this exception when i try to instantiate a process.</SPAN><BR /><SPAN>DB is Postgres.</SPAN></BODY></HTML> Fri, 18 Oct 2013 14:15:02 GMT https://connect.hyland.com/t5/alfresco-archive/critical-in-activiti-engine-5-11/m-p/167655#M121167 c_arunrathnakum 2013-10-18T14:15:02Z Re: Critical in Activiti Engine - 5.11 https://connect.hyland.com/t5/alfresco-archive/critical-in-activiti-engine-5-11/m-p/167656#M121168 <HTML><HEAD></HEAD><BODY><SPAN>This is a database setup problem … not an Activiti one.</SPAN></BODY></HTML> Mon, 21 Oct 2013 11:07:43 GMT https://connect.hyland.com/t5/alfresco-archive/critical-in-activiti-engine-5-11/m-p/167656#M121168 jbarrez 2013-10-21T11:07:43Z