java.lang.SecurityException when XMLP is not enabled on the same Siebel Server as AOM when running Reports BS in Multi-Server environment (Doc ID 2165793.1)

Last updated on SEPTEMBER 01, 2023

Applies to:

Symptoms

On : 8.1.1.14.15 [IP2014] version, Siebel EAI

When user executes Reports BS, the error below occurs:

ERROR
-----------------------
SBL-EAI-04308: Operation 'runReport' of Web Service 'http://xmlns.oracle.com/oxp/service/v11/PublicReportService.PublicReportServiceService' at port 'PublicReportService_v11' failed with the following explanation: "oracle.apps.xdo.webservice.exception.AccessDeniedException: java.lang.SecurityException: Failed to log into BI Publisher: invalid username or password.".

OR

SBL-EAI-04308: Operation 'runReport' of Web Service 'http://xmlns.oracle.com/oxp/service/v11/PublicReportService.PublicReportServiceService' at port 'PublicReportService_v11' failed with the following explanation: "oracle.xdo.webservice.exception.AccessDeniedException: PublicReportService::initSession Failure: due to empty userID".

STEPS
-----------------------
The issue can be reproduced at will with the following steps only using Multi-Server environment:
1. Setup BI Publisher to use 'BI Publisher' security model.
2. Setup Siebel to integrate with BI Publisher using XMLP component authentication.
3. Make sure that AOM and XMLP components are enabled on different Siebel Servers.
4. To run Reports BS, use Doc ID 1425724.1 input files. Navigate to Administration - Business Services > Simulator and load the input files to execute any report. It fails with the error above.

ENVIRONMENT DETAILS
-----------------------

NOTES
-----------------------
a. The issue was only reproduced with Reports BS. When user runs report through Reports icon, the request is passed to XMLP component on the any Siebel Server where XMLP is enabled. Issue happens when Reports BS is executed through Simulator or custom Workflow.
b. empty userID error occurs because Reports BS gets the BIPServerLogin and BIPServerPassword parameters from XMLP component to establish connection to BIP Server because of 'BI Publisher' security model and it is only capable to get the parameters from the same server.

Changes

Issue started after setting up Multi-Server environment and have XMLP and AOM components running on different servers.

Cause

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