My Oracle Support Banner

"REP-51018: Need database user authentication" When Leaving Reports Parameter Form Inactive For Some Time. Reports Forms Integration (Doc ID 1320131.1)

Last updated on APRIL 20, 2023

Applies to:

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

Symptoms

When calling Oracle Reports from Oracle Forms and using Reports Parameter Form (paramform=yes), if the Reports Parameter Form is left inactive for some time, in this particular case it was 5 minutes, and then trying to submit the values from the Reports Parameter Form the following error is displayed.


REP-51018: Need database user authentication


If the inactivity time was less than 5 minutes then the report request works fine.

Reports Servlet trace file shows the following information when the issue happens.

rwservlet.trc


[2011/5/3 1:30:25:102] Debug 50103 (AuthManager:getRemoteUser): SSOUser: <SSO_USER>
[2011/5/3 1:30:25:102] Debug 50103 (AuthManager:getAuthId): username: <SSO_USER>
[2011/5/3 1:30:25:102] Debug 50103 (AuthManager:getSessionUser): userType 2
[2011/5/3 1:30:25:103] Debug 50103 (authManager:isUserExpired): user expired at Tue May 03 13:24:10 EDT 2011
[2011/5/3 1:30:25:106] Debug 50103 (RWClient:processRequest, exception occured, ): authmask: 8
[2011/5/3 1:30:25:106] Debug 50103 (RWClient:getNextPage): nextpage: <PARAM>=<VALUE>&<PARAM2>=<VALUE2>&hidden_run_parameters=server=<REPSERVER>&report=<REPORT>.rdf&destype=CACHE&desformat=pdf&userid=<USER/PASSWORD>&Paramform=yes
[2011/5/3 1:30:25:107] Exception 51018 (): Need database user authentication
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:758)
at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1510)


If the report request is tested outside from Oracle Forms then the issue does not happen.

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.