How to fix an RTF report related error in OBIEE

Jonathan Chan gmg

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

Robert Fighiroae-Oracle

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

Jonathan Chan gmg

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

Arghyo Banerjee -Oracle

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