Windows Server 2008 ORACLE Deployment Error - ORA-00604

2
Hi there We currently have a MENDIX application running on a Windows Server 2008 R2 machine, pointing to a SQL SERVER 2008 database, working 100%. Ultimately we would like to run it on an ORACLE 11g database from the Windows Server 2008 R2. When we change the MENDIX Database settings to point to the ORACLE database we get the following errors : Request action: start Message: Initializing the ConnectionBus failed. Cause: ab: Error on initializing database connection. Stack trace: com.mendix.m2ee.api.AdminException: Initializing the ConnectionBus failed. at com.mendix.core.MxRuntime.b(SourceFile:441) at com.mendix.core.MxRuntime.a(SourceFile:211) at lH.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:84) 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) Caused by: N: ab: Error on initializing database connection. Caused by: ab: Error on initializing database connection. at av.b(SourceFile:1358) Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:359) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:157) at org.apache.commons.dbcp.DataSourceConnectionFactory.createConnection(DataSourceConnectionFactory.java:43) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) at eb.a(SourceFile:42) at av.d(SourceFile:1429) at av.b(SourceFile:1332) at av.a(SourceFile:1230) at el.a(SourceFile:42) at jS.a(SourceFile:46) at jp.a(SourceFile:191) at jp.a(SourceFile:110) at com.mendix.core.MxRuntime.b(SourceFile:433) at com.mendix.core.MxRuntime.a(SourceFile:211) at lH.execute(SourceFile:54) at com.mendix.m2ee.server.handler.AdminHandler.handle(AdminHandler.java:84) 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) AND : Opening JDBC connection failed with SQLState: 60000 Message: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found , giving up...(3/3) Moving the deployment to an older Windows Server 2003 machine, the ORACLE database connection works fine and the application runs 100%. What are we missing? Kind Regards Frikkie Chalmers
asked
3 answers
4

Searching the internet for 'ORA-00604' give much of results, like http://forums.oracle.com/forums/thread.jspa?threadID=839802

Maybe this error has the same cause as this error: https://forum.mendix.com/questions/747/Database-connection-error

answered
3

Thank you for the links.

We were actually google-ing frantically for the last couple of days. Trying all possible solutions given to us regarding system locale and setup.

Just found this link http://forums.oracle.com/forums/thread.jspa?messageID=9141037&#9141037 while following the above mentioned links.

In the project settings, on the server tab, I went and added "Extra JVM Parameters", -Duser.timezone=GMT.

This fixed my problem.

answered
0

Hi Frikkie,

I have a simular problem as described in your (very) old forum item. I tried to go to the links in this question but they are unreachable. Can you remember how you solved this problem?

 

regards,

 

Andre

answered