Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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)
Labels (4)
4 Replies
Anonymous
Not applicable
Author

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

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)
Anonymous
Not applicable
Author

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