OBIEE 11g: A BI Publisher Report Based on a BI Analysis throws "Unable to create saw session. Please verify the server connection."

(Doc ID 2262438.1)

Last updated on MAY 04, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

In an OBIEE-BIP environment, there is a BI Publisher (BIP) report with a Data Model with an "Oracle BI Analysis" Data Set.

When the BI Publisher report is executed or opened ... whether via OBIEE at http://<server>:9704/analytics or via BIP at http://<server>:9704/xmlpserver ... see the "Unable to create saw session. Please verify the server connection" error is thrown.

For example, see the error as it is thrown in an OBIEE dashboard where the BIP report is embedded:-

 

The following errors are observed in the <MW_HOME>\user_projects\domains\bifoundation_domain\servers\bi_server1\logs\bipublisher\bipublisher.log:-

[bi_server1] [WARNING] [] [oracle.xdo] [tid: 92] [userId: <anonymous>] ... [APP: bipublisher#11.1.1] com.sun.xml.ws.wsdl.parser.InaccessibleWSDLException: 2 counts of InaccessibleWSDLException.[[

java.io.IOException: Read channel closed
java.io.IOException: Read channel closed

at com.sun.xml.ws.wsdl.parser.RuntimeWSDLParser.tryWithMex(RuntimeWSDLParser.java:182)
at com.sun.xml.ws.wsdl.parser.RuntimeWSDLParser.parse(RuntimeWSDLParser.java:153)
at com.sun.xml.ws.client.WSServiceDelegate.parseWSDL(WSServiceDelegate.java:284)
at com.sun.xml.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:246)
at com.sun.xml.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:197)
at com.sun.xml.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:187)
at weblogic.wsee.jaxws.spi.WLSServiceDelegate.<init>(WLSServiceDelegate.java:84)
at weblogic.wsee.jaxws.spi.WLSProvider$ServiceDelegate.<init>(WLSProvider.java:598)
at weblogic.wsee.jaxws.spi.WLSProvider.createServiceDelegate(WLSProvider.java:120)
at weblogic.wsee.jaxws.spi.WLSProvider.createServiceDelegate(WLSProvider.java:112)
at weblogic.wsee.jaxws.spi.WLSProvider.createServiceDelegate(WLSProvider.java:83)
at javax.xml.ws.Service.<init>(Service.java:56)
at oracle.xdo.service.report.saw.soap.v7.WebCatalogService.<init>(WebCatalogService.java:42)
at oracle.xdo.service.report.saw.wrapper.v7.SawMtomCatalogServiceImpl.createService(SawMtomCatalogServiceImpl.java:61)
...

[bi_server1] [WARNING] [] [oracle.xdo] [tid: 92] [userId: <anonymous>] ... [APP: bipublisher#11.1.1] oracle.xdo.XDOException: oracle.xdo.XDOException: Unable to create saw session. please verify the server connection[[
at oracle.xdo.servlet.definition.v2.DataModelParser.createReportParameters(DataModelParser.java:280)
at oracle.xdo.servlet.definition.v2.DataModelParser.endElement(DataModelParser.java:217)
...
Caused by: oracle.xdo.XDOException: oracle.xdo.XDOException: Unable to create saw session. please verify the server connection
at oracle.xdo.dataengine.datasource.plugin.saw.SawParameter.getParameterObjects(SawParameter.java:242)
at oracle.xdo.dataengine.ParameterImpl.createParameterObjects(ParameterImpl.java:166)
at oracle.xdo.servlet.dataengine.saw.SAWParameter.createParameters(SAWParameter.java:112)
at oracle.xdo.servlet.definition.v2.DataModelParser.createReportParameters(DataModelParser.java:268)
... 57 more
Caused by: oracle.xdo.XDOException: Unable to create saw session. please verify the server connection
at oracle.xdo.dataengine.datasource.plugin.saw.SawDataSet.getSAWParameters(SawDataSet.java:359)
at oracle.xdo.dataengine.datasource.plugin.saw.SawParameter.getParameterObjects(SawParameter.java:239)
... 60 more

]]

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