cancel
Showing results for 
Search instead for 
Did you mean: 

Critical in Activiti Engine - 5.11

c_arunrathnakum
Champ in-the-making
Champ in-the-making
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

2 REPLIES 2

c_arunrathnakum
Champ in-the-making
Champ in-the-making
I get this exception when i try to instantiate a process.
DB is Postgres.

jbarrez
Star Contributor
Star Contributor
This is a database setup problem … not an Activiti one.