Connector Xpress Oracle Connection Errors ORA-00604 and ORA-01882

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

When attempting to connect to an Oracle database via Connector Xpress, the connection may fail with the following recursive SQL error:

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

These errors occur when the Java runtime environment used by Connector Xpress or the application is incompatible with the time zone data version on the Oracle database server.

Environment

Identity Manager 14.x

Cause

• Time Zone Version Mismatch: The Oracle database is using a time zone version that is not recognized by the Java runtime environment configured for Connector Xpress.
• Configuration: The Java process running Connector Xpress is not explicitly handling the time zone configuration required by the Oracle JDBC driver.

Resolution

Method 1: Configure Time Zone Variable (Workaround) If patching the database is not immediately feasible, you can force the JVM to ignore the time zone region lookup by adding a parameter to the Connector Xpress startup script.

1. Navigate to the Connector Xpress installation directory (typically: \INSTALL-PATH\Connector Xpress\bin).
2. Create a backup copy of the ConnectorXpress.bat file.
3. Edit ConnectorXpress.bat and add the following argument to the Java command line:
   -Doracle.jdbc.timezoneAsRegion=false
4. Save the file and restart Connector Xpress.

Method 2: Database Time Zone Update (Root Cause Fix) If the issue persists, your Database Administrator (DBA) should verify and update the time zone version on the Oracle database server.

1. Consult with your DBA to check the current time zone version installed on the Oracle instance.
2. Apply the appropriate time zone patch provided by Oracle to match the requirements of the database version (e.g., Oracle 19c).
   • Reference: Oracle Time Zone Version Upgrade Documentation