Uploaded image for project: 'Camunda Optimize'
  1. Camunda Optimize
  2. OPT-2554

First run of Optimize fails to import Camunda data

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Won't Do
    • Icon: L3 - Default L3 - Default
    • 2.6.0-alpha2, 2.6.0
    • 2.5.0
    • None
    • None

      I've configured Camunda Optimize and am executing it for the first time, however I am running into a problem when Optimize attempts to fetch data from the database. I've attached relevant snippets below.

      Environment information:
      Camunda 7.11.0 Enterprise
      Optimize 2.5
      Database: Microsoft SQL Server 2016 (13.0.5292.0

      Optimize stacktrace snip:
      {{16:02:48.304 [Thread-12] ERROR o.c.o.s.e.i.f.i.VariableUpdateInstanceFetcher - Error during fetching of entities. Please
      check the connection with [camunda-bpm]!
      javax.ws.rs.InternalServerErrorException: HTTP 500 Internal Server Error
      at org.glassfish.jersey.client.JerseyInvocation.convertToException(JerseyInvocation.java:1074)
      at org.glassfish.jersey.client.JerseyInvocation.translate(JerseyInvocation.java:924)
      at org.glassfish.jersey.client.JerseyInvocation.lambda$invoke$2(JerseyInvocation.java:763)
      at org.glassfish.jersey.internal.Errors.process(Errors.java:292)
      at org.glassfish.jersey.internal.Errors.process(Errors.java:274)
      at org.glassfish.jersey.internal.Errors.process(Errors.java:205)
      at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:390)
      at org.glassfish.jersey.client.JerseyInvocation.invoke(JerseyInvocation.java:761)
      at org.glassfish.jersey.client.JerseyInvocation$Builder.method(JerseyInvocation.java:414)
      at org.glassfish.jersey.client.JerseyInvocation$Builder.get(JerseyInvocation.java:305)
      at org.camunda.optimize.service.engine.importing.fetcher.instance.VariableUpdateInstanceFetcher.performGetVariab
      leInstanceUpdateRequest(VariableUpdateInstanceFetcher.java:75)
      at org.camunda.optimize.service.engine.importing.fetcher.instance.VariableUpdateInstanceFetcher.lambda$fetchVari
      ableInstanceUpdates$0(VariableUpdateInstanceFetcher.java:54)
      at org.camunda.optimize.service.engine.importing.fetcher.instance.RetryBackoffEngineEntityFetcher.fetchWithRetry
      (RetryBackoffEngineEntityFetcher.java:34)
      at org.camunda.optimize.service.engine.importing.fetcher.instance.VariableUpdateInstanceFetcher.fetchVariableIns
      tanceUpdates(VariableUpdateInstanceFetcher.java:54)
      at org.camunda.optimize.service.engine.importing.fetcher.instance.VariableUpdateInstanceFetcher.fetchVariableIns
      tanceUpdates(VariableUpdateInstanceFetcher.java:43)
      at org.camunda.optimize.service.engine.importing.service.mediator.VariableUpdateEngineImportMediator.getEntities
      NextPage(VariableUpdateEngineImportMediator.java:51)
      at org.camunda.optimize.service.engine.importing.service.mediator.TimestampBasedImportMediator.importNextEngineP
      age(TimestampBasedImportMediator.java:35)
      at org.camunda.optimize.service.engine.importing.service.mediator.BackoffImportMediator.importNextPageWithErrorC
      heck(BackoffImportMediator.java:96)
      at org.camunda.optimize.service.engine.importing.service.mediator.BackoffImportMediator.importNextPage(BackoffIm
      portMediator.java:54)
      at org.camunda.optimize.service.engine.importing.EngineImportScheduler.scheduleCurrentImportRound(EngineImportSc
      heduler.java:143)
      at org.camunda.optimize.service.engine.importing.EngineImportScheduler.scheduleNextRound(EngineImportScheduler.j
      ava:96)
      at org.camunda.optimize.service.engine.importing.EngineImportScheduler.run(EngineImportScheduler.java:67)}}

      #Camunda stderr snip:

          1. Error querying database. 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.
          2. The error may exist in org/camunda/bpm/engine/impl/mapping/entity/VariableInstance.xml
          3. The error may involve defaultParameterMap
          4. The error occurred while setting parameters
          5. SQL: select * from ACT_GE_BYTEARRAY where ( ID_ IN ( ? , ?...

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              luke.baker@veteransunited.com Luke Baker
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: