Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-10513

Importing variables from Optimize endpoint causes error for MSSQL

    XMLWordPrintable

    Details

      Description

      • given:
        • I have more 2100 decision variables created in the engine
        • I have MSSQL as database connected to the engine
      • when:
        • I start Optimize, which is importing the data from the engine
      • then:
        • the variable data is not imported to Optimize
        • I get the following error in the engine (see the full log attached catalina.out):
          Cause: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
          	at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
          	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
          	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
          	at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:97)
          	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:184)
          	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:176)
          	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:172)
          	at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:156)
          	at org.camunda.bpm.engine.impl.optimize.OptimizeManager.getHistoricVariableUpdateByteArrays(OptimizeManager.java:43)
          
      • expected:
        • all data is imported to Optimize without any erros

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              johannes.heinemann Johannes Heinemann
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: