ORA-01805: Possible error in date/time operation

“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 description




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 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.

Ask Questions In Our Experience League Campaign Community
If you have any questions you’d like answered about this topic, or read previous answered-questions, we invite you to view our Experience League Community blog post that includes this article, send us your questions and comments, and join our Experience League Campaign Community!