Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

The report cannot be rendered because of an error, please contact the administrator.

518
Views
3
Comments

Summary

The report cannot be rendered because of an error, please contact the administrator.

Content

 
 

Error

The report cannot be rendered because of an error, please contact the administrator.
 
 
 
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.ProcessCancelledException: FOBlock was cancelled after 0 seconds

Has anyone had this error before I get it when I run a BI Publisher report? Any idea how to fix it please ?

 

Comments

  • Sandeep S. Chauhan-Oracle
    Sandeep S. Chauhan-Oracle Rank 5 - Community Champion

    Hi Ruzwan,

    Hope you are able to generate XML file (output type as XML(data)). You can check your template locally with generated XML output file. this will help you to debug further.

    you can also share your detail log here.

    -Sandeep S. Chauhan

  • Robert Fighiroae-Oracle
    Robert Fighiroae-Oracle Rank 4 - Community Specialist

    Hi Ruzwan,

    You can try increasing the Query timeout in the Data model parameters.

    Open the Data model for this report
    Click on Properties on the Left bar in the data model
    Increase the Query Timeout to 1800 (or 3600) and retest.

    If this is resolved, you should take a look in your data model and redesign it as per BI Publisher Best practices KM:

    Oracle BI Publisher Best Practices for SaaS Environments (Doc ID 2145444.1)

    Best regards,

    Robert

  • Jagdish Varadraj
    Jagdish Varadraj Rank 3 - Community Apprentice

    Hi Ruzwan

    Were you able to get rid this of issue. I am facing the same issue and looking out for a solution.

    apparently my report is running fine for few users with this error. Just few users are facing this issue.

    Thanks
    Jag