EM 13.5c: Source Database AWR Upload Fails to Repository
(Doc ID 2949797.1)
Last updated on JUNE 30, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager cloud control console, the source database is added to AWR Repository. But the AWR upload is failing for all the source databases with below error.
AWR Warehouse upload fails on Step: prepareDestinationFiles
The error is
Failed to insert dump files: ORA-01722: invalid number (DBD ERROR: error possibly near <*> indicator at char 239 in
'INSERT INTO DBSNMP.CAW_LOAD_METADATA
(DUMP_ID, DUMP_FILE, DUMP_DIR, EM_ID, TARGET_NAME, TARGET_TYPE,
DBID, DUMP_SIZE, BEGIN_SNAP_ID, END_SNAP_ID, STATUS) VALUES
(DBSNMP.CAW_DUMP_ID_SEQ.NEXTVAL, :p1, :p2, :<*>p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10)')
at <Agent Base>/agent_13.5.0.0.0/plugins/oracle.sysman.db.agent.plugin_13.5.1.0.0/scripts/db/transfer_awr.pl line 1045.
The error is
Failed to insert dump files: ORA-01722: invalid number (DBD ERROR: error possibly near <*> indicator at char 239 in
'INSERT INTO DBSNMP.CAW_LOAD_METADATA
(DUMP_ID, DUMP_FILE, DUMP_DIR, EM_ID, TARGET_NAME, TARGET_TYPE,
DBID, DUMP_SIZE, BEGIN_SNAP_ID, END_SNAP_ID, STATUS) VALUES
(DBSNMP.CAW_DUMP_ID_SEQ.NEXTVAL, :p1, :p2, :<*>p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10)')
at <Agent Base>/agent_13.5.0.0.0/plugins/oracle.sysman.db.agent.plugin_13.5.1.0.0/scripts/db/transfer_awr.pl line 1045.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |