Using SSOCONN Parameter to Run Report Requests Fail Redirecting to a Wrong URL (Doc ID 2115469.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Reports Developer - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

Running report requests with SSOCONN parameter fails and the URL gets redirected to a wrong URL:

Examples

1- https://hostname/reports/rwservlet?report=report.rep&destype=cache&desformat=pdf&SSOCONN=reportsmenu/OracleDB/userid
or
2- https://hostname/reports/rwservlet?report=report.rep&destype=cache&desformat=pdf&SSOCONN=reportsmenu

 

Redirect --> https://hostname/reports/rwservlet?urlid=31



Passing the database credentials in USERID parameter works fine.

rwservlet_diagnostic.log is recording the following messages:

[2016-03-09T13:40:15.515-05:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-52280] [oracle.reports.servlet] [tid: 13] [userId: <anonymous>] [ecid: 00iZ3XFu^5E1RdrN4IECUE0001ek0000YS,0:1:0x5f5e1f6] [APP: reports#11.1.2] [URI: /reports/rwservlet] REP-52280 : An Oracle OID generic error occurred. [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:1053)
at oracle.reports.rwclient.OIDManager.getConnString(OIDManager.java:160)
at oracle.reports.rwclient.AuthManager.handleSSOConn(AuthManager.java:446)
at oracle.reports.rwclient.AuthManager.getUserId(AuthManager.java:413)
at oracle.reports.rwclient.RWClient.appendUserid(RWClient.java:2491)
.
.
[2016-03-09T13:40:15.624-05:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-50125] [oracle.reports.servlet] [tid: 13] [userId: <anonymous>] [ecid: 00iZ3XFur7w1RdrN4IECUE0001ek0000YU,0:1:0x5f5e1f8] [APP: reports#11.1.2] [URI: /reports/rwservlet] REP-50125 : oracle.ldap.util.UtilException: NamingException encountered when resolving subscriber - DN =dc=example,dc=com [[
oracle.ldap.util.UtilException: NamingException encountered when resolving subscriber - DN =dc=example,dc=com
at oracle.ldap.util.Subscriber.resolve(Subscriber.java:677)
at oracle.ldap.util.Subscriber.<init>(Subscriber.java:372)
at oracle.ldap.util.Subscriber.<init>(Subscriber.java:304)
at oracle.reports.rwclient.OIDManager$ResourceType.getResourceTypeAttributes(OIDManager.java:597)
at oracle.reports.rwclient.OIDManager$ResourceType.access$000(OIDManager.java:538)
at oracle.reports.rwclient.OIDManager.getConnString(OIDManager.java:135)
at oracle.reports.rwclient.AuthManager.handleSSOConn(AuthManager.java:446)

 

Changes

 New Reports setup with OAM

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