DevTest JDBC Error - ORA-01882: timezone region not found

Document ID : KB000074549
Last Modified Date : 22/03/2018
Show Technical Document Details
Issue:
DevTest JDBC Error - ORA-01882: timezone region not found 

Works fine when staging locally, when staging on a Linux machine errors.

This error is occurring on a JDBC step calling an Oracle database. 
Environment:
All supported DevTest releases and platforms.
Cause:
The Linux machine and Oracle database have different time zones.
Resolution:
As a Workaround added this property to the local.properties file for both the Coordinator and Simulator: 

oracle.jdbc.timezoneAsRegion=false 

The Linux machine and Oracle database have different timezones, and the above property says to ignore the timezone for Oracle. 

To not have to set this property, need to set the timezone of the Linux machine running the test to the same timezone of the Oracle database.