Troubleshooting Flexible Aggregate Reports
Issue | Cause | Resolution |
---|---|---|
BIP Icons are not displayed against corresponding BIP specific fields/tabs in the Oracle Argus Safety UI - Periodic Reporting Configuration |
Oracle Business Intelligence Publisher Periodic reports are not enabled in the Argus Console |
In the Oracle Argus Safety Console, navigate to System Configuration > Enabled Modules. Make sure that BIP Aggregate Reporting is checked |
BIP Icons are not displayed against corresponding BIP specific fields/tabs in the Oracle Argus Safety UI - Periodic Reporting Configuration |
The page level cache is not refreshed |
Restart the IIS server |
Oracle Business Intelligence Publisher Periodic report does not Execute from Oracle Argus Safety UI and the status of the reports remains in "Pending" status in the Report Generation Screen |
The BIP Common user ID or password entered for the BIP Aggregate Reporting Common Profile Switch is wrong or empty |
Make sure there is a user ID present in the BIP Reporting common profile switches. Verify that the BIP Common User and Password present in this switch can login to the BI Publisher console. Also, make sure that the user ID has complete access to all BIP Periodic reports. |
Oracle Business Intelligence Publisher Periodic report does not Execute from Oracle Argus Safety UI and the status of the reports remains in "Pending" status in the Report Generation Screen |
The Report path in the REPORT_TEMPLATE is empty or has an incorrect path |
The Report path present in the code list REPORT_TEMPLATE must have a proper value. The value can be verified by comparing it against the actual report path in the BIP Publisher catalogs. In Linux/Unix the report path is case sensitive. |
Oracle Business Intelligence Publisher Periodic report does not Execute from Oracle Argus Safety UI and the status of the reports remains in "Pending" status in the Report Generation Screen |
The endpoint address present in the AGProc.config file is incorrect |
Confirm the following:
|
Oracle Business Intelligence Publisher Periodic report does not Execute from Argus UI and the status of the reports remains in "Pending" status in the Report Generation Screen |
The Oracle Data Access version present in the AGProc.config file is incorrect |
Refer to the Oracle Argus Safety Installation Guide and make sure the correct entry is provided. |
Oracle Business Intelligence Publisher Periodic report does not Execute from Argus UI and the status of the reports remains in "Pending" status in the Report Generation Screen |
Missing Argus UI user in the Oracle Business Intelligence Publisher |
Make sure that the Oracle Argus Safety UI user exists and is allowed to login and run the required reports from BI Publisher console |
The BIP Report fails with error: Report data size exceeds the maximum limit (<n> bytes). Stopped processing |
The report exceeds the maximum data size specified for report generation |
Log in to Oracle Business Intelligence
Publisher -
Update the parameters Maximum Report Data Size for online reports and Maximum report data size for offline (scheduled) reports as needed.
Update the Maximum data size limit for data generation value as required. Note that the value needs to be in bytes. |
Database connection errors |
The Oracle Business Intelligence Publisher report cannot utilize the JDBC provided |
Make sure the JDBC connection name is in lowercase (asbip) |
Oracle Business Intelligence Publisher Scheduled Report Output does not show up in the Argus application |
Invalid or missing Report Output Pusher job |
Make sure that the Report Output Pusher is running without any failure |
Oracle Business Intelligence Publisher Scheduled Report Output does not show up in the Argus application |
Invalid database link AS_TO_BIPREP |
Verify whether the database link AS_TO_BIPREP is valid and pointing to the proper DEV_BIPLATFORM metadata repository database |
Oracle Business Intelligence Publisher Scheduled Report Output does not show up in the Argus application |
Unscheduled Reports |
The reports are not scheduled in the BI Publisher, but being run (using the "open" option) |
Error, ORA-01427: single-row sub-query returns more than one rowORA-06512: at "<bip_owner>.PKG_AGG_RPT" for p_updclinicaldrugrole procedure |
Study configuration is having duplicate attributes |
Check the study configuration and ensure that it does not have any duplicates |
Error, ORA-20005: object statistics are locked (stattype = ALL) >> Error while copying case series - 1, USER NAME - <logged in user>. |
Required tables are locked. |
exec dbms_stats.unlock_table_stats('BIP_OWNER', 'GTT_RPT_AGG_UNIQ_CASES'); |
UserID: AG_batch_periodic_reports, Login to BIP Server failed Exception DetailsMessage: The request channel timed out while waiting for a reply after 00:00:59.5468739. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout. |
Timeout occurs while calling the BIP server |
Add/Modify the following in C:\Program Files (x86)\Oracle\Argus\ArgusWeb\Bin\Argusvr2.config
|
UserID: <AgUserID>, Report Scheduling to BIP Server failed Exception DetailsMessage:
|
Argusvr2.config entries are wrong |
Verify the <endpoint address> elements are correctly configured, and set it right. (For more details, refer to the Configure AG Service and Configure Web Service (Expedited Reports only) sections in the Oracle Argus Safety Installation Guide.) http://<host>:<port>/xmlpserver/services/v2/SecurityService where the name attribute is set to SecurityService
|
Parent topic: Troubleshooting