REPORT_OBJECT_STATUS TERMINATED_WITH_ERROR if Reports Server is secured - REP-50125 REP-56071 (Doc ID 1948154.1)

Last updated on MARCH 22, 2017

Applies to:

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

Symptoms

REPORT_OBJECT_STATUS shows TERMINATED_WITH_ERROR even though the report has successfully.
The issue only occurs when the Reports Server is secured.

In Reports 12cR2, there are no parameters as "security setting" clearly, it occurs when setting "rwJaznSec" , or "rwSec" in reports server mbean ->"rwEngXXXX"->"SecurityId".
# "rwJaznSec" is established by default.

Reports12cR2 setting location:
1. Log in to Oracle Enterprise Manager.

2. Navigate to the EM MBean browser Weblogic Domain > System MBean Browser

3. Navigate to reports server mbean

In case of Standalone server
Folder: Configuration Beans --> Folder:oracle.reports.serverconfig --> type=ReportsServer, name=rwserver-<componentName>, ReportsServer.Job

In case of Inprocess server
Folder: Application Defined MBeans --> Folder:oracle.reportsApp.config --> Server:<managedServername>,Application=reports, type=ReportsApp, name=rwserver, ReportsApp.Job


If you run report without Forms (i.e. rwclient, rwservlet), it works fine.
On the other hand, the following error is shown when the reports is called via Forms.

 REP-50125 : oracle.security.idm.ObjectNotFoundException: No User found matching the criteria
 REP-56071 : A security check failed with error message User does not exist in Id Store


The issue only occurs when the AUTHID is passed "manually" from Forms .
If AUTHID is passed automatically (SSO) , it works . 

Changes

The Reports Server is secured.

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