problem with query in OQL

0
Although it seems very simple, I’m still struggling with the OQL Execute OQL Statement.   Can someone point me to what’s wrong, while the syntax expects an ( And the first attribute is not accepted?   See screenshots.  
asked
2 answers
0

The statement must be passed as String parameter. 

Hence, if you pass your query in quotation marks and escape the quotation marks in the where condition it should work.

 

‘SELECT AttributeName, count(*)

FROM ModuleName.TableName

WHERE AttributeName = ‘’x’’

GROUP BY AttributeName’

answered
0

Thanks Nicolas, that helps me a bit further. But still strugling with the syntax.

Especially the usage of an enumeration field (Status).

How to refer to the enumeration? (The bold line)

 

'SELECT app.Soort_apparaat as Soort_apparaat,
count(*) as Aantal
FROM "DMHZorgAlarmeringModule".Apparaten as app
WHERE app.Status = "DMHZorgAlarmeringModule".Apparaat_status.Voorraad
GROUP BY app.Soort_apparaat
ORDER BY app.Soort_apparaat'

 

With trial and error I try to get the right syntax, the found documentation is nog consequent in usage of “ or ‘ and enumerations.

Kind regards Peter

 

An error has occurred while handling the request. [User 'MxAdmin' with session id '49e0bb39-XXXX-XXXX-XXXX-XXXXXXXXccad' and roles 'Administrator']

--------

com.mendix.webui.WebUIException: Exception while retrieving data for 'DMHZorgAlarmeringModule.Home_Web_DmhLog.Aantal_apparaten_list' on document 'DMHZorgAlarmeringModule.Home_Web_DmhLog'
    at com.mendix.webui.actions.client.RetrieveAction.$anonfun$apply$3(RetrieveAction.scala:94)

Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
    InternalOqlTextGetRequest (depth = -1, offset = 15, amount = 30): SELECT app.Soort_apparaat as Soort_apparaat, count(*) as Aantal FROM "DMHZorgAlarmeringModule".Apparaten as app WHERE app.Status = "DMHZorgAlarmeringModule".Apparaat_status.Voorraad  GROUP BY app.Soort_apparaat ORDER BY app.Soort_apparaat
    at DMHZorgAlarmeringModule.Bepaal_totaal_aantal_apparaten (JavaAction : 'Execute OQL statement')

Advanced stacktrace:
    at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:83)

Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
    InternalOqlTextGetRequest (depth = -1, offset = 15, amount = 30): SELECT app.Soort_apparaat as Soort_apparaat, count(*) as Aantal FROM "DMHZorgAlarmeringModule".Apparaten as app WHERE app.Status = "DMHZorgAlarmeringModule".Apparaat_status.Voorraad  GROUP BY app.Soort_apparaat ORDER BY app.Soort_apparaat
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:108)

Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
    InternalOqlTextGetRequest (depth = -1, offset = 15, amount = 30): SELECT app.Soort_apparaat as Soort_apparaat, count(*) as Aantal FROM "DMHZorgAlarmeringModule".Apparaten as app WHERE app.Status = "DMHZorgAlarmeringModule".Apparaat_status.Voorraad  GROUP BY app.Soort_apparaat ORDER BY app.Soort_apparaat
    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23)

Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
    InternalOqlTextGetRequest (depth = -1, offset = 15, amount = 30): SELECT app.Soort_apparaat as Soort_apparaat, count(*) as Aantal FROM "DMHZorgAlarmeringModule".Apparaten as app WHERE app.Status = "DMHZorgAlarmeringModule".Apparaat_status.Voorraad  GROUP BY app.Soort_apparaat ORDER BY app.Soort_apparaat
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:108)

Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
    InternalOqlTextGetRequest (depth = -1, offset = 15, amount = 30): SELECT app.Soort_apparaat as Soort_apparaat, count(*) as Aantal FROM "DMHZorgAlarmeringModule".Apparaten as app WHERE app.Status = "DMHZorgAlarmeringModule".Apparaat_status.Voorraad  GROUP BY app.Soort_apparaat ORDER BY app.Soort_apparaat
    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:23)

Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):
    InternalOqlTextGetRequest (depth = -1, offset = 15, amount = 30): SELECT app.Soort_apparaat as Soort_apparaat, count(*) as Aantal FROM "DMHZorgAlarmeringModule".Apparaten as app WHERE app.Status = "DMHZorgAlarmeringModule".Apparaat_status.Voorraad  GROUP BY app.Soort_apparaat ORDER BY app.Soort_apparaat
    at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:35)

Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: Can't find table by alias 'DMHZorgAlarmeringModule.Apparaat_status' in entity 'app' (alias for 'DMHZorgAlarmeringModule.Apparaten') and can't find table by name 'DMHZorgAlarmeringModule.Apparaat_status' in entity 'app' (alias for 'DMHZorgAlarmeringModule.Apparaten') while parsing path 'DMHZorgAlarmeringModule.Apparaat_status.Voorraad'
    at com.mendix.connectionbus.retrieve.OqlRequestHandler.doNewQueryHandling(OqlRequestHandler.scala:156)

Caused by: com.mendix.datastorage.oqltree.AnalysisException: Can't find table by alias 'DMHZorgAlarmeringModule.Apparaat_status' in entity 'app' (alias for 'DMHZorgAlarmeringModule.Apparaten') and can't find table by name 'DMHZorgAlarmeringModule.Apparaat_status' in entity 'app' (alias for 'DMHZorgAlarmeringModule.Apparaten') while parsing path 'DMHZorgAlarmeringModule.Apparaat_status.Voorraad'
    at com.mendix.datastorage.modelresolver.impl.StateResolver$StateResolvers.toResolvedExpression(IdentifierPath.scala:209)
    at com.mendix.datastorage.modelresolver.impl.PathParser$.$anonfun$parseAttribute$1(IdentifierPath.scala:101)
    at com.mendix.datastorage.modelresolver.impl.IdentifierToModelResolver$ResolveAttributes.com$mendix$datastorage$modelresolver$impl$IdentifierToModelResolver$ResolveAttributes$$resolveAttribute$1(IdentifierToModelResolver.scala:102)
    at com.mendix.datastorage.modelresolver.impl.IdentifierToModelResolver$ResolveAttributes$$anonfun$3.$anonfun$applyOrElse$1(IdentifierToModelResolver.scala:139)
    at scala.collection.mutable.HashMap.getOrElseUpdate(HashMap.scala:454)
    at com.mendix.datastorage.modelresolver.impl.IdentifierToModelResolver$ResolveAttributes$$anonfun$3.applyOrElse(IdentifierToModelResolver.scala:139)
    at com.mendix.datastorage.modelresolver.impl.IdentifierToModelResolver$ResolveAttributes$$anonfun$3.applyOrElse(IdentifierToModelResolver.scala:134)
    at com.mendix.datastorage.oqltree.transformations.Transformer$.transformNode(Transformer.scala:168)
    at com.mendix.datastorage.oqltree.expressions.BinaryExpression.mapChildren(Expression.scala:93)
    at com.mendix.datastorage.oqltree.transformations.Transformer$.transformNode(Transformer.scala:166)
    at com.mendix.datastorage.query.plans.Where.mapChildren(queryExpressions.scala:245)
    at com.mendix.datastorage.oqltree.transformations.Transformer$.transformNode(Transformer.scala:166)
    at com.mendix.datastorage.oqltree.transformations.Transformer$.$anonfun$transformOption$2(Transformer.scala:177)
    at scala.Option.map(Option.scala:242)
    at com.mendix.datastorage.oqltree.transformations.Transformer$.transformOption(Transformer.scala:177)
    at com.mendix.datastorage.query.plans.Select.mapChildren(queryExpressions.scala:201)
    at com.mendix.datastorage.oqltree.transformations.Transformer$.transformNode(Transformer.scala:166)
    at com.mendix.datastorage.oqltree.transformations.Transformer.withCustomContext(Transformer.scala:20)
    at com.mendix.datastorage.modelresolver.impl.IdentifierToModelResolver$ResolveAttributes.apply(IdentifierToModelResolver.scala:134)
    at com.mendix.datastorage.modelresolver.impl.IdentifierToModelResolver$ResolveAttributes.apply(IdentifierToModelResolver.scala:96)
    at com.mendix.datastorage.oqltree.rules.RuleExecutor.$anonfun$execute$1(RuleExecutor.scala:18)
    at scala.collection.LinearSeqOps.foldLeft(LinearSeq.scala:183)
    at scala.collection.LinearSeqOps.foldLeft$(LinearSeq.scala:179)
    at scala.collection.immutable.List.foldLeft(List.scala:79)
    at com.mendix.datastorage.oqltree.rules.RuleExecutor.execute(RuleExecutor.scala:17)
    at com.mendix.datastorage.oqltree.rules.RuleExecutor.execute$(RuleExecutor.scala:16)
    at com.mendix.datastorage.modelresolver.impl.IdentifierToModelResolver.execute(IdentifierToModelResolver.scala:24)
    at com.mendix.datastorage.modelresolver.impl.OQLTreeIdentifierToModelResolver.resolveIdentifiersToModel(OQLTreeIdentifierToModelResolver.scala:9)
    at com.mendix.datastorage.handler.CachedTransformationSteps$.withModel(QueryHandler.scala:120)
    at com.mendix.datastorage.handler.QueryHandler.$anonfun$handle$1(QueryHandler.scala:79)
    at scala.util.Either.flatMap(Either.scala:352)
    at com.mendix.datastorage.handler.QueryTransformationDSL$EitherComplexOrQueryMapper.$tilde$greater(QueryHandler.scala:356)
    at com.mendix.datastorage.handler.QueryHandler.handle(QueryHandler.scala:79)
    at com.mendix.datastorage.handler.QueryHandler.$anonfun$doCachedHandling$2(QueryHandler.scala:63)
    at com.github.benmanes.caffeine.cache.LocalCache.lambda$statsAware$2(LocalCache.java:161)
    at com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2625)
    at java.base/java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1908)
    at com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2623)
    at com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2606)
    at com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:106)
    at com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:62)
    at com.mendix.datastorage.handler.QueryHandler.doCachedHandling(QueryHandler.scala:63)
    at com.mendix.connectionbus.retrieve.OqlRequestHandler.doNewQueryHandling(OqlRequestHandler.scala:140)
    at com.mendix.connectionbus.retrieve.OqlRequestHandler.handleRequest(OqlRequestHandler.scala:54)
    at com.mendix.connectionbus.retrieve.DataStoreCaller.processOqlGetRequest(DataStoreCaller.scala:31)
    at com.mendix.connectionbus.retrieve.DataStoreCaller.$anonfun$getResult$1(DataStoreCaller.scala:26)
    at scala.collection.StrictOptimizedIterableOps.flatMap(StrictOptimizedIterableOps.scala:118)
    at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:105)
    at scala.collection.immutable.ArraySeq.flatMap(ArraySeq.scala:35)
    at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.scala:26)
    at com.mendix.connectionbus.retrieve.GetRequestHandler.doOtherRequests(GetRequestHandler.scala:69)
    at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.scala:29)
    at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:30)
    at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.scala:474)
    at com.mendix.basis.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.scala:47)
    at com.mendix.basis.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.scala:14)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)
    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56)
    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:104)
    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103)
    at com.mendix.basis.component.ExecutionCore.doExecuteSync(ExecutionCore.scala:148)
    at com.mendix.basis.component.ExecutionCore.doExecuteSync$(ExecutionCore.scala:147)
    at com.mendix.basis.component.InternalCore.doExecuteSync(InternalCore.scala:24)
    at com.mendix.basis.component.DataOQLCore.retrieveOQLDataTable(DataOQLCore.scala:63)
    at com.mendix.basis.component.DataOQLCore.retrieveOQLDataTable$(DataOQLCore.scala:59)
    at com.mendix.basis.component.InternalCore.retrieveOQLDataTable(InternalCore.scala:24)
    at com.mendix.basis.component.InternalCore.retrieveOQLDataTable(InternalCore.scala:24)
    at com.mendix.core.Core.retrieveOQLDataTable(Core.java:1150)
    at oql.implementation.OQL.executeOQL(OQL.java:84)
    at oql.actions.ExecuteOQLStatement.executeAction(ExecuteOQLStatement.java:99)
    at oql.actions.ExecuteOQLStatement.executeAction(ExecuteOQLStatement.java:71)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)
    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56)
    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:104)
    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103)
    at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:57)
    at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:35)
    at com.mendix.modules.microflowengine.actions.actioncall.ForegroundJavaAction.doExecute(ForegroundJavaAction.scala:11)
    at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:38)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.$anonfun$execute$1(MicroflowObject.scala:32)
    at scala.Option.flatMap(Option.scala:283)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.scala:29)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.$anonfun$executeAfterBreakingIfNecessary$2(MicroflowImpl.scala:167)
    at scala.Option.flatMap(Option.scala:283)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.scala:167)
    at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.scala:114)
    at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:58)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:71)
    at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:48)
    at com.mendix.core.actionmanagement.internal.InternalCoreAction.call(InternalCoreAction.java:56)
    at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:104)
    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)
    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:103)
    at com.mendix.basis.actionmanagement.MicroflowCallBuilderImpl.execute(MicroflowCallBuilderImpl.scala:62)
    at com.mendix.webui.actions.client.RetrieveAction.retrieveAllByMicroflow(RetrieveAction.scala:111)
    at com.mendix.webui.actions.client.RetrieveAction.$anonfun$apply$3(RetrieveAction.scala:59)
    at scala.util.Either.map(Either.scala:382)
    at com.mendix.webui.actions.client.RetrieveAction.apply(RetrieveAction.scala:43)
    at com.mendix.webui.actions.client.RetrieveAction.apply(RetrieveAction.scala:28)
    at com.mendix.webui.actions.client.RegularClientAction$Helpers$.$anonfun$liftEither$1(RegularClientAction.scala:30)
    at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.$anonfun$apply$4(RegularClientAction.scala:56)
    at com.mendix.webui.requesthandling.helpers.StateHandling.withState(StateHandling.scala:45)
    at com.mendix.webui.requesthandling.helpers.StateHandling.withState$(StateHandling.scala:42)
    at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.withState(RegularClientAction.scala:46)
    at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:54)
    at com.mendix.webui.actions.client.RegularClientAction$Helpers$StateHandler.apply(RegularClientAction.scala:46)
    at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$3(RegularClientAction.scala:120)
    at scala.util.Try$.apply(Try.scala:210)
    at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2(RegularClientAction.scala:120)
    at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2$adapted(RegularClientAction.scala:118)
    at com.mendix.webui.requesthandling.helpers.ContextHandling.$anonfun$inContext$7(ContextHandling.scala:58)
    at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)
    at com.mendix.basis.actionmanagement.ActionMonitoring$.$anonfun$monitor$1(ActionMonitoring.scala:49)
    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)
    at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:49)
    at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:58)
    at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:32)
    at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:94)
    at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:29)
    at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:21)
    at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:94)
    at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$1(RegularClientAction.scala:118)
    at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.scala:18)
    at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest(ProfileHandling.scala:14)
    at com.mendix.webui.requesthandling.helpers.ProfileHandling.profileRequest$(ProfileHandling.scala:10)
    at com.mendix.webui.actions.client.RegularClientAction.profileRequest(RegularClientAction.scala:94)
    at com.mendix.webui.actions.client.RegularClientAction.execute(RegularClientAction.scala:115)
    at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:106)
    at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:79)
    at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:37)
    at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1(MxRuntimeConnector.scala:54)
    at com.mendix.external.connector.MxRuntimeConnector.$anonfun$processRequest$1$adapted(MxRuntimeConnector.scala:54)
    at com.mendix.util.classloading.Runner$.withContextClassLoader(Runner.scala:20)
    at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.scala:54)
    at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.scala:221)
    at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.scala:40)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)
    at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1665)
    at org.eclipse.jetty.websocket.servlet.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:170)
    at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:202)
    at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1635)
    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:527)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
    at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1570)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)
    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1383)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)
    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)
    at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1543)
    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)
    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1305)
    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)
    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)
    at org.eclipse.jetty.server.Server.handle(Server.java:563)
    at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)
    at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)
    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)
    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)
    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)
    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)
    at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)
    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140)
    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)
    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:934)
    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1078)
    at java.base/java.lang.Thread.run(Thread.java:834)
 

answered