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

First run of Optimize fails to import Camunda data

    Details

    • Type: Bug Report
    • Status: Done
    • Priority: L3 - Default
    • Resolution: Won't Do
    • Affects Version/s: 2.5.0
    • Fix Version/s: 2.6.0-alpha2
    • Component/s: None
    • Labels:
      None

      Description

      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 ( ? , ?...

        Activity

        Hide
        ilias.kourtoudis Ilias Kourtoudis added a comment -

        Hi Luke Baker,

        Thanks for contacting us with this issue.
        A short question: was this issue meant to be raised in our support project?
        The difference between the Support project and the Camunda BPM project is that when raising issues in the Camunda BPM project, they are not subject to the agreed SLAs, furthermore we cannot guarantee an answer at all and they can be viewed by all users. In contrast, issues raised in the Support project can only be seen by your authorized support contacts and us. You can find more information in our documentation.
        If you intended to raise a support issue, please let us know and we'll move this issue to the support project.

        Kind regards,
        Ilias

        Show
        ilias.kourtoudis Ilias Kourtoudis added a comment - Hi Luke Baker , Thanks for contacting us with this issue. A short question: was this issue meant to be raised in our support project? The difference between the Support project and the Camunda BPM project is that when raising issues in the Camunda BPM project, they are not subject to the agreed SLAs, furthermore we cannot guarantee an answer at all and they can be viewed by all users. In contrast, issues raised in the Support project can only be seen by your authorized support contacts and us. You can find more information in our documentation. If you intended to raise a support issue, please let us know and we'll move this issue to the support project. Kind regards, Ilias
        Hide
        luke.baker@veteransunited.com Luke Baker added a comment -

        Yes this is a support issue. I created a support ticket with this information. Feel free to close this ticket, apologies for the confusion.

        Show
        luke.baker@veteransunited.com Luke Baker added a comment - Yes this is a support issue. I created a support ticket with this information. Feel free to close this ticket, apologies for the confusion.
        Hide
        ilias.kourtoudis Ilias Kourtoudis added a comment -

        No worries Luke Baker,
        we will continue our communication on the Support issue you created.

        Kind regards,
        Ilias

        Show
        ilias.kourtoudis Ilias Kourtoudis added a comment - No worries Luke Baker , we will continue our communication on the Support issue you created. Kind regards, Ilias

          People

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

            Dates

            • Created:
              Updated:
              Resolved: