ORA-01805: possible error in date/time operation | Adobe Higher Education
Skip to main content
November 18, 2022
해결됨

ORA-01805: possible error in date/time operation

  • November 18, 2022
  • 1 답변
  • 2361 조회

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__

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

1 답변

Shubham_Goyal__
Level 6
November 22, 2022

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