BI Publisher - error when calling Report (with Excel template) from Analytics - javax.xml.ws.soap.SO

Question

Summary BI Publisher - error when calling Report (with Excel template) from Analytics - javax.xml.ws.soap.SOAPFaultException Content Hi all, Currently on Oracle Business Intelligence 11.1.1.7.150120 (Linux). Using Analytics we have a Dashboard containing an analysis and prompt. The Dashboard works OK and produces the desired filtered HTML output based on the prompt selection. Since the customer needs the output on an Excel file; we used BI Publisher excel template feature to customize the output. To this end we created a Data Model object that feeds from the analysis and a Report object with an attached Excel template for the output. Opening the Report directly from BI Publisher, the Excel file gets generated correctly. We then added the Report object to the original Dashboard in the hopes of producing a filtered Excel file (via the prompts). It worked OK in Dev; but when moved to Test enviroment we get the following error: [2017-12-05T16:15:57.757+01:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 29] [userId: ] [ecid: 11d1def534ea1be0:-4a631186:16027372c96:-8000-000000000000058a,0] [APP: bipublisher#11.1.1] oracle.xdo.dataengine.datasource.plugin.DataAccessException: oracle.xdo.XDOException: java.rmi.RemoteException: Sax parser returned an exception.[[ Message: Invalid document structure, Entity publicId: , Entity systemId: , Line number: 1, Column number: 1; nested exception is: javax.xml.ws.soap.SOAPFaultException: Sax parser returned an exception. Message: Invalid document structure, Entity publicId: , Entity systemId: , Line number: 1, Column number: 1 at oracle.xdo.dataengine.datasource.plugin.DataAccessException.fillInStackTrace(DataAccessException.java:65) at java.lang.Throwable.(Throwable.java:241) at java.lang.Exception.(Exception.java:77) at oracle.xdo.dataengine.datasource.plugin.DataAccessException.(DataAccessException.java:33) at oracle.xdo.dataengine.datasource.plugin.saw.SawDataSet.execute(SawDataSet.java:105) at oracle.xdo.dataengine.datasource.SAWStatement.execute(SAWStatement.java:100) ... at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) Caused by: oracle.xdo.XDOException: java.rmi.RemoteException: Sax parser returned an exception. Message: Invalid document structure, Entity publicId: , Entity systemId: , Line number: 1, Column number: 1; nested exception is: javax.xml.ws.soap.SOAPFaultException: Sax parser returned an exception. The problem seems to be the call from Analytics to Publisher. Consulting the logs we can't understand what the problem is. Can anyone help ??? In attachment please find the original 'bipublisher.log'. Thank you, SBassabe (Trento Italy)

YGUTTIKONDA · Answer

SBassabe,

what user are you using ? if you are not already using the Admin user, can you try with that... another approach is to try putting this on a new dashboard and rule out any permission issue ..

Thanks,

Yugandhar

SBassabe · Answer

Hello timdxter,

first of all, thanks for taking the time to answer !!!

One of the first test I did was invoking the Report object by itself from the Publisher Interface, it works just fine (albeit not filtered, but this was expected). I can do the same thing directly from the Analytics interface, where the same Report object is accessible via the catalog; even here the Excel get generated without any problems.

I have a feeling there is something with 'permissions' that is not working. As if there has to be something granted to the Dashboard in Analytics to be able to invoke a report in Publisher.

Does the attached log file give any hint of what the problem could be !?!?!

Thanks,

SBassabe

timdexter · Answer

Hi SBassabe

Clearly there is some difference between your dev and test environments?

Googling gets a few hits on this issue but not specifically for the invalid document structure e.g. https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/1913713_1.htm…

The error appears to be related to the data engine and it is not getting the XML from the Analysis in a valid format.

Have you tried taking the query form the Analysis and plugging that into the BIP data model and see if that works?

Tim