WebServices Fail After Configuring OBIEE 12c With OAM SSO Using OHS WebGates (Doc ID 2957733.1)

Last updated on JUNE 29, 2023

Applies to:

Symptoms

In an OBIEE 12c environment, SSO is implemented using Oracle Access Manager (OAM) 11g and Oracle HTTP Server (OHS) WebGates 12c.
For reference, see: OBIEE 12c: How To Configure OBIEE 12c with Oracle Access Manager (OAM) SSO using OHS 12c WebGates for OAM (IAM) 11g and OID 11g (IDM) (Doc ID 2097038.1)

Users access OBIEE through a Load Balancer with SSL offloaded / terminated.  For example:  LB <--SSL--> OHS <--no SSL--> OBIEE

WebServices is being tested using SoapUI as below:

1. Launch SoapUI
2. Create a project (Right-click on Projects > Create Empty Project)
3. Right-click on the new Project > Add WSDL ... In the Add WSDL window, enter the WSDL Location (For example: http(s)://.../analytics-ws/saw.dll/wsdl/v12 or http(s)://.../analytics-ws/saw.dll?wsdl), select the "Create sample request for all operations" option, and click OK
4. In the Navigator pane, go to SawSessionService > impersonate > Request 1 ... Double-click on Request 1 > Replace the question marks ("?") with the appropriate values, and click the green arrow to run / submit the request
5. In the Response pane for the Request 1, observe the outcome / results.  For example:  If authentication and impersonation were successful, see the Response XML would be like:

...
<sawsoap:impersonateResult>
<sawsoap:sessionID xsi:type="xsd:string">...</sawsoap:sessionID>
</sawsoap:impersonateResult>
...

See the outcomes / responses below when testing with different WSDL Locations:

1. With the "Direct" URL (host name and port):  The test is successful / the session is established
2. With the Load Balancer URL:  The test fails with "'JavaScript is required. Please enable JavaScript"
3. With the OHS URL: The test fails with "Bad Oracle Access Manager Request"

(Note: This issue was not encountered in the previous OBIEE 11g environment with SSO implemented using Oracle Access Manager (OAM) 11g and Oracle HTTP Server (OHS) WebGates 11g.)

Cause

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