Oracle Transactional Business Intelligence
How to fix an RTF report related error in OBIEE
In OBIEE, an error was reported when opening a RTF report produced from a Data Model. What is the solution to fix the error
Hello Oracle Team,
In OBIEE, when I ran a RTF layout built on a Data Model, the follow error was prompted (please also see attached screenshot for the interface where the error was prompted):
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.ProcessCancelledException: FOBlock was cancelled after 0 seconds
What is the solution to fix this error?
Robert Fighiroae for offering this efficient solution):
Oracle Business Intelligence version 18.104.22.168.0
Can you please try the same steps for a very simple data model?
SELECT 1 AS COL_A , 2 AS COL_B FROM DUAL
I want to isolate the case and see if the issue is with the RTF generation or with your particular data model.
Please see below the following outcomes:
1) Both the data model and RTF report ran successfully when the following code was executed.
Select ITEM_NUMBER AS COL_A, INVENTORY_ITEM_ID AS COL_B from EGP_SYSTEM_ITEMS_B
2) The following error was prompted when running a RTF report generated base on the data model coded "Select * from EGP_SYSTEM_ITEMS_B":
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.ProcessCancelledException: FOProcessor was cancelled after 522 seconds
Kindly look into the below points which can resolve the issue
1. Append the query with "Where rownum < 20 " in the data Model (For testing Purpose)
2. Secondly Add parameters to the Data Model so that you can run the report based on valid parameter values
3. Schedule the Report