AnsweredAssumed Answered

Critical in Activiti Engine - 5.11

Question asked by c.arunrathnakumar on Oct 18, 2013
Latest reply on Oct 21, 2013 by jbarrez
Hi All,

A very critical exception here, please help me out:


My Process Engine configuration is as follows:

                ProcessEngineConfiguration configuration = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration();
                configuration.setDataSourceJndiName("java:jboss/datasources/workflowV2");
                configuration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE);
                configuration.setJobExecutorActivate(true);
                configuration.setTransactionsExternallyManaged(true);
                _processEngine = configuration.buildProcessEngine();

The total no.of records in act_hi_procinst are : 10479


14:12:23,118 SEVERE [org.activiti.engine.impl.interceptor.CommandContext] (jmsContainer-14) Error while closing command context: org.apache.ibatis.exceptions.PersistenceException:

### Error updating database.  Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full

### The error may involve org.activiti.engine.impl.persistence.entity.HistoricProcessInstanceEntity.insertHistoricProcessInstance-Inline

### The error occurred while setting parameters

### SQL: insert into ACT_HI_PROCINST (         ID_,         PROC_INST_ID_,         BUSINESS_KEY_,         PROC_DEF_ID_,         START_TIME_,         END_TIME_,         DURATION_,         START_USER_ID_,         START_ACT_ID_,         END_ACT_ID_,         SUPER_PROCESS_INSTANCE_ID_,         DELETE_REASON_       ) values (         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?       )

### Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full





14:12:23,287 WARN  [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'



Caused by: org.apache.ibatis.exceptions.PersistenceException:

### Error updating database.  Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full

### The error may involve org.activiti.engine.impl.persistence.entity.HistoricProcessInstanceEntity.insertHistoricProcessInstance-Inline

### The error occurred while setting parameters

### SQL: insert into ACT_HI_PROCINST (         ID_,         PROC_INST_ID_,         BUSINESS_KEY_,         PROC_DEF_ID_,         START_TIME_,         END_TIME_,         DURATION_,         START_USER_ID_,         START_ACT_ID_,         END_ACT_ID_,         SUPER_PROCESS_INSTANCE_ID_,         DELETE_REASON_       ) values (         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?,         ?       )

### Cause: java.sql.SQLException: The table 'ACT_HI_PROCINST' is full

Outcomes