ORA-01805: possible error in date/time operation | Community
Skip to main content
Allianz123
New Participant
Nov 18, 2022 2:50 PM UTC
Solved

ORA-01805: possible error in date/time operation

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 ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Shubham_Goyal__
Shubham_Goyal__Accepted solution
Level 6
Nov 22, 2022 8:14 AM UTC

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

View reply

1 reply

Shubham_Goyal__
Shubham_Goyal__Accepted solution
Level 6
Nov 22, 2022 8:14 AM UTC

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

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...