OBIEE 11g: Error: "Unable To Create Saw Session. Please Verify Server Connection" Opening Upgraded BI Publisher Report based on OBIEE Analysis (Doc ID 1358423.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
***Checked for relevance on 07-Mar-2013***
***Checked for relevance on 12-Aug-2014***
***Jan 2016****

Symptoms

Environment includes new install of Oracle Business Intelligence Enterprise Edition (OBIEE)
11.1.1.5 with OBIEE and BI Publisher.
This environment includes upgraded OBIEE and BI Publisher 10g web catalogs and repositories.

A test user has the BIAdministrator and BIAuthor roles as well as the upgraded XMLP_ADMIN role.

When logging in to BI Publisher, this user can see all of the menus and catalog items and is able to
open and run the sample BI Publisher reports without error.
However, opening one of the upgraded BI Publisher reports (which is based on an Oracle BI Analysis), fails with the following error message:

oracle.xdo.XDOException: oracle.xdo.XDOException: Unable to create saw session. Please verify the server connection

The following messages are in the bipublisher.log:

[2011-09-07T08:23:36.793+08:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 14] [userId: <anonymous>] [ecid: 3ec5aabd594a95d1:7a074e4a:1323f26e657:-8000-0000000000001711,0] [APP: bipublisher#11.1.1] javax.servlet.ServletException: oracle.xdo.XDOException: oracle.xdo.XDOException: Unable to create saw session. please verify the server connection[[
at oracle.xdo.servlet.XDOServlet.handleRequest(XDOServlet.java:357)
at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:218)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
...
...
Caused by: oracle.xdo.XDOException: oracle.xdo.XDOException: Unable to create saw session. please verify the server connection
at oracle.xdo.servlet.ReportException.fillInStackTrace(ReportException.java:124)
at java.lang.Throwable.<init>(Throwable.java:181)
at java.lang.Exception.<init>(Exception.java:29)
at oracle.xdo.servlet.ReportException.<init>(ReportException.java:40)
at oracle.xdo.servlet.CreateException.<init>(CreateException.java:23)
at oracle.xdo.servlet.ReportRepository.getReport(ReportRepository.java:202)
at oracle.xdo.servlet.XDOServlet.handleRequest(XDOServlet.java:336)
... 41 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