Executing Procedure To Create AW from XML File From SQL Session Returns Error "XML-20108: (Fatal Error) Start of root element expected." (Doc ID 464217.1)

Last updated on MAY 12, 2017

Applies to:

Oracle OLAP - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

Importing an XML template using the DBMS_AW_XML package from SQL*Plus fails without creating the AW.  The procedure ends with the error:

Success <Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected.

But the same template import works when imported from AWM.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms