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 APRIL 21, 2020
Applies to:Siebel CRM - Version 18.104.22.168.15 [IP2014] and later
Information in this document applies to any platform.
On : 22.214.171.124.15 [IP2014] version, Siebel EAI
When user executes Reports BS, the error below occurs:
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.".
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".
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.
|AOM (HI)||X (enabled)|
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.
Issue started after setting up Multi-Server environment and have XMLP and AOM components running on different servers.
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