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

Importing variables from Optimize endpoint causes error for MSSQL

XMLWordPrintable

      • 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

        This is the controller panel for Smart Panels app

          1. catalina.out
            3.18 MB

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

                Created:
                Updated:
                Resolved: