REP-52285 Error When Using SSOCONN Parameter (Doc ID 2187158.1)

Last updated on APRIL 26, 2023

Applies to:

Oracle Reports Developer - Version 11.1.1.2.0 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run a report passing the SSOCONN parameter the following error occurs.

REP-52285: The user name or subscriber name cannot be found in Logon Server cookie.

If USERID parameter is passed to the report request then it works.

The following is recorded in rwservlet_diagnostic.log file at the moment of the issue.

[2016-09-20T08:09:02.430-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 62] [userId: <anonymous>] [ecid: <ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.reports.utility.RWLogger] [SRC_METHOD: writeln] LDAPManager:getDirContext Found OiD DirContext, pool size is: 9, total DirContext created 10
[2016-09-20T08:09:02.469-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 62] [userId: <anonymous>] [ecid: <ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.reports.utility.RWLogger] [SRC_METHOD: writeln] AuthManager:getRemoteUser SSOUser: <userID>
[2016-09-20T08:09:02.761-04:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-50125] [oracle.reports.servlet] [tid: 62] [userId: <anonymous>] [<ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-50125 : oracle.ldap.util.NoSuchUserException: User does not exist - SIMPLE NAME = <userID> [[
oracle.ldap.util.NoSuchUserException: User does not exist - SIMPLE NAME = <userID>
at oracle.ldap.util.User.resolve(User.java:1034)
at oracle.ldap.util.User.locateSubscriber(User.java:1180)
at oracle.reports.rwclient.OIDManager.getSubscriberDN(OIDManager.java:421)
.
.
[2016-09-20T08:09:02.775-04:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 62] [userId: <anonymous>] [<ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.reports.utility.RWLogger] [SRC_METHOD: writeln] LDAPManager:releaseDirContext after release: Pool size is 9
[2016-09-20T08:09:02.776-04:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-52285] [oracle.reports.servlet] [tid: 62] [userId: <anonymous>] [<ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-52285 : The user name or subscriber name cannot be found in Logon Server cookie. [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:1016)
at oracle.reports.rwclient.OIDManager.getSubscriberDN(OIDManager.java:428)
at oracle.reports.rwclient.OIDManager.access$400(OIDManager.java:44)

OID traces showing the following information.

[2016-09-20T08:09:02.430-04:00] [OID] [TRACE:16] [] [OIDLDAPD] [host: ORCL-FUSION-DEV] [pid: ####] [tid: 8] [<ECID>] ServerWorker (REG):[[
BEGIN
ConnID:#### mesgID:# OpID:# OpName:search ConnIP:<IP> ConnDN:orclapplicationcommonname=wls_reports_reportsapp_1,cn=reports,cn=products,cn=oraclecontext
orclinmemFilter:
Orig Filter(numAVAFilters=2):(&(objectclass=*)(uid=<userID>))
Removed Filter: (objectclass=*)
New Filter(numAVAFilters=1):(uid=<userID>)

2016-09-20T08:09:02.775-04:00* INFO :gslfseADoSearch BASE = cn=users, dc=<DC_value>,dc=<DC_value> FILTER = (uid=<userID>) #REQDATTR = 1 SCOPE = 2 REQDATTRS = orclguid
TIMELIMIT = 3600 SIZELIMIT = 0 DEREF = 3
2016-09-22T14:01:34.707124 * gslsbsSearch * BASE = "cn=users,dc=<DC_value>,dc=<DC_value>" FILTER = "(uid=<userID>)" SCOPE = 2
2016-09-22T14:01:34.708128 * INFO:gsleswrASndResult OPtime=401 micro sec RESULT=0 tag=101 nentries=0
END

Users in OID are defined with the following syntax:
cn=<userID>
uid=<email_address>

*** CN and UID values are different