One Star

tSQLScriptParser not work in Linux

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)
4 REPLIES
Moderator

Re: tSQLScriptParser not work in Linux

Hi,
Did you run your job script .sh file on Linux?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Ten Stars

Re: tSQLScriptParser not work in Linux

Twelve Stars

Re: tSQLScriptParser not work in Linux

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)
-----------
One Star

Re: tSQLScriptParser not work in Linux

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