My Oracle Support Banner

After Creating Data Model View Data Using Logical SQL Fails With XML Parsing Error: no root element found (Doc ID 2280111.1)

Last updated on AUGUST 25, 2021

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.2 and later
Information in this document applies to any platform.


Problem Summary
Issue with View Data when creating Data Model using Logical SQL

Problem Description
Clicking on View on Data tab in Data model results in 'Failed to load XML' message.

The file shows the developer screen for Firefox developer.

It shows these warning and errors:
Synchronous XMLHttpRequest on the main thread is deprecated because of its detrimental effects to the end user's experience. For more help http://<HOST>.org/
XML Parsing Error: no root element found Location: https://<HOST>.com/xmlpserver/servlet/dmvalidate?cmd=endecaSchemas Line Number 1, Column 39
Blocked loading mixed active content "http://XXXXXX"

In IE11 developer tools.

There is an error message.
XML5632L Only one root element is allowed. Line:1 Column 39
SEC7127: Redirect was blocked for CORS request
File xdmeditor.jsp
SCRIPT7002: XMLhttpRequest: Network Error 0x2ef1, Could not complete the operation due to error 00002ef1.
File: xdmeditor.jsp


 A load balancer was setup and needs proper configuration.


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

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