My Oracle Support Banner

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 NOVEMBER 18, 2019

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>:<port_number>/analytics or via BIP at http://<server>:<port_number>/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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.