Mid server issue

VaishnaviW
Tera Contributor

14 hours ago

MID Server reported error: SQLState: null
java.sql.SQLException: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
0 Helpfuls
  • 75 Views
1 REPLY 1

Maham Tahir
Mega Guru

2 hours ago

Hi @VaishnaviW,

 

The error ORA-01882 indicates a Timezone mismatch between the Java environment on your MID Server and the Oracle Database. The MID Server is sending a Timezone Region ID (e.g., specific OS region) that the Oracle Database does not recognize or support.

 

You need to configure the MID Server to stop sending the "Timezone Region" to the database.

  1. Log in to your MID Server host.

  2. Navigate to the agent/conf folder and open wrapper-override.conf.

  3. Add the following line (replace X with the next available number in your file):
    wrapper.java.additional.X=-Doracle.jdbc.timezoneAsRegion=false

  4. Restart the MID Server service.

If you find my response helpful, mark it as helpful and accepted solution.

 

Regards, 

Maham Tahir.

0 Helpfuls