My Oracle Support Banner

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

Last updated on MAY 31, 2021

Applies to:

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


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




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

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