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 15, 2017

Applies to:

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

Symptoms

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://xhr.spec.whatwg.org/
XML Parsing Error: no root element found Location: https://safetymartdevlx.quintiles.com/xmlpserver/servlet/dmvalidate?cmd=endecaSchemas Line Number 1, Column 39
Blocked loading mixed active content "http://safetymartdevlx.quintiles.com/xmlpserver/dmloading.jsp?_xdo=%2FOracle+SR%2FView+Data+Issue%2FProduct_DM.xdm&_id=1c7784f5-f188....._genstatus="


In IE11 developer tools.

There is an error message.
Sync load master/master.xml
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

Changes

 A load balancer was setup and needs proper configuration.

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