REPORT_OBJECT_STATUS TERMINATED_WITH_ERROR if Reports Server is secured - REP-50125 REP-56071
Last updated on MARCH 22, 2017
Applies to:Oracle Reports Developer - Version 126.96.36.199.0 and later
Oracle Forms - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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-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 .
The Reports Server is secured.
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