1,061 total views
In this article we will look into resolving the time out error for BI Publisher reports.
Want to learn Fusion Technical tools? Checkout this article
The default limit set at BI server level for time out is 500 sec.
However we can override this time out limit setting for individual reports at the data model level.
Open the Data Model from BI Catalog.
Click on Properties tab:
Set the Query Time out to 1000000 – It will increase the time out for this specific report only.
set Enable SQL Pruning to “On” – SQL pruning enhances performance by fetching only the columns that are used in the report layout/template. Columns that are defined in the query but are not used in the report are not fetched
Once these changes are done, save the data model and run it again.
Now the issue should be resolved.
Tip: The settings at the Data Model will not have any impact on the other reports. For other reports the server level setting of 500 sec will work. Override will apply only to the specific Data Model.
Latest posts by Sricharan Monigari (see all)
- Renaming HCM Extracts is a possibility from 20D - November 24, 2020
- Sangam20 – Oracle Users Group Conference - November 23, 2020
- Passing Parameter values from Flow Instance to HDL Transformation Formula - November 23, 2020
- Solve manual FTP server update issue for HCM Extracts post every P2T refresh - November 16, 2020