Oracle Transactional Business Intelligence

How to fix an RTF report related error in OBIEE
Summary
In OBIEE, an error was reported when opening a RTF report produced from a Data Model. What is the solution to fix the error
Content
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):
https://cloudcustomerconnect.oracle.com/posts/003870737f?commentId=397417#397417
Thank you.
Jon
Version
Oracle Business Intelligence version 11.1.1.9.0
Comments
-
Hi Jon,
Can you please try the same steps for a very simple data model?
e.g.
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.
Best regards,
Robert
-
Hello Robert,
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
Thank you.
Jon
-
Hi Jonathan,
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
Thanks