"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 JUNE 29, 2016

Applies to:

Oracle Reports Developer - Version 10.1.2.0.2 to 10.1.2.3 [Release Oracle10g to 10gr2]
Oracle Forms - Version 10.1.2.0.2 to 10.1.2.3.0 [Release Oracle10g to 10.1.2.3]
Information in this document applies to any platform.
***Checked for relevance on 18/Apr/2013***

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: SSOTEST
[2011/5/3 1:30:25:102] Debug 50103 (AuthManager:getAuthId): username: SSOTEST
[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: P_CTRR_ID=12001&DT_FROM=04/01/2010&hidden_run_parameters=server=rep_server&report=report.rdf&destype=CACHE&desformat=pdf&userid=¶mform=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.

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