java.lang.SecurityException when XMLP is not enabled on the same Siebel Server as AOM when running Reports BS in Multi-Server environment
Last updated on NOVEMBER 28, 2017
Applies to:Siebel CRM - Version 220.127.116.11.15 [IP2014] and later
Information in this document applies to any platform.
On : 18.104.22.168.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.
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