ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

0
Hi all,   I am getting the following error: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found   I am running a demo at a client and we are running a DB connector execute query to their local Oracle 11g.  I have tried to add the following the Extra JVM locally... -Duser.timezone=GMT, but how can I add this to the cloud sandbox instance?       Stacktrace com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:535) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:178) Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:37) Caused by: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:392)     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:385)     at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:938)     at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:480)     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)     at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:416)     at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:825)     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:596)     at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)     at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)     at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:356)     at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:199)     at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:444)     at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:515)     at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:112)     at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:97)     at databaseconnector.impl.JdbcConnectionManager.getConnection(JdbcConnectionManager.java:50)     at databaseconnector.impl.JdbcConnector.executeQuery(JdbcConnector.java:80)     at databaseconnector.impl.JdbcConnector.executeQuery(JdbcConnector.java:70)     at databaseconnector.actions.ExecuteQuery.executeAction(ExecuteQuery.java:113)     at databaseconnector.actions.ExecuteQuery.executeAction(ExecuteQuery.java:90)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)     at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:52)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:200)     at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157)     at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:50)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:73)     at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:53)     at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:51)     at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:170)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:174)     at com.mendix.basis.component.InternalCore.execute(InternalCore.java:531)     at com.mendix.webui.actions.client.ExecuteAction.execute(ExecuteAction.java:133)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply$mcV$sp(ClientRequestHandler.scala:315)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:300)     at com.mendix.webui.requesthandling.ClientRequestHandler$$anonfun$handleRequest$1.apply(ClientRequestHandler.scala:300)     at com.mendix.basis.actionmanagement.IMonitoredAction$$anon$1.execute(IMonitoredAction.scala:47)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.basis.actionmanagement.IMonitoredAction$class.monitor(IMonitoredAction.scala:49)     at com.mendix.webui.requesthandling.ClientRequestHandler$ClientMonitoredAction.monitor(ClientRequestHandler.scala:417)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleRequest(ClientRequestHandler.scala:300)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleActionWithSessionRequired(ClientRequestHandler.scala:238)     at com.mendix.webui.requesthandling.ClientRequestHandler.handleAction(ClientRequestHandler.scala:205)     at com.mendix.webui.requesthandling.ClientRequestHandler.liftedTree1$1(ClientRequestHandler.scala:104)     at com.mendix.webui.requesthandling.ClientRequestHandler.processRequest(ClientRequestHandler.scala:96)     at com.mendix.externalinterface.connector.RequestHandler.doProcessRequest(RequestHandler.java:40)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:70)     at com.mendix.external.connector.MxRuntimeConnector$1.execute(MxRuntimeConnector.java:67)     at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:33)     at com.mendix.external.connector.MxRuntimeConnector.processRequest(MxRuntimeConnector.java:73)     at com.mendix.basis.impl.MxRuntimeImpl.processRequest(MxRuntimeImpl.java:873)     at com.mendix.m2ee.appcontainer.server.handler.RuntimeHandler.handle(RuntimeHandler.java:41)     at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)     at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)     at org.eclipse.jetty.server.Server.handle(Server.java:368)     at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:489)     at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:953)     at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1014)     at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:861)     at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)     at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)     at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)     at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)     at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)     at java.lang.Thread.run(Thread.java:745)  
asked
1 answers
0

Hi Luis, You can't set such properties in the Mendixcloud free or licensed, because that are particular Java options. But in your project you can set default timezone settings for users and scheduled events, have a look at the documentation.  But even writing this answer I doubt if this will work, give at a try.

Otherwise you can try to set the java property from some Java code, but still it's the question if Mendix allows you to set the property. Have a look at this stackoverflow post: How to set a JVM TimeZone Properly

answered