SQLException: ORA-00604 & ORA-01882: timezone region not found Issue

Hari_Lingala — Sat, 16 Nov 2024 02:25:57 GMT

Hello,

ORACLE Source : QA Environment

Talend Job Server : Development & QA

Scenario [1] - Talend Job execution through TAC-Development connecting to ORACLE Source [QA Environment] ; job is successful

Scenario [2] - Talend Job execution through TAC-QA connecting to ORACLE Source [QA Environment] ; job is successful

In the above both cases source is same ; but, Talend Job Server differs.

We are getting the following error while trying to execute SELECT statement on ORACLE:

Error :

Exception in component tOracleInput_2 (Job_src_inj_oracle)
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: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 java.sql.DriverManager.getConnection(DriverManager.java:664)

Please provide the solution.

Re: SQLException: ORA-00604 & ORA-01882: timezone region not found Issue

manodwhb — Fri, 15 May 2020 13:43:59 GMT

@lhari77kishore ,check the below link and look for the installed jar in both environments.

https://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found/22761437

topic Re: SQLException: ORA-00604 & ORA-01882: timezone region not found Issue in Talend Studio

SQLException: ORA-00604 & ORA-01882: timezone region not found Issue

Re: SQLException: ORA-00604 & ORA-01882: timezone region not found Issue