-
Bug Report
-
Resolution: Won't Do
-
L3 - Default
-
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:
-
-
- 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.
- The error may exist in org/camunda/bpm/engine/impl/mapping/entity/VariableInstance.xml
- The error may involve defaultParameterMap
- The error occurred while setting parameters
- SQL: select * from ACT_GE_BYTEARRAY where ( ID_ IN ( ? , ?...
-