My Oracle Support Banner

OBIEE 11g Analysis Runs in OBIEE Presentation Server; Gives Blank Screen And Fails To Generate XML When Run in BI Publisher 11g (Doc ID 1587154.1)

Last updated on MAY 06, 2019

Applies to:

Oracle Exalytics Software - Version to [Release 1.0]
Business Intelligence Suite Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


Using Oracle Business Intelligence Enterprise Edition (OBIEE) and with OBI Publisher (BIP) on an Oracle Exalytics server.
Some of the OBIEE Analyses are run in OBIEE Presentation server and always return expected results.

If any of these analyses are used as a data source in a BIP report, and "Get XML output" is clicked, no output is ever created and the screen goes blank.

If the "get data engine log" button is clicked, no log file ever displays.

The OBIEE presentation server log shows that the query was executed and that rows were returned, but then activity seems to stop and hang when running ExecuteXMLQuery:

<SawDataSet> <getSAWReportXMLData> SawDataSet: execute webservice call.
  <AbstractSawXmlViewService> <getXMLQueryResults> Start Invoking
  <AbstractSawXmlViewService> <getXMLQueryResults> Before Query Results...

This problem is limited to those BIP reports that use an OBIEE Analysis (which is stored in the catalog), as a data source.  If SQL datasets, or other data sources, are used; the BI Publisher reports consistently work as expected.




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.