My Oracle Support Banner

EM 13c: Data model creation in BIP Fails with error "Failed to load XML" (Doc ID 2670245.1)

Last updated on JUNE 08, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 to 13.3.1.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

In EM 13c BIP, Creating a data model with the below query gives an error: "Failed to Load XML"

Query used in datamodel :


select "MGMT$ALERT_CURRENT"."TARGET_NAME" as "TARGET_NAME",
"MGMT$ALERT_CURRENT"."TARGET_TYPE" as "TARGET_TYPE",
"MGMT$ALERT_CURRENT"."TARGET_GUID" as "TARGET_GUID",
"MGMT$ALERT_CURRENT"."METRIC_NAME" as "METRIC_NAME",
"MGMT$ALERT_CURRENT"."KEY_VALUE" as "KEY_VALUE",
"MGMT$ALERT_CURRENT"."COLLECTION_TIMESTAMP" as "COLLECTION_TIMESTAMP",
"MGMT$ALERT_CURRENT"."MESSAGE" as "MESSAGE"
 from "SYSMAN"."MGMT$ALERT_CURRENT" "MGMT$ALERT_CURRENT"

Running this query in Repository database working fine. 


ERROR
-----------------------
In BIP console, under  "View Data", the error message is "Failed to load XML."

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


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