0

I am trying to run a simple OQL query but I am getting an error (see below). Can someone explain what the error means? An error has occurred while handling the request. [User 'm' with roles 'Administrator'] -------- com.mendix.core.CoreRuntimeException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"fs (depth = 0): select HR_case_log.HRCase.Case_number as CN, \t HR_case_log.HRCase.Date_started as SD from HR_case_log.HRCase ","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back at hC.b(SourceFile:193) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"request":"fs (depth = 0): select HR_case_log.HRCase.Case_number as CN, \t HR_case_log.HRCase.Date_started as SD from HR_case_log.HRCase ","type":"RetrieveOQLDataTableAction"}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.c(SourceFile:515) Caused by: n: An exception has occurred for the following request(s): fs (depth = -1): select HR_case_log.HRCase.Case_number as CN, HR_case_log.HRCase.Date_started as SD from HR_case_log.HRCase at x.a(SourceFile:57) Caused by: n: Error on retrieving aggregate results. at dA.a(SourceFile:263) Caused by: java.util.concurrent.ExecutionException: l: Exception occurred while retrieving data. (SQL State: 42563, Error Code: -5563) Detail Message: org.hsqldb.HsqlException: incompatible data type in operation at java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) at java.util.concurrent.FutureTask.get(FutureTask.java:83) at dA.a(SourceFile:260) at dA.a(SourceFile:213) at dA.a(SourceFile:157) at dA.a(SourceFile:85) at dE.a(SourceFile:68) at x.a(SourceFile:43) at h.a(SourceFile:269) at hp.a(SourceFile:89) at hp.executeAction(SourceFile:21) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:57) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:457) at hC.b(SourceFile:182) at com.mendix.core.Core.retrieveOQLDataTable(SourceFile:1449) at mI.a(SourceFile:900) at mI.a(SourceFile:752) at mI.a(SourceFile:90) at mI.a(SourceFile:82) at mD.execute(SourceFile:100) at iW.a(SourceFile:297) at com.mendix.externalinterface.connector.RequestDispatching$Worker.a(SourceFile:141) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.a(SourceFile:133) at com.mendix.externalinterface.connector.RequestDispatching$Worker$a.apply(SourceFile:131) at akka.actor.Actor$class.apply(Actor.scala:545) at com.mendix.externalinterface.connector.RequestDispatching$Worker.apply(SourceFile:127) at akka.actor.LocalActorRef.invoke(ActorRef.scala:910) at akka.dispatch.MessageInvocation.invoke(MessageHandling.scala:25) at akka.dispatch.ExecutableMailbox$class.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:223) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.processMailbox(ExecutorBasedEventDrivenDispatcher.scala:123) at akka.dispatch.ExecutableMailbox$class.run(ExecutorBasedEventDrivenDispatcher.scala:195) at akka.dispatch.ExecutorBasedEventDrivenDispatcher$$anon$4.run(ExecutorBasedEventDrivenDispatcher.scala:123) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) at akka.dispatch.MonitorableThread.run(ThreadPoolBuilder.scala:192) Caused by: l: Exception occurred while retrieving data. (SQL State: 42563, Error Code: -5563) Detail Message: org.hsqldb.HsqlException: incompatible data type in operation at H.a(SourceFile:1408) Caused by: java.sql.SQLSyntaxErrorException: incompatible data type in operation at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at H.a(SourceFile:324) at H.a(SourceFile:214) at H.a(SourceFile:164) at H.a(SourceFile:153) at z.a(SourceFile:41) at C.a(SourceFile:30) at C.call(SourceFile:14) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: org.hsqldb.HsqlException: incompatible data type in operation at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.SetFunction.getType(Unknown Source) at org.hsqldb.ExpressionAggregate.resolveTypes(Unknown Source) at org.hsqldb.QuerySpecification.resolveExpressionTypes(Unknown Source) at org.hsqldb.QuerySpecification.resolveTypesPartOne(Unknown Source) at org.hsqldb.QueryExpression.resolve(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.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at H.a(SourceFile:324) at H.a(SourceFile:214) at H.a(SourceFile:164) at H.a(SourceFile:153) at z.a(SourceFile:41) at C.a(SourceFile:30) at C.call(SourceFile:14) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)

asked 2013-11-08

1 answers