Oracle Transactional Business Intelligence Idea Lab

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

Need BI Reports runtime error details

21
Views
1
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):Fujitsu


Description (Required):In case of bulk report failures we need a way to capture the report errors details from db table instead of opening and viewing log for each and every report.


Use Case and Business Need (Required):Need a report to view the BI report errors


Enhancement Request / Service Request: Enhancement Request

1
1 votes

Submitted · Last Updated

Comments

  • Jagadeeswara
    Jagadeeswara Rank 2 - Community Beginner

    We are expecting any report runtime errors to be inserted into any table.

    Examples:

    1. Single row subquery returns more than one row.

    2. [nQSError: 17012] Bulk fetch failed. [nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation at OCI call OCIStmtFetch.


    This is required to see the report error details in a custom report as a part of monitoring.

    Please find attached data model catalog for generating the error status runtime reports. But we are expecting the error reason from the DB tables. 


    Thanks,

    Jagadeeswara