Reports Server Fails With Rep-51002 After Entering Password on Db User Authentication Screen

(Doc ID 1388387.1)

Last updated on OCTOBER 30, 2017

Applies to:

Oracle Reports Developer - Version 11.1.1.4.0 to 12.2.1.0.0 [Release 11g to 12c]
Information in this document applies to any platform.

Symptoms

The Reports Server returns the following error after entering password on the Database User Authentication screen:

REP-51002: Bind to Reports Server rep_wls_reports_hostname_home failed.


This may happen with the in-process and/or standalone Reports Server.

Steps to Reproduce:

The issue can be reproduced at will when you omit userid password in URL, for example:

http://<hostname:port>/reports/rwservlet?report=mytest.rdf&userid=myuser@db&destype=cache&desformat=pdf




After clicking on "Submit" button, you get the reported REP-51002 error.

Here are samples of the error messages that may be shown in the various log files:

rwEng-0_diagnostic.log

[2011-12-16T16:42:35.281-05:00] [reports] [ERROR] [] [oracle.reports.engine] [pid: 28128] [tid: 10] [ecid: 004h3leO3LP7MAnpokO5yY0006gm00000o,0:1:0x5f5e104:100000001] [EngineName: rwEng-0] [URI: /reports/rwservlet] C Engine Job ID = 4 ERR REP-1202: An Oracle logon was not specified.
[2011-12-16T16:42:35.282-05:00] [reports] [ERROR] [] [oracle.reports.engine] [pid: 28128] [tid: 10] [ecid: 004h3leO3LP7MAnpokO5yY0006gm00000o,0:1:0x5f5e104:100000001] [EngineName: rwEng-0] [URI: /reports/rwservlet] rwfdt:rwfdtprint Job ID = 4 ERR Error occurred sending Job output to cache
[2011-12-16T16:42:35.286-05:00] [reports] [INCIDENT_ERROR] [REP-1202] [oracle.reports.engine] [pid: 28128] [tid: 10] [ecid: 004h3leO3LP7MAnpokO5yY0006gm00000o,0:1:0x5f5e104:100000001] [EngineName: rwEng-0] [URI: /reports/rwservlet] REP-1202 : An Oracle logon was not specified.[[

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.engine.EngineImpl.run(EngineImpl.java:553)
at oracle.reports.engine.EngineClassPOA._invoke(EngineClassPOA.java:104)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1682)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:1540)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleInput(CorbaMessageMediatorImpl.java:922)
at com.sun.corba.se.impl.protocol.giopmsgheaders.RequestMessage_1_2.callback(RequestMessage_1_2.java:181)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequest(CorbaMessageMediatorImpl.java:694)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.dispatch(SocketOrChannelConnectionImpl.java:451)
at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.doWork(SocketOrChannelConnectionImpl.java:1213)
at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.performWork(ThreadPoolImpl.java:471)
at com.sun.corba.se.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:500)

]]



rwservlet_diagnostic.log

[2011-12-16T16:40:58.763-05:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-51018] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: 004h3losAT07MAnpokO5yY0006gm00000z,0:1] [APP: reports#11.1.1.2.0] [URI: /reports/rwservlet] REP-51018 : Database user authentication is missing. [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:1053)
at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1975)
at oracle.reports.rwclient.RWClient.doGet(RWClient.java:513)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)

]]
[2011-12-16T16:42:35.288-05:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-1202] [oracle.reports.servlet] [tid: 11] [userId: <anonymous>] [ecid: 004h3lubwgd7MAnpokO5yY0006gm00001V,0:1] [APP: reports#11.1.1.2.0] [URI: /reports/rwservlet] REP-1202 : An Oracle logon was not specified.[[

oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.RWExceptionHelper.read(RWExceptionHelper.java:67)
at oracle.reports.server._ConnectionStub.runJob(_ConnectionStub.java:587)
at oracle.reports.client.ReportRunner.dispatchReport(ReportRunner.java:320)
at oracle.reports.rwclient.RWReportRunner.dispatchReport(RWReportRunner.java:86)
at oracle.reports.rwclient.RWClient.runReport(RWClient.java:2142)
at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1990)
at oracle.reports.rwclient.RWClient.doGet(RWClient.java:513)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)

]]



WLS_REPORTS-diagnostic.log


[2011-12-16T16:41:07.692-05:00] [WLS_REPORTS] [WARNING] [] [javax.enterprise.resource.corba._DEFAULT_.rpc.protocol] [tid: [ACTIVE].ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 004h3lpQERp7MAnpokO5yY0006gm000014,0:1] [APP: reports#11.1.1.2.0] [URI: /reports/rwservlet/setauth] "IOP00010202: (UNKNOWN) Unknown user exception thrown by the server"[[
org.omg.CORBA.UNKNOWN: vmcid: SUN minor code: 202 completed: Maybe
at com.sun.corba.se.impl.logging.ORBUtilSystemException.runtimeexception(ORBUtilSystemException.java:8869)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.convertThrowableToSystemException(CorbaMessageMediatorImpl.java:1920)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleThrowableDuringServerDispatch(CorbaMessageMediatorImpl.java:1870)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleThrowableDuringServerDispatch(CorbaMessageMediatorImpl.java:1823)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:258)
at com.sun.corba.se.impl.protocol.CorbaMessageMediatorImpl.handleRequestRequest(CorbaMessageMediatorImpl.java:1682)
at com.sun.corba.se.impl.protocol.SharedCDRClientRequestDispatcherImpl.marshalingComplete(SharedCDRClientRequestDispatcherImpl.java:155)
at com.sun.corba.se.impl.protocol.CorbaClientDelegateImpl.invoke(CorbaClientDelegateImpl.java:129)
at org.omg.CORBA.portable.ObjectImpl._invoke(ObjectImpl.java:457)
at oracle.reports.server._ServerClassStub.authenticate(_ServerClassStub.java:105)
at oracle.reports.client.ServerManager.authenticateDBUser(ServerManager.java:466)
at oracle.reports.rwclient.ServletCmdMgr.handleCmdSetauth(ServletCmdMgr.java:1494)
at oracle.reports.rwclient.ServletCmdMgr.handleWebCommand(ServletCmdMgr.java:238)
at oracle.reports.rwclient.RWClient.handleWebCommand(RWClient.java:1306)
at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1770)
at oracle.reports.rwclient.RWClient.doPost(RWClient.java:784)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:207)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:176)
Caused by: java.lang.UnsatisfiedLinkError: oracle/jdbc/driver/T2CConnection.getLibraryVersionNumber()I
at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3537)
at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3532)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:266)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:162)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at oracle.reports.utility.DBConnection.connectByOCIJDBC(DBConnection.java:149)
at oracle.reports.utility.DBConnection.connect(DBConnection.java:129)
at oracle.reports.server.SecurityHelper.authenticate(SecurityHelper.java:459)
at oracle.reports.server.ServerImpl.authenticate(ServerImpl.java:213)
at oracle.reports.server.ServerClassPOA._invoke(ServerClassPOA.java:107)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatchToServant(CorbaServerRequestDispatcherImpl.java:637)
at com.sun.corba.se.impl.protocol.CorbaServerRequestDispatcherImpl.dispatch(CorbaServerRequestDispatcherImpl.java:189)
... 36 more

Changes

This is a new 11.1.1.4 or higher version installation.

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