How to manage tables in Camunda 7

how to manage all those tables which are growing with process variables in camunda 7
Can we truncate those tables.
ACT_HI_VARINST is one of them I could see have all the process variables and it throws exception because one of the variable has character length more than 4000 ch.

was aborted: ERROR: value too long for type character varying(4000) Call getNextException to see other errors in the batch.
at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(
at org.apache.ibatis.executor.BaseExecutor.flushStatements(
at org.apache.ibatis.executor.BaseExecutor.flushStatements(
at org.apache.ibatis.executor.CachingExecutor.flushStatements(
at org.apache.ibatis.session.defaults.DefaultSqlSession.flushStatements(
… 82 more
Caused by: java.sql.BatchUpdateException: Batch entry 1 insert into ACT_HI_VARINST (

The same question is answered in this thread:

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.