Symptoms

• Failure of database test connection from a Pega Cloud instance to an external database.
• Data flows fail to fetch records from an external database.

Errors

• Status Value: Database-General Connection Exception 604 60000 ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found DatabaseException caused by prior exception: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found | SQL Code: 604 | SQL State: 60000
• Unable to query the database: code: 1882 SQLState: 22008 Message: ORA-01882: timezone region not found

Explanation

An issue in user’s operating environment. The connection query is based on date and time. However, user’s time zone is different from that of the external database or is missing for the node on which the agent is run.

Environments

The issue was reported in the following environments:

• Pega Platform 8.7.1 on Pega Cloud 2.23.2
• Pega Platform 8.5.6 on Pega Cloud 2.24.2
• Pega Platform 8.4.3 on Pega Cloud 2.18.2
• Pega Platform 8.4.1 on Pega Cloud 2.18.2
• Pega Platform 8.3.6 on Pega Cloud 2.23.3
• Pega Platform 7.4 on Pega Cloud 2.18.4
   

Solution

Perform the following local change:

1. Add the JVM parameter, -Duser.timezone=UTC(Any timezone)
2. Restart the node.

Related Content

Creating database data instances

How to set up JDBC Connection to External Database