Forum Post: RE: Oracle on-premise data source connection error

[rhri2001]

Any help on this. I see following error inside log file under C:\Program Files\Progress\DataDirect\Cloud_OnPremise_Connector_20\OPDAS\server\logs\das 10-Dec-2014 15:13:30.660 SEVERE [http-bio-10180-exec-45] [rhri2001][oracle][rkora11gr2_oe][zUT/s66SlsJxiIfy].[login] Exception handled: java.sql.SQLException: [DD Cloud OP][Oracle JDBC Driver][Oracle]ORA-01882: timezone region not found Log file 10-Dec-2014 15:13:30.660 SEVERE [http-bio-10180-exec-45] [rhri2001][oracle][rkora11gr2_oe][zUT/s66SlsJxiIfy].[login] Exception handled: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.ddtek.cloudservice.servlets.ddn.a(Unknown Source) at com.ddtek.cloudservice.servlets.ddax.b(Unknown Source) at com.ddtek.cloudservice.servlets.CloudSql.h(Unknown Source) at com.ddtek.cloudservice.servlets.CloudSql.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:595) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:683) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [DD Cloud OP][Oracle JDBC Driver][Oracle]ORA-01882: timezone region not found at com.ddcloudop.jdbc.oraclebase.ddcr.b(Unknown Source) at com.ddcloudop.jdbc.oraclebase.ddcr.a(Unknown Source) at com.ddcloudop.jdbc.oraclebase.ddcq.b(Unknown Source) at com.ddcloudop.jdbc.oraclebase.ddcq.a(Unknown Source) at com.ddcloudop.jdbc.oracle.OracleImplConnection.k(Unknown Source) at com.ddcloudop.jdbc.oraclebase.BaseConnection.setD2CClientTimeZone(Unknown Source) ... 27 more 10-Dec-2014 15:13:30.660 SEVERE [http-bio-10180-exec-45] [rhri2001][oracle][rkora11gr2_oe][zUT/s66SlsJxiIfy].[login] exception [token=Error][errorCode=222206058][sqlState=HY000][origin=INTERNAL][message=java.lang.reflect.InvocationTargetException] 10-Dec-2014 15:13:30.660 CONFIG [http-bio-10180-exec-45] [rhri2001][oracle][rkora11gr2_oe][zUT/s66SlsJxiIfy].[login] exception [token=Error][errorCode=222206058][sqlState=HY000][origin=UNKNOWN][message=java.lang.reflect.InvocationTargetException] 10-Dec-2014 15:13:30.660 INFO [http-bio-10180-exec-45] [rhri2001][oracle][rkora11gr2_oe][zUT/s66SlsJxiIfy].[login] [success=false][ms=24][das ms=1][bytesIn=326][bytesOut=144][token=Login][dataSource=RKOra11gr2_OE][userID=rhri2001][password= specified ][clientID=DD Cloud OP JDBC (2.0.0.000058)][timezone=Universal][flags=5]Data Source{[Name=RKOra11gr2_OE][D2C User=rhri2001][Data Source User=][Logging Level=CONFIG][Log Privacy=ALLOWNONE]Properties{[clientTimezone=Universal][ConnectionRetryCount=0][ServerName=RKSHAH-DT.AMER.CORP.NATINST.COM][SID=Ora11gr2]}}[internalConnect=0] 10-Dec-2014 18:41:47.857 SEVERE [http-bio-10180-exec-1] [rhri2001][oracle][rkora11gr2_oe][D5uQFBGKm7gF5Qrq].[login] Exception handled: Thank RK

[url="https://community.progress.com/community_groups/datadirect_cloud/f/15/p/14852/53534.aspx#53534"]Continue reading...[/url]