Possible bug on Default Timezone with ORACLE DB

0
Hi There, We just upgraded our project from 2.5.8 to 3.3.1, and everything works perfectly. We are running on a ORACLE 11 Database. Is this a Mendix Or ORACLE issue, seeing that ORACLE did have this bug in version 8. When we set the Default Time Zone to (GMT +2:00) Johannesburg, we get this error : Request action: start Message: Starting MxRuntime failed. Cause: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.User[not(System.UserTimeZone/System.TimeZone)][IsAnonymous='false']"}', all database changes executed by this action were rolled back Stack trace: com.mendix.m2ee.api.AdminException: Starting MxRuntime failed. at com.mendix.core.MxRuntime.y(SourceFile:245) Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.User[not(System.UserTimeZone/System.TimeZone)][IsAnonymous='false']"}', all database changes executed by this action were rolled back at hk.b(SourceFile:170) Caused by: com.mendix.core.CoreRuntimeException: Exception occurred in action '{"amount":-1,"sort":{},"offset":-1,"type":"RetrieveXPathAction","depth":0,"xpath":"//System.User[not(System.UserTimeZone/System.TimeZone)][IsAnonymous='false']"}', all database changes executed by this action were rolled back at com.mendix.core.actionmanagement.CoreAction.c(SourceFile:493) Caused by: d: An exception has occurred for the following request(s): fn (depth = 0): //System.User[not(System.UserTimeZone/System.TimeZone)][IsAnonymous='false'] Caused by: d: Exception occurred while retrieving data. (SQL State: 42000, Error Code: 1795) Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491) at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at w.a(SourceFile:322) at w.a(SourceFile:215) at w.a(SourceFile:165) at w.a(SourceFile:154) at n.a(SourceFile:43) at dt.a(SourceFile:349) at dt.a(SourceFile:325) at dt.a(SourceFile:207) at dt.a(SourceFile:158) at dt.a(SourceFile:86) at dx.a(SourceFile:67) at l.a(SourceFile:45) at a.a(SourceFile:249) at ha.b(SourceFile:124) at ha.a(SourceFile:65) at gW.a(SourceFile:60) at gW.executeAction(SourceFile:20) at com.mendix.systemwideinterfaces.core.UserAction.execute(SourceFile:48) at com.mendix.core.actionmanagement.CoreAction.call(SourceFile:435) at hk.b(SourceFile:156) at com.mendix.core.Core.retrieveXPathQuery(SourceFile:829) at com.mendix.core.Core.retrieveXPathQuery(SourceFile:1001) at kq.b(SourceFile:124) at kq.a(SourceFile:68) at com.mendix.core.MxRuntime.z(SourceFile:279) at com.mendix.core.MxRuntime.y(SourceFile:235) at com.mendix.core.MxRuntime.a(SourceFile:217) at com.mendix.core.MxRuntime.b(SourceFile:170) at fH.a(SourceFile:49) at fG.execute(SourceFile:26) at com.mendix.m2ee.server.handler.HttpAdminHandler.handle(HttpAdminHandler.java:121) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) at org.eclipse.jetty.server.Server.handle(Server.java:334) at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559) at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:992) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:550) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203) at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:462) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436) at java.lang.Thread.run(Thread.java:662)
asked
2 answers
0

It must be related to this : "On the ‘Model’ tab you can specify a default time zone. This time zone is used for new users, but it is also applied to all users that do not have a time zone yet when starting your application." ???

answered
0

What will the outcome be if we don't set the default? Will it use the server's time zone or GMT?

answered