Siebel-BI Publisher 8 Integration Error preventing access to Roles and Privileges tab (Doc ID 1059913.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Reports - Version 7.7.1 [18306] and later
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2012***

Symptoms

When attempting to access the Roles & Privileges tab within BI Publisher a "Page cannot be found" error was being returned to the browser. In addition to this errors were being reported during the Report Template upload process on the BI Publisher console as follows :

bash-3.00$ [020110_082825044][][EXCEPTION] AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.net.ConnectException: Connection refused
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:507)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.axis.components.net.DefaultSocketFactory.create(DefaultSocketFactory.java:153)
at org.apache.axis.components.net.DefaultSocketFactory.create(DefaultSocketFactory.java:120)
at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191)
at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:2443)
at org.apache.axis.client.Call.invoke(Call.java:2366)
at org.apache.axis.client.Call.invoke(Call.java:1812)
at com.siebel.apps.shared.xmlp.security.BIPSiebelSecurityWSPortStub.authenticate(BIPSiebelSecurityWSPortStub.java:298)
at oracle.apps.xdo.security.SiebelValidator.validate(SiebelValidator.java:124)
at oracle.apps.xdo.servlet.ui.admin.security.SecurityAdminUtil.getDirectoryValidator(SecurityAdminUtil.java:315)
at oracle.apps.xdo.servlet.ui.admin.security.SecurityAdminUtil.getAllRoles(SecurityAdminUtil.java:419)
at oracle.apps.xdo.servlet.ui.admin.security.RoleHomeServlet.getRoles(RoleHomeServlet.java:367)
at oracle.apps.xdo.servlet.ui.admin.security.RoleHomeServlet.renderBody(RoleHomeServlet.java:259)
at oracle.apps.xdo.servlet.ui.admin.security.RoleHomeServlet.doPost(RoleHomeServlet.java:101)
at oracle.apps.xdo.servlet.ui.admin.security.RoleHomeServlet.doGet(RoleHomeServlet.java:59)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:94)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)



In the course of investigating the matter the following was observed as there was no communication between BI Publisher and Siebel:

No detailed logging was shown in the SWSE-log file for the SADMIN User who tried to log into the "Oracle BI Publisher Enterprise Login" page which obviously led to no logging in the corresponding EAIObjMgr_enu-log file as the Web Service request specified in the Web Service Endpoint (BI Publisher Server - Admin - Security Configuration - Security Model - Siebel Security) was not passed on to the EAI Object Manager.

Note: The SADMIN User was configured on the BI Publisher Security Configuration tab.

Cause

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