org.camunda.bpm.engine.ProcessEngineException: An exception occurred in the persistence layer

Camunda 7 Topics Discussion & Questions
,
1

Hello I am getting this error and cannot understand where the problem can be. Do you have any idea?
@nikola.koevski @Niall
camunda engine.log (15.2 KB)

2

Hi @hahi,

Can you provide some additional information on your issue, for example:

  • Project setup (application server, database, etc.)
  • Can the issue be easily reproduced, or it happens arbitrarily?
  • What are the steps to reproduce the issue? (Camunda API usage, etc)

Best,
Nikola

3

@nikola.koevski @Niall
I’m facing the same issue.

I’m uploading a CSV file in camunda and then read the each row then create a ListMap of it. then using a parallel subprocess creating tasks for each row.

It works fine for 3 rows, but start giving this error beyond that.

Any suggestions to resolve this error is welcome

The logs are:

Caused by: java.sql.BatchUpdateException: String or binary data would be truncated in table 'camunda.dbo.ACT_HI_VARINST', column 'TEXT_'. Truncated value: '{
    "actions": [
        {
            "1": [
                "DMC",
                "1234",
     '.
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:2100)
4

Hi @Sumit_Singh,

Unfortunately, the user that opened this topic didn’t provide any additional information, so we weren’t able to understand what the problem was. It’s quite possible that the issue you are facing is different.

Can you provide some more information on your problem? Usually, some useful things to provide are:

  1. Application server, database, JDK version, etc;
  2. Process engine configuration;
  3. The problematic BPM process;
  4. Steps to reproduce the issue or example project.
  5. Any logs/stack traces that are shown when the process is started.

Best,
Nikola

5