My Oracle Support Banner

11g: SSO Works Fine, but SSOCONN Displays HTTP-500 Exception: Java.util.NoSuchElementException (Doc ID 1489518.1)

Last updated on DECEMBER 12, 2022

Applies to:

Oracle Reports Developer - Version 11.1.1.6.0 to 11.1.2.2.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

Reports/Portal integration 11g R1
Using OID from 10g in certified configuration.

The OID instance is associated with Reports 10g R2 and 11g R1.

Everything works fine on Reports 10g R2 including SSO login and SSOCONN usage.

In Reports 11g, the reports run successfully using rwservlet when using just SSO login and the database connection string (userid parameter) in the URL. For example:

http://<HOST>:<PORT>/reports/rwservlet?report=test.rdf&destype=cache&desformat=PDF&userid=<USERID>/<PASSWORD>@<TNS_ALIAS>


Running the same report but using now SSOCONN parameter does NOT work, there is the following error:

http://<HOST>:<PORT>/reports/rwservlet?report=test.rdf&destype=cache&desformat=PDF&SSOCONN=<KEY_NAME>

http 500 internal server error

The server encountered an unexpected condition which prevented it from fulfilling the request.

 

Per rwservlet-diagnostic.log:


[2012-08-08T09:09:39.517-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 11] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] RWClient:doGet  QueryString: server=reports_server_name&report=test2.rdf&destype=cache&desformat=PDF&SSOCONN=<KEY_NAME>
...
[2012-08-08T09:09:56.595-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 11] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] AuthManager:getRemoteUser  SSOUser: null
[2012-08-08T09:09:56.736-04:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-51019] [oracle.reports.servlet] [tid: 11] [userId: <anonymous>] [ecid: <ECID>] [APP: reports#11.1.1.2.0] REP-51019 : System 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.AuthManager.getAuthId(AuthManager.java:685)
at oracle.reports.rwclient.RWClient.appendAuthId(RWClient.java:2468)
at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1919)
...
[2012-08-08T09:10:17.720-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] AuthManager:getRemoteUser  SSOUser: ORCLADMIN
[2012-08-08T09:10:17.720-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] AuthManager:getAuthId  username: ORCLADMIN
[2012-08-08T09:10:17.720-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] OIDManager:getConnString  key:MYKEY, type:, paramName:
[2012-08-08T09:10:17.783-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] LDAPManager:createDirContext  Pool size is 0. 10 more DirContext will be created.
[2012-08-08T09:10:17.923-04:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-50125] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [APP: reports#11.1.1.2.0] REP-50125 : javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]  [[
javax.naming.AuthenticationException: [LDAP: error code 49 - Invalid Credentials]
at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3067)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:3013)
...
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

]]
[2012-08-08T09:10:17.923-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] LDAPManager:createDirContext  Failed to create OiD DirContext.
[2012-08-08T09:10:17.923-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] LDAPManager:createDirContext  OiD DirContext created successfully. m_totalSize:0
[2012-08-08T09:10:17.923-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [SRC_CLASS: oracle.reports.utility.RWLogger] [APP: reports#11.1.1.2.0] [SRC_METHOD: writeln] LDAPManager:getDirContext  Found OiD DirContext, pool size is: 0, total DirContext created 0

 

As additional information, it was confirmed OID was associated at installation time. It is confirmed because SSO login is already working fine and the configuration files like rwservlet.properties and rwserver.conf already include the OID information.
 

Changes

 New FMW 11g R1 installation.

Cause

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
Symptoms
Changes
Cause
Solution
References


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