My Oracle Support Banner

Transporting SQL Baseline To Different Database, Unpack Fails With Error "ORA-31011: XML Parsing Failed" & "LPX-00229: input source is empty" (Doc ID 2968425.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.17.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Transporting SPM Baseline plans from one 19c database to another 19c database, received below errors in target environment while SPM unpacking:

DECLARE
x number;
BEGIN
x := dbms_spm.unpack_stgtab_baseline('SQLB_19C', user);
END;

Error report:

ORA-31011: XML parsing failed
ORA-06512: at "SYS.DBMS_SMB", line 1692
ORA-19202: Error occurred in XML processing
LPX-00229: input source is empty
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SMB", line 945
ORA-06512: at "SYS.DBMS_SMB", line 1664
ORA-06512: at "SYS.DBMS_SPM", line 1945
ORA-06512: at line 4

 

Changes

 None

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
Changes
Cause
Solution


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