1

Goodevening, When i run an report with an dataset i get an java error. Does anybody has an solution for me? Thanks   An error has occurred while handling the request. [User 'loods20' with session id '068df766-2a55-4244-a5fe-c6be4ba610ec' and roles 'LoodsKantoor'] -------- com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"OQLTextGetRequest (depth = 0): SELECT   COUNT(1) AS Aantal , Opdr.Naam AS Klant  , Art.Artikelkode AS Artikel   FROM   Scan.\"Order\" AS Ord   INNER JOIN Ord/Scan.Order_Relatie_Opdrachtgever/Scan.Relatie AS Opdr   INNER JOIN Ord/Scan.Order_Magazijn/Scan.Magazijn AS Mag   INNER JOIN Ord/Scan.OrderRegels_Order/Scan.OrderRegels/Scan.OrderRegels_Artikelen/Scan.Artikelen AS Art  WHERE     DatePart(DAY,Ord.Datum) >= DatePart(DAY,RANGEBEGIN($Datum))  and DatePart(DAY,Ord.Datum) <= DatePart(DAY,RANGEEND($Datum))  and Mag/Scan.Employee_Magazijn = '[%CurrentUser%]'  GROUP BY Opdr.Naam        , Art.Artikelkode  order by Aantal    ","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back     at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:176) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"OQLTextGetRequest (depth = 0): SELECT   COUNT(1) AS Aantal , Opdr.Naam AS Klant  , Art.Artikelkode AS Artikel   FROM   Scan.\"Order\" AS Ord   INNER JOIN Ord/Scan.Order_Relatie_Opdrachtgever/Scan.Relatie AS Opdr   INNER JOIN Ord/Scan.Order_Magazijn/Scan.Magazijn AS Mag   INNER JOIN Ord/Scan.OrderRegels_Order/Scan.OrderRegels/Scan.OrderRegels_Artikelen/Scan.Artikelen AS Art  WHERE     DatePart(DAY,Ord.Datum) >= DatePart(DAY,RANGEBEGIN($Datum))  and DatePart(DAY,Ord.Datum) <= DatePart(DAY,RANGEEND($Datum))  and Mag/Scan.Employee_Magazijn = '[%CurrentUser%]'  GROUP BY Opdr.Naam        , Art.Artikelkode  order by Aantal    ","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:40) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"OQLTextGetRequest (depth = 0): SELECT   COUNT(1) AS Aantal , Opdr.Naam AS Klant  , Art.Artikelkode AS Artikel   FROM   Scan.\"Order\" AS Ord   INNER JOIN Ord/Scan.Order_Relatie_Opdrachtgever/Scan.Relatie AS Opdr   INNER JOIN Ord/Scan.Order_Magazijn/Scan.Magazijn AS Mag   INNER JOIN Ord/Scan.OrderRegels_Order/Scan.OrderRegels/Scan.OrderRegels_Artikelen/Scan.Artikelen AS Art  WHERE     DatePart(DAY,Ord.Datum) >= DatePart(DAY,RANGEBEGIN($Datum))  and DatePart(DAY,Ord.Datum) <= DatePart(DAY,RANGEEND($Datum))  and Mag/Scan.Employee_Magazijn = '[%CurrentUser%]'  GROUP BY Opdr.Naam        , Art.Artikelkode  order by Aantal    ","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back     at com.mendix.core.actionmanagement.CoreAction.processErrorState(CoreAction.java:303) Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: An exception has occurred for the following request(s):      OQLTextGetRequest (depth = -1): SELECT   COUNT(1) AS Aantal , Opdr.Naam AS Klant  , Art.Artikelkode AS Artikel   FROM   Scan."Order" AS Ord   INNER JOIN Ord/Scan.Order_Relatie_Opdrachtgever/Scan.Relatie AS Opdr   INNER JOIN Ord/Scan.Order_Magazijn/Scan.Magazijn AS Mag   INNER JOIN Ord/Scan.OrderRegels_Order/Scan.OrderRegels/Scan.OrderRegels_Artikelen/Scan.Artikelen AS Art  WHERE     DatePart(DAY,Ord.Datum) >= DatePart(DAY,RANGEBEGIN($Datum))  and DatePart(DAY,Ord.Datum) <= DatePart(DAY,RANGEEND($Datum))  and Mag/Scan.Employee_Magazijn = '[%CurrentUser%]'  GROUP BY Opdr.Naam        , Art.Artikelkode  order by Aantal         at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:46) Caused by: com.mendix.systemwideinterfaces.connectionbus.ConnectionBusException: Exception occurred while retrieving data. (SQL State: 42581, Error Code: -5581) Detail Message: org.hsqldb.HsqlException: unexpected token: , : line: 13     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.getCorrectException(JDBCDataStore.java:1197) Caused by: java.sql.SQLSyntaxErrorException: unexpected token: , : line: 13     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQuery(JDBCDataStore.java:303)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQueries(JDBCDataStore.java:198)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:163)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:152)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:229)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:196)     at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:78)     at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:64)     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:41)     at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:459)     at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:92)     at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:17)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49)     at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248)     at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)     at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:172)     at com.mendix.core.component.InternalCore.retrieveOQLDataTable(InternalCore.java:1019)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getResultFromOQL(SeriesDataGenerator.java:417)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesValues(SeriesDataGenerator.java:340)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesDataList(SeriesDataGenerator.java:83)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesDataList(SeriesDataGenerator.java:74)     at com.mendix.webui.reporting.clientactions.ReportAction.execute(ReportAction.java:68)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:311)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:301)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:301)     at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:143)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)     at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:145)     at scala.util.Try$.apply(Try.scala:192)     at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:139)     at akka.actor.Actor$class.aroundReceive(Actor.scala:465)     at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:135)     at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)     at akka.actor.ActorCell.invoke(ActorCell.scala:487)     at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)     at akka.dispatch.Mailbox.run(Mailbox.scala:220)     at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393)     at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)     at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)     at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)     at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) Caused by: org.hsqldb.HsqlException: unexpected token: , : line: 13     at org.hsqldb.error.Error.parseError(Unknown Source)     at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)     at org.hsqldb.ParserBase.checkIsIdentifier(Unknown Source)     at org.hsqldb.ParserDQL.readColumnOrFunctionExpression(Unknown Source)     at org.hsqldb.ParserDQL.XreadSimpleValueExpressionPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source)     at org.hsqldb.ParserDQL.XreadValueExpression(Unknown Source)     at org.hsqldb.ParserDQL.readColumnOrFunctionExpression(Unknown Source)     at org.hsqldb.ParserDQL.XreadSimpleValueExpressionPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source)     at org.hsqldb.ParserDQL.readExpression(Unknown Source)     at org.hsqldb.ParserDQL.readSQLFunction(Unknown Source)     at org.hsqldb.ParserDQL.readColumnOrFunctionExpression(Unknown Source)     at org.hsqldb.ParserDQL.XreadSimpleValueExpressionPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesValueExpressionPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesFactor(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesTerm(Unknown Source)     at org.hsqldb.ParserDQL.XreadAllTypesCommonValueExpression(Unknown Source)     at org.hsqldb.ParserDQL.XreadRowOrCommonValueExpression(Unknown Source)     at org.hsqldb.ParserDQL.XreadRowValuePredicand(Unknown Source)     at org.hsqldb.ParserDQL.XreadPredicateRightPart(Unknown Source)     at org.hsqldb.ParserDQL.XreadBooleanPrimaryOrNull(Unknown Source)     at org.hsqldb.ParserDQL.XreadBooleanTestOrNull(Unknown Source)     at org.hsqldb.ParserDQL.XreadBooleanFactorOrNull(Unknown Source)     at org.hsqldb.ParserDQL.XreadBooleanTermOrNull(Unknown Source)     at org.hsqldb.ParserDQL.XreadBooleanValueExpression(Unknown Source)     at org.hsqldb.ParserDQL.readWhereGroupHaving(Unknown Source)     at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)     at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)     at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)     at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)     at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)     at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)     at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)     at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)     at org.hsqldb.ParserCommand.compilePart(Unknown Source)     at org.hsqldb.ParserCommand.compileStatements(Unknown Source)     at org.hsqldb.Session.executeDirectStatement(Unknown Source)     at org.hsqldb.Session.execute(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)     at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQuery(JDBCDataStore.java:303)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.execRetrieveQueries(JDBCDataStore.java:198)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:163)     at com.mendix.connectionbus.connections.jdbc.JDBCDataStore.retrieve(JDBCDataStore.java:152)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:229)     at com.mendix.connectionbus.retrieve.DataStoreCaller.executeQueries(DataStoreCaller.java:196)     at com.mendix.connectionbus.retrieve.DataStoreCaller.getResult(DataStoreCaller.java:78)     at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:64)     at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:41)     at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:459)     at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:92)     at com.mendix.core.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:17)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:49)     at com.mendix.core.actionmanagement.CoreAction.doCall(CoreAction.java:260)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:248)     at com.mendix.core.actionmanagement.ActionManager$1.execute(ActionManager.java:168)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)     at com.mendix.core.actionmanagement.ActionManager.executeSync(ActionManager.java:172)     at com.mendix.core.component.InternalCore.retrieveOQLDataTable(InternalCore.java:1019)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getResultFromOQL(SeriesDataGenerator.java:417)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesValues(SeriesDataGenerator.java:340)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesDataList(SeriesDataGenerator.java:83)     at com.mendix.webui.reporting.generation.SeriesDataGenerator.getSeriesDataList(SeriesDataGenerator.java:74)     at com.mendix.webui.reporting.clientactions.ReportAction.execute(ReportAction.java:68)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:311)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:301)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:301)     at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2$$anon$1.execute(ActionDispatching.scala:143)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36)     at com.mendix.core.session.Worker$$anonfun$receive$3$$anonfun$2.apply(ActionDispatching.scala:145)     at scala.util.Try$.apply(Try.scala:192)     at com.mendix.core.session.Worker$$anonfun$receive$3.applyOrElse(ActionDispatching.scala:139)     at akka.actor.Actor$class.aroundReceive(Actor.scala:465)     at com.mendix.core.session.Worker.aroundReceive(ActionDispatching.scala:135)     at akka.actor.ActorCell.receiveMessage(ActorCell.scala:516)     at akka.actor.ActorCell.invoke(ActorCell.scala:487)     at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:238)     at akka.dispatch.Mailbox.run(Mailbox.scala:220)     at akka.dispatch.ForkJoinExecutorConfigurator$AkkaForkJoinTask.exec(AbstractDispatcher.scala:393)     at scala.concurrent.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)     at scala.concurrent.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)     at scala.concurrent.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)     at scala.concurrent.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)  

asked 2016-11-05

1 answers