My Oracle Support Banner

REP-52285 Error when Running a Report with SSOCONN Parameter (Doc ID 2237695.1)

Last updated on MAY 05, 2023

Applies to:

Oracle Reports Developer - Version 11.1.2.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

Running Oracle Reports in an SSO environment with SSOCONN parameter, fails with the following error.

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

 

Running the same request using USERID parameter instead of SSOCONN parameter, fails with the following error.

REP-56071: The requested operation is unauthorized

 

The following debug information is being recorded.

rwservlet_diagnostic.log

[2017-02-08T17:15:03.716-06:00] [WLS_REPORTS] [TRACE:16] [] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [APP: reports#11.1.2] [URI: /reports/rwservlet] [SRC_CLASS: oracle.reports.utility.RWLogger] [SRC_METHOD: writeln] AuthManager:getRemoteUser SSOUser: Anonymous
[2017-02-08T17:15:03.817-06:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-50125] [oracle.reports.servlet] [tid: 12] [userId: <anonymous>] [ecid: <ECID>] [APP: reports#11.1.2] [URI: /reports/rwservlet] REP-50125 : oracle.ldap.util.NoSuchUserException: User does not exist - SIMPLE NAME = Anonymous [[
oracle.ldap.util.NoSuchUserException: User does not exist - SIMPLE NAME = Anonymous
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)

OID trace file

[2017-02-08T17:15:03.813562-06:00] [OID] [TRACE:16] [] [OIDLDAPD] [host: <Host_name>] [pid: <PID>] [tid: 11] [ecid: <ECID>] ServerWorker (REG):[[
BEGIN
ConnID:17 mesgID:6 OpID:5 OpName:search ConnIP:::ffff:<IP>:##### ConnDN:orclapplicationcommonname=<APP_NAME>,cn=reports,cn=products,cn=oraclecontext
orclinmemFilter:
Orig Filter(numAVAFilters=2):(&(objectclass=*)(cn=anonymous))
Removed Filter: (objectclass=*)
New Filter(numAVAFilters=1):(cn=anonymous)

2017-02-08T17:15:03.813604 * INFO :gslfseADoSearch BASE = cn=users, ........................... FILTER = (cn=anonymous) #REQDATTR = 1 SCOPE = 2 REQDATTRS = orclguid
TIMELIMIT = 3600 SIZELIMIT = 0 DEREF = 3
2017-02-08T17:15:03.813640 * gslsbsSearch * BASE = "cn=users,................" FILTER = "(cn=anonymous)" SCOPE = 2
2017-02-08T17:15:03.815254 * INFO:gsleswrASndResult OPtime=1762 micro sec RESULT=0 tag=101 nentries=0
END
]]

 

 

Changes

 

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


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