Oracle Reports Shows Error "REP-50125: LoginException" Calling Rwwebservice Without SSO (Doc ID 2617394.1)

Last updated on MAY 09, 2023

Applies to:

Symptoms

Configured Oracle Reports security (not SSO), and created a new user  with RW_ADMINISTRATOR application role.
Everything works fine when using rwservlet, but when using rwwebservice it raises the following error:"REP-50125: An internal exception occurred: javax.security.auth.login.LoginException: Security Exception."

To reproduce the issue one can follow these steps:

1. Install and configure Oracle Reports (12.2.1.3) by following the documentation: https://docs.oracle.com/middleware/12213/formsandreports/install-fnr/installing-and-configuring-oracle-forms-and-reports1.htm#FRINS101
Out-of-the-Box reports is secured using OPSS security (rwJaznSec).

2. In Weblogic console, create a new user with a password (security realms > myrealm > Users and Groups).

3. In FMW Process Control, assign the role RW_ADMINISTRATOR to the new user created in the previous step:
 a) Navigate to "WebLogic Domain > Security > Application Roles"
 b) In "Application Stripe" select list, choose "reports" and apply the filter
 c) Select the "RW_ADMINISTRATOR" row, and click "Edit"
 d) In "Members", add the user created in step 2 user and then click "Ok"4. Document:1242614.1 - How To Secure Showjobs Web Command In A Non Secured Reports Server In Oracle Report 11g

5. Test a sample report and verify security is ok. This is an example URL: http://<HOSTNAME>:<PORT>/reports/rwservlet?report=<RDF_NAME>.rdf&destype=cache&desformat=pdf&authid=<username/[password]>&userid=<USERNAME/PASSWORD@CONNECT_STRING>
In this step, the "rwservlet" call must be successful.

6. In FMW Process Control, test rwwebservice web service following the note: Document:1306085.1 - How to Test RWWEBSERVICE in Reports 11g (auth_id should be the one created at step 4).

This is an example:

This step should raise the error:"REP-50125: An internal exception occurred: javax.security.auth.login.LoginException: Security Exception."

Changes

 A new installation of FMW Oracle Reports.

Cause

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