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 variables created on 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

          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: