My Oracle Support Banner

REP-50125: LoginException Calling Rwwebservice Without SSO (Doc ID 2617394.1)

Last updated on APRIL 01, 2021

Applies to:

Oracle Reports Developer - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

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://<host:port>/reports/rwservlet?report=sample_report.rdf&destype=cache&desformat=pdf&authid=<username/[password]>&userid=<user/pass@database>
In this step, the "rwservlet" call must be successful.

6. In FMW Process Control, test rwwebservice web service following the note: DOC ID:1306085.1 - How to Test RWWEBSERVICE in Reports 11g (auth_id should be the one created at step 4). This is an example:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
 <soap:Body>
   <ns1:runJob xmlns:ns1="http://oracle.reports/rwclient/">
     <arg0>report=sample_report.rdf destype=cache desformat=pdf authid=username/[password] userid=user/pass@database</arg0>
     <arg1>false</arg1>
   </ns1:runJob>
 </soap:Body>
</soap:Envelope>

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

Changes

 A new installation.

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.