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

Last updated on MARCH 07, 2016

Applies to:

Oracle Reports Developer - Version 11.1.1.6.0 and later
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=user/password@dbalias



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=mykey

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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-0000000000000028,0] [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=MYKEY
...
[2012-08-08T09:09:56.595-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 11] [userId: <anonymous>] [ecid: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-0000000000000028,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-0000000000000028,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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: 1b9b2cd6fe5e9dfd:-65eb97db:1390659bcd1:-8000-000000000000002d,0] [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

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