ORA-01805: Possible error in date/time operation

Last update: 2024-01-18

“In this article you will learn about the steps to fix the Adobe Campaign error - ORA-01805: possible error in date/time operation. You can resolve it by setting the time zone along with update and restart.”

Description

Environment

Campaign

Issue/Symptoms

After upgrading the Campaign database server to Oracle 19c this error occurs : 2022-03-14 08:06:08 ORA-210000 Oracle error: ORA-01805: possible error in date/time operation.

Resolution

The error received is from the Oracle and occurs when:

  • The time zone is not correctly set on the database.
  • The client and the database do not use the same time zone file.

The Oracle Client and Database must be aligned, as it’s not a Campaign issue, but an Oracle requirement. Update the Oracle Client and restart.

On this page