Statistics Advisor is generating ORA-31011: XML parsing failed Error (Doc ID 2915768.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Statistics Advisor is generating ORA-31011: XML parsing failed Error.

DECLARE
  v_tname VARCHAR2(128) := 'test_report';
  v_ename VARCHAR2(128) := NULL;
  v_report CLOB := NULL;
  v_script CLOB := NULL;
BEGIN
  v_tname := DBMS_STATS.CREATE_ADVISOR_TASK(v_tname);
  v_ename := DBMS_STATS.EXECUTE_ADVISOR_TASK(v_tname);
  v_report := DBMS_STATS.REPORT_ADVISOR_TASK(v_tname);
  DBMS_OUTPUT.PUT_LINE(v_report);
END;
/

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
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 5377
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 1603
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 1603
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 1724
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 3555
ORA-06512: at "SYS.DBMS_STATS", line 58555
ORA-06512: at line 1

XML.TRC Trace file shows these details.

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0
Build label: RDBMS_19.17.0.0.0DBRU_LINUX.X64_220924

*** 2022-12-09T07:57:00.362972-05:00 (MMC(3))
*** SESSION ID:(487.18660) 2022-12-09T07:57:00.363001-05:00
*** CLIENT ID:() 2022-12-09T07:57:00.363006-05:00
*** SERVICE NAME:(mmc) 2022-12-09T07:57:00.363010-05:00
*** MODULE NAME:(SQL*Plus) 2022-12-09T07:57:00.363015-05:00
*** ACTION NAME:() 2022-12-09T07:57:00.363019-05:00
*** CLIENT DRIVER:(SQL*PLUS) 2022-12-09T07:57:00.363022-05:00
*** CONTAINER ID:(3) 2022-12-09T07:57:00.363026-05:00

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=10, mask=0x0)
----- Error Stack Dump -----
<error barrier> at 0x7ffce7410470 placed dbkda.c@298
ORA-31011: XML parsing failed >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
ORA-19213: error occurred in XML processing at lines 1
LPX-00245: extra data after end of document
<error barrier> at 0x7ffce74189f0 placed pci.c@4806

----- Current SQL Statement for this session (sql_id=0u377zx5ubb2c) -----
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ PV.PNAME PNAME, PV.PVALUE PVALUE, DECODE(A.ISSTRING, 1, 'YES', 'NO') ISSTRING FROM (SELECT EXTRACTVALUE(VALUE(P), 'param/@name') PNAME, EXTRACTVALUE(VALUE(P), 'param/@val') PVALUE FROM TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE(:B1 ), '//param'))) P) PV, TABLE(:B2 ) A WHERE A.ARG = UPPER(PV.PNAME) AND PV.PVALUE IS NOT NULL AND A.PROC = UPPER(:B3 ) ORDER BY A.POS DESC

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x18d0238d0 310 type body SYS.XMLTYPE.XMLTYPE
0x8c5421f0 1 anonymous block
0xbeeeffe0 1087 package body SYS.DBMS_STATS_ADVISOR.I_RECONSTRUCT_STATS_OPR
0xbeeeffe0 5648 package body SYS.DBMS_STATS_ADVISOR.REPORT_OPR_DETAILS ....................

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.