Mendix Upgradation to 8 to 9

0
Hi I have recently upgraded an application from 8.18 to 9.6 version so in the 9.6.1 version I am facing an error while running a java action. In the java action we are passing a oql query and an object entity to retrieve a list of object entity it is working fine in 8.18 version but in 9.6.1 version it is throwing error      com.mendix.webui.WebUIException: Exception while retrieving data for 'AdminModule.Company_Overview.grid3' on document 'AdminModule.Company_Overview'       at com.mendix.webui.actions.client.RetrieveAction.$anonfun$apply$3(RetrieveAction.scala:99)   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): select  C.SecurimateId as SecurimateId, C.NameNLS as CompanyNameNLS, C.NameEnglish as CompanyNameEnglish, P.Status as Status, P.Function as Function, P.StartDate as StartDate, P.EndDate as EndDate,  C.Comments as Comments, P.IsOneTimePass as IsOneTimePass, C.changedDate as LastUpdatedDate, Prov.ProvinceName as Province, P.RequestId as RequestId  from AdminModule.Province Prov, AdminModule.Company C,AdminModule.Profile P where   Prov.ID=P/AdminModule.Profile_Company/AdminModule.Company/AdminModule.Company_Province/AdminModule.Province/ID and P/AdminModule.Profile_Company/AdminModule.Company/ID=C.ID and P.StartDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.EndDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.ID in ( select max(P1.ID) from AdminModule.Company C1,AdminModule.Profile P1 where P1/AdminModule.Profile_Company/AdminModule.Company/ID=C1.ID and C1.NameNLS like '%%' and C1.NameEnglish like '%%' group by C1.ID) order by C.ID asc       at AdminModule.DS_ExpiredProfiles_FromQuery (JavaAction : 'Retrieve company')   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): select  C.SecurimateId as SecurimateId, C.NameNLS as CompanyNameNLS, C.NameEnglish as CompanyNameEnglish, P.Status as Status, P.Function as Function, P.StartDate as StartDate, P.EndDate as EndDate,  C.Comments as Comments, P.IsOneTimePass as IsOneTimePass, C.changedDate as LastUpdatedDate, Prov.ProvinceName as Province, P.RequestId as RequestId  from AdminModule.Province Prov, AdminModule.Company C,AdminModule.Profile P where   Prov.ID=P/AdminModule.Profile_Company/AdminModule.Company/AdminModule.Company_Province/AdminModule.Province/ID and P/AdminModule.Profile_Company/AdminModule.Company/ID=C.ID and P.StartDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.EndDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.ID in ( select max(P1.ID) from AdminModule.Company C1,AdminModule.Profile P1 where P1/AdminModule.Profile_Company/AdminModule.Company/ID=C1.ID and C1.NameNLS like '%%' and C1.NameEnglish like '%%' group by C1.ID) order by C.ID asc       at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:84)   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): select  C.SecurimateId as SecurimateId, C.NameNLS as CompanyNameNLS, C.NameEnglish as CompanyNameEnglish, P.Status as Status, P.Function as Function, P.StartDate as StartDate, P.EndDate as EndDate,  C.Comments as Comments, P.IsOneTimePass as IsOneTimePass, C.changedDate as LastUpdatedDate, Prov.ProvinceName as Province, P.RequestId as RequestId  from AdminModule.Province Prov, AdminModule.Company C,AdminModule.Profile P where   Prov.ID=P/AdminModule.Profile_Company/AdminModule.Company/AdminModule.Company_Province/AdminModule.Province/ID and P/AdminModule.Profile_Company/AdminModule.Company/ID=C.ID and P.StartDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.EndDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.ID in ( select max(P1.ID) from AdminModule.Company C1,AdminModule.Profile P1 where P1/AdminModule.Profile_Company/AdminModule.Company/ID=C1.ID and C1.NameNLS like '%%' and C1.NameEnglish like '%%' group by C1.ID) order by C.ID asc       at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java: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): select  C.SecurimateId as SecurimateId, C.NameNLS as CompanyNameNLS, C.NameEnglish as CompanyNameEnglish, P.Status as Status, P.Function as Function, P.StartDate as StartDate, P.EndDate as EndDate,  C.Comments as Comments, P.IsOneTimePass as IsOneTimePass, C.changedDate as LastUpdatedDate, Prov.ProvinceName as Province, P.RequestId as RequestId  from AdminModule.Province Prov, AdminModule.Company C,AdminModule.Profile P where   Prov.ID=P/AdminModule.Profile_Company/AdminModule.Company/AdminModule.Company_Province/AdminModule.Province/ID and P/AdminModule.Profile_Company/AdminModule.Company/ID=C.ID and P.StartDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.EndDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.ID in ( select max(P1.ID) from AdminModule.Company C1,AdminModule.Profile P1 where P1/AdminModule.Profile_Company/AdminModule.Company/ID=C1.ID and C1.NameNLS like '%%' and C1.NameEnglish like '%%' group by C1.ID) order by C.ID asc       at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:84)   Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):       InternalOqlTextGetRequest (depth = -1): select  C.SecurimateId as SecurimateId, C.NameNLS as CompanyNameNLS, C.NameEnglish as CompanyNameEnglish, P.Status as Status, P.Function as Function, P.StartDate as StartDate, P.EndDate as EndDate,  C.Comments as Comments, P.IsOneTimePass as IsOneTimePass, C.changedDate as LastUpdatedDate, Prov.ProvinceName as Province, P.RequestId as RequestId  from AdminModule.Province Prov, AdminModule.Company C,AdminModule.Profile P where   Prov.ID=P/AdminModule.Profile_Company/AdminModule.Company/AdminModule.Company_Province/AdminModule.Province/ID and P/AdminModule.Profile_Company/AdminModule.Company/ID=C.ID and P.StartDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.EndDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.ID in ( select max(P1.ID) from AdminModule.Company C1,AdminModule.Profile P1 where P1/AdminModule.Profile_Company/AdminModule.Company/ID=C1.ID and C1.NameNLS like '%%' and C1.NameEnglish like '%%' group by C1.ID) order by C.ID asc       at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java:23)   Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):       InternalOqlTextGetRequest (depth = -1): select  C.SecurimateId as SecurimateId, C.NameNLS as CompanyNameNLS, C.NameEnglish as CompanyNameEnglish, P.Status as Status, P.Function as Function, P.StartDate as StartDate, P.EndDate as EndDate,  C.Comments as Comments, P.IsOneTimePass as IsOneTimePass, C.changedDate as LastUpdatedDate, Prov.ProvinceName as Province, P.RequestId as RequestId  from AdminModule.Province Prov, AdminModule.Company C,AdminModule.Profile P where   Prov.ID=P/AdminModule.Profile_Company/AdminModule.Company/AdminModule.Company_Province/AdminModule.Province/ID and P/AdminModule.Profile_Company/AdminModule.Company/ID=C.ID and P.StartDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.EndDate < TO_DATE('24/08/2022','DD/MM/YYYY')  and P.ID in ( select max(P1.ID) from AdminModule.Company C1,AdminModule.Profile P1 where P1/AdminModule.Profile_Company/AdminModule.Company/ID=C1.ID and C1.NameNLS like '%%' and C1.NameEnglish like '%%' group by C1.ID) order by C.ID asc       at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:33)   Caused by: scala.MatchError: (null,TO_DATE,List( '24/08/2022', ,,  'DD/MM/YYYY')) (of class scala.Tuple3)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectColumnConverter.convertExtendedFunction(SelectColumnConverter.scala:82)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectColumnConverter.convertExtendedFunction$(SelectColumnConverter.scala:79)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convertExtendedFunction(FromLegacyOqlConverter.scala:7)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectColumnConverter.convertWithoutAlias(SelectColumnConverter.scala:39)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectColumnConverter.convert(SelectColumnConverter.scala:33)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectColumnConverter.convert$(SelectColumnConverter.scala:31)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convert(FromLegacyOqlConverter.scala:7)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.$anonfun$convertSelectColumn$1(WhereClauseItemConverter.scala:13)       at scala.Option.map(Option.scala:242)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convertSelectColumn(WhereClauseItemConverter.scala:13)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convertWhereTerm(WhereClauseItemConverter.scala:35)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convertWhereTerm$(WhereClauseItemConverter.scala:30)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convertWhereTerm(FromLegacyOqlConverter.scala:7)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convertWithoutDeny(WhereClauseItemConverter.scala:21)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convert(WhereClauseItemConverter.scala:17)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convert$(WhereClauseItemConverter.scala:16)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convert(FromLegacyOqlConverter.scala:7)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.$anonfun$convertWhereClause$1(WhereClauseItemConverter.scala:25)       at scala.collection.StrictOptimizedIterableOps.map(StrictOptimizedIterableOps.scala:99)       at scala.collection.StrictOptimizedIterableOps.map$(StrictOptimizedIterableOps.scala:86)       at scala.collection.convert.JavaCollectionWrappers$JListWrapper.map(JavaCollectionWrappers.scala:103)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convertWhereClause(WhereClauseItemConverter.scala:25)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convertWhereClause$(WhereClauseItemConverter.scala:24)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convertWhereClause(FromLegacyOqlConverter.scala:7)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convertWithoutDeny(WhereClauseItemConverter.scala:20)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convert(WhereClauseItemConverter.scala:17)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.WhereClauseItemConverter.convert$(WhereClauseItemConverter.scala:16)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convert(FromLegacyOqlConverter.scala:7)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectQueryConverter$$anonfun$convertWhere$1.applyOrElse(SelectQueryConverter.scala:62)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectQueryConverter$$anonfun$convertWhere$1.applyOrElse(SelectQueryConverter.scala:60)       at scala.PartialFunction$Lifted.apply(PartialFunction.scala:313)       at scala.PartialFunction$Lifted.apply(PartialFunction.scala:309)       at scala.Option.collect(Option.scala:462)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectQueryConverter.convertWhere(SelectQueryConverter.scala:60)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectQueryConverter.convertWhere$(SelectQueryConverter.scala:59)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convertWhere(FromLegacyOqlConverter.scala:7)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectQueryConverter.convert(SelectQueryConverter.scala:23)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.SelectQueryConverter.convert$(SelectQueryConverter.scala:15)       at com.mendix.connectionbus.retrieve.queryconverters.fromlegacyquery.FromLegacyOqlConverter.convert(FromLegacyOqlConverter.scala:7)       at com.mendix.queryparser.SelectQueryResult.getSelect(QueryParser.scala:51)       at com.mendix.connectionbus.retrieve.OqlRequestHandler.doNewQueryHandling(OqlRequestHandler.scala:200)       at com.mendix.connectionbus.retrieve.OqlRequestHandler.handleRequest(OqlRequestHandler.scala:67)       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:117)       at scala.collection.StrictOptimizedIterableOps.flatMap$(StrictOptimizedIterableOps.scala:104)       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:68)       at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.scala:29)       at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.scala:28)       at com.mendix.connectionbus.ConnectionBusImplBase.doRequest(ConnectionBusImplBase.java:219)       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:46)       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.scala:25)       at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:80)       at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java:19)       at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:79)       at com.mendix.basis.component.ExecutionCore.doExecuteSync(ExecutionCore.scala:147)       at com.mendix.basis.component.ExecutionCore.doExecuteSync$(ExecutionCore.scala:146)       at com.mendix.basis.component.InternalCore.doExecuteSync(InternalCore.scala:23)       at com.mendix.basis.component.DataOQLCore.retrieveOQLDataTable(DataOQLCore.scala:57)       at com.mendix.basis.component.DataOQLCore.retrieveOQLDataTable$(DataOQLCore.scala:53)       at com.mendix.basis.component.InternalCore.retrieveOQLDataTable(InternalCore.scala:23)       at com.mendix.basis.component.InternalCore.retrieveOQLDataTable(InternalCore.scala:23)       at com.mendix.core.Core.retrieveOQLDataTable(Core.java:1099)       at com.mendix.core.Core.retrieveOQLDataTable(Core.java:1086)       at readonlymodule.actions.RetrieveCompany.executeAction(RetrieveCompany.java:38)       at readonlymodule.actions.RetrieveCompany.executeAction(RetrieveCompany.java:21)       at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46)       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.scala:25)       at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:80)       at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java:19)       at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:79)       at com.mendix.basis.actionmanagement.UserActionCallBuilderImpl.execute(UserActionCallBuilderImpl.scala:34)       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:46)       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.scala:25)       at com.mendix.basis.actionmanagement.ActionManager.$anonfun$executeSync$2(ActionManager.scala:80)       at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java:19)       at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:79)       at com.mendix.basis.actionmanagement.MicroflowCallBuilderImpl.execute(MicroflowCallBuilderImpl.scala:38)       at com.mendix.webui.actions.client.RetrieveAction.retrieveAllByMicroflow(RetrieveAction.scala:120)       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:42)       at com.mendix.webui.requesthandling.helpers.StateHandling.withState$(StateHandling.scala:39)       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:113)       at scala.util.Try$.apply(Try.scala:210)       at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2(RegularClientAction.scala:113)       at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$2$adapted(RegularClientAction.scala:111)       at com.mendix.webui.requesthandling.helpers.ContextHandling.$anonfun$inContext$5(ContextHandling.scala:57)       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.java:19)       at com.mendix.basis.actionmanagement.ActionMonitoring$.monitor(ActionMonitoring.scala:49)       at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:57)       at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:31)       at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:87)       at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext(ContextHandling.scala:28)       at com.mendix.webui.requesthandling.helpers.ContextHandling.inContext$(ContextHandling.scala:20)       at com.mendix.webui.actions.client.RegularClientAction.inContext(RegularClientAction.scala:87)       at com.mendix.webui.actions.client.RegularClientAction.$anonfun$execute$1(RegularClientAction.scala:111)       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:87)       at com.mendix.webui.actions.client.RegularClientAction.execute(RegularClientAction.scala:108)       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:35)       at com.mendix.external.connector.MxRuntimeConnector.lambda$processRequest$0(MxRuntimeConnector.java:74)       at com.mendix.util.classloading.Runner.withContextClassLoader(Runner.java:19)       at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:73)       at com.mendix.basis.impl.MxRuntimeImplBase.processRequest(MxRuntimeImplBase.java:838)       at com.mendix.m2ee.appcontainer.server.handler.RuntimeServlet.service(RuntimeServlet.scala:25)       at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)       at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)       at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626)       at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228)       at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)       at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)       at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548)       at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)       at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)       at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)       at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434)       at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)       at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)       at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)       at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)       at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349)       at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)       at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)       at org.eclipse.jetty.server.Server.handle(Server.java:516)       at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)       at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)       at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)       at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)       at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)       at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)       at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)       at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)       at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:386)       at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)       at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)       at java.base/java.lang.Thread.run(Thread.java:834)
asked
3 answers
1

Hi Sahil,

 

Delete the app store modules complaining and Replace with new, it could add latest Java lib,

always keep a backup before doing this and also you need to clean deploy and sync before you run in local.

 

answered
1

Hi Sahil,

 

try to update the appstore modules which are all throughing the compilation error it will fix the issue.

 

Thanks

answered
0

Hi Sahil,

try updating the OQL module to the latest version and check.

and also I don’t think there is a todate function available in OQL in Mendix and the issue mainly caused  by the todate function.

check documentation.

https://docs.mendix.com/refguide/oql-operators/

https://docs.mendix.com/refguide/oql-functions/

answered