My Oracle Support Banner

Reports From Portal Fails With REP-50171 After Setting securityUserid In 10.1.2.0.2 (Doc ID 342768.1)

Last updated on MAY 31, 2021

Applies to:

Oracle Reports Developer - Version 10.1.2.0.2 to 10.1.2.2 [Release Oracle10g to 10gr2]
Information in this document applies to any platform.

Symptoms


When "securityUserid" parameter is set in reports configuration file, the connection to the portal database can not be established, and the following errors are seen in the trace files of report server and rwservlet when tracing is enabled :

rwserver.trc contains the following errors :

 

 

 

The key point to identify this issue is the "@null" addition to the tns connect string which is visible in trace file as follow :

Debug 50103 (DBConnection:connectByOCIJDBC): username:portal, tnsname: <mydatabase>.<domain_name>com@null

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
References

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