topic Re: tSQLScriptParser not work in Linux in Talend Studio

tSQLScriptParser not work in Linux

Anonymous — Fri, 24 Feb 2017 02:58:41 GMT

Dear
I am build job run well on Windows, but not work when run on Linux. Please help me. Thanks!
this error on Linux server:
Exception in component tOracleInput_1
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)

Re: tSQLScriptParser not work in Linux

Anonymous — Fri, 24 Feb 2017 06:24:17 GMT

Hi,
Did you run your job script .sh file on Linux?
Best regards
Sabrina

Re: tSQLScriptParser not work in Linux

cterenzi — Fri, 24 Feb 2017 18:16:01 GMT

Possibly relevant:
http://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found

Re: tSQLScriptParser not work in Linux

vapukov — Fri, 24 Feb 2017 23:40:39 GMT

Possibly relevant:
http://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found

think yes, and from answer, think add JDBC settings - oracle . jdbc . timezoneAsRegion = false could be more easiest solution, but need test of course (I do not have this error)

Re: tSQLScriptParser not work in Linux

Anonymous — Sat, 25 Feb 2017 04:28:03 GMT

Dear all,
- Thanks for your help! I try modify DB Version (Oracle 10) of tOracleInput1, Job run good in Linux server.