Saturday, December 29, 2012

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


I tried to create BI Publisher Data Model using OBIEE 11G report as source and I got the bellow error .
“oracle.xdo.XDOException: oracle.xdo.XDOException: Unable to create saw session. Please verify the server connection”
Reason :
The user does not have the BI Publisher permission or role to execute the report.
Solution :
This problem may be solved by doing the following:
Step1:Navigate to the BI Publisher -> Administration -> Security Configuration and set the Security Model to “Oracle Fusion Middleware” and then restart the servers.
Step2:Navigate to BI Publisher -> Administration -> Roles and Permission.
Add the data sources to the required roles.
 completing these steps, I successfully created Datamodel