BI Publisher - Failed to load XML
I'm running OBIEE 12.2.1.4 on a Windows 2016 server. I have created a BI Publisher data model, using the Query Builder to create a single dataset with three columns selected from an OBIEE subject area. (Incidentally, I have also created a very simple data model with a single dataset pulling from one column in a database schema, bypassing OBIEE completely. The same problem described below is appearing in that case as well.)
In the Query Builder, I can click the Results link and see the data. Back on the Data Model, on the Data tab, I can click the Export button and I get the rows I am expecting, such as these:
====================================================================
<?xml version="1.0" encoding="UTF-8"?>
<!--Generated by Oracle BI Publisher 12.2.1.4.0 -Dataengine, datamodel:__P23456_Toyota_Test1_data_set_xdm -->
<DATA_DS>
<G_1>
<YEAR>2017</YEAR><SALES>3712313.63</SALES><DIVISION>Womens Apparel</DIVISION>
</G_1>
<G_1>
<YEAR>2016</YEAR><SALES>2242231.3</SALES><DIVISION>Mens Apparel</DIVISION>
</G_1>
</DATA_DS>
So, since the Export generates the data correctly, we know that the query is not malformed.
But when I click the View button (next to the Export button), I immediately see 'Failed to load XML' where the data should be. The screen is shaded gray, and there is a small dialog that says 'Processing', which shows the blue horizontal barber pole just sits there forever.
====================================================================
The relevant portion of the output from View Engine Log looks reasonable:
================= View Engine Log for OBIEE source ===================
[220829_09030042][dp id:161932798][sch info:]Writing Data ...
[220829_09030042][dp id:161932798][sch info:]Number of queries :1
[220829_09030042][dp id:161932798][sch info:]Returning Final Query from QueryParser:
select "Times"."Year" as "Year",
"Facts"."Sales" as "Sales",
"Products"."Division" as "Division"
from "BI Pub Class"."Products" "Products",
"BI Pub Class"."Facts" "Facts",
"BI Pub Class"."Times" "Times"
[220829_09030042][dp id:161932798][sch info:]DataSet Name:Test1: DB Fetch Size: 100
[220829_09030042][dp id:161932798][sch info:]DataSet Name:Test1: SQL Query Timeout: 500
[220829_09030042][dp id:161932798][sch info:]DataSet Name:Test1: SQL Query :Test1: select "Times"."Year" as "Year",
"Facts"."Sales" as "Sales",
"Products"."Division" as "Division"
from "BI Pub Class"."Products" "Products",
"BI Pub Class"."Facts" "Facts",
"BI Pub Class"."Times" "Times"
================= View Engine Log for database source ===================
[220829_09240024][dp id:2097004708][sch info:]DataSet Name:Test1: DB Fetch Size: 100
[220829_09240024][dp id:2097004708][sch info:]DataSet Name:Test1: SQL Query Timeout: 500
[220829_09240024][dp id:2097004708][sch info:]DataSet Name:Test1: SQL Query :Test1: select /* QUERY_SRC('datamodel: __P23456_Toyota_Test2_data_set_xdm,dataset:Test1') */ "BI_D_TIME"."MONTH" as "MONTH"
from "RETROTRAIN"."BI_D_TIME" "BI_D_TIME"
====================================================================
Thoughts?