ORA-01805: possible error in date/time operation

[Allianz123]

Following an upgrade from Oracle 12c to 19c whenever I run any workflow in ACC v7 I immediately get these errors :-

26/10/2022 10:22:38        ORA-210000 Oracle error: ORA-01805: possible error in date/time operation

The on-prem database and application servers both claim to be in time zone GMT ?

i.e. select dbtimezone from dual; returns GMT

Any idea how I can investigate this further please ?

[Shubham_Goyal__ · Accepted solution]

Hi @Allianz123 ,

The problem does not seem to be due to the Adobe campaign but seems like a bug in the Oracle release itself.

Here is what I find for you that may help to investigate the issue from Oracle's side,

Discussion from StackOverflow

Error Code ORA-01805 Description

Br,

Shubham