The BW application that connects to Oracle database fails with below error when pushed to TIBCO Cloud Integration. It works in BW Studio.
Error:
[bwEngThread:In-Memory Process Worker-2] com.tibco.bw.core - TIBCO-BW-CORE-500050: The BW process [naz-jdbc-test.Process] instance faulted, JobId [bw0a100], ProcessInstanceId [bw0a100], ParentProcessInstanceId [-], Module [NAZ-JDBC-TEST:1.0.0.20200513100425], Application [NAZ-JDBC-TEST.application:1.0]. <CausedBy> TIBCO-BW-CORE-500051: Activity [JDBCQuery] fault. <CausedBy> com.tibco.bw.palette.jdbc.runtime.faults.JDBCConnectionNotFoundFault: Could not create Connection to server using Shared Resource [jdbcProperty].-{ActivityName=JDBCQuery, ProcessName=naz-jdbc-test.Process, ModuleName=NAZ-JDBC-TEST} <CausedBy> com.tibco.bw.sharedresource.jdbc.runtime.exceptions.ConnectionCreateException: com.tibco.bw.sharedresource.jdbc.runtime.exceptions.ConnectionCreateException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found <CausedBy> com.tibco.bw.sharedresource.jdbc.runtime.exceptions.ConnectionCreateException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found <CausedBy> java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found

Oracle connection fails with error "timezone region not found "

To resolve this issue please add this property "oracle.jdbc.timezoneAsRegion=false" under environment controls — > CUSTOM_ENGINE_PROPERTY
See the attached screenshot.