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

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Salesforce