Database Administration (MOSC)

MOSC Banner

XML parsing error on generating report

Hello all,

running oracle 19c on linux rhel. in one of the PDB's when trying to run an AMMD report i get the below error.

there are no invalid oracle objects in the PDB, the report runs fine on other PDB's within the same ROOT. the AWR report works


SET LINESIZE 200

SET LONG 1000000

SET PAGESIZE 0

SET LONGCHUNKSIZE 100000 

SELECT DBMS_STATS.report_advisor_task('AUTO_STATS_ADVISOR_TASK') AS REPORT 

FROM  dual; 


ORA-20012: Statistics Advisor: Error generating report details: ORA-31011: XML parsing failed

ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 3571

ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 891

ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 5377

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center