EM 13c: Running custom SQL fails with following errors against EM repository DB: 'ORA-01722: Invalid Number' and 'ORA-01847: day of month must be between 1 and last day of month'
(Doc ID 2801775.1)
Last updated on SEPTEMBER 20, 2021
Applies to:Enterprise Manager Base Platform - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
After upgrading the EM Repository Database, custom SQL statement is failing:
ORA-01722: Invalid Number
ORA-01847: day of month must be between 1 and last day of month
Issue related to Parent Note
EM 13c While running the Customer SQL failed with ORA-01722: Invalid Number After upgrading the repository DB from 12c to 19c (Doc ID 2700945.1)
Below lists other custom SQL statement failing with error 'ORA-01722: Invalid Number' and 'ORA-01847: day of month must be between 1 and last day of month' that are documented below:
1) Metric Extension created (i.e. ME$ALT_TABLESPACE_MONI) and sql being used in ME is below :
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document