BIP Report works some times but errors out other times

Question

Created a BIP analysis that has both a table and a graph. I have been unable to figure out what causes the error but at random times the table errors out. Below are two pictures. One is what the report should look like, the other is the error with no details.

Any help would be greatly appreciated.

Riyaz Ali-Oracle · Answer

Please provide more details about the issue. Any specific time it gets error out, Is the issue with any specific user.

Please check the below possible cause and try below options:

* Data Model Issues

If the table relies on a complex query, check whether the dataset is returning inconsistent results.

Try running the query separately in SQL Developer or another tool to see if it fails under certain conditions.

2. Memory or Performance Constraints

Large datasets can cause memory issues, leading to random failures.

Try limiting the number of rows or optimizing the query.

3. Check for Null or Unexpected Data

If the table references fields that sometimes contain null values, it may cause rendering issues.

Ensure that all required fields have valid data.

4. Template Formatting Issues

If the table is inside a conditional section, check whether the condition is failing.

Try simplifying the layout to see if the issue persists.

Mallikarjuna Kuppauru-Oracle · Answer

Hi @User_VGDUD

Welcome to Oracle Analytics Community.

What is your BIP version? are you using on Prem or cloud? Are you seeing error while running during online mode only?

I would suggest to run the same report using scheduler and enable the diag.logs to see more details about failure -