BI Publisher giving error for Before Report Trigger — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

BI Publisher giving error for Before Report Trigger

Question
31
Views
0
Comments
User_4M27J
User_4M27J Rank 2 - Community Beginner
edited Aug 13, 2024 3:33PM in Oracle Analytics Cloud and Server

Hi All,

Can any one please help me on this.

I have developed a report which triggers a package and populate data into a custom table, and that custom table is query on some conditions in the data sets in the report.

While scheduling the report, its running and giving an error.

Actually the before report trigger  is populating data in to the custom table as I can see clearly last update date in the table.

But after triggering the before report, whole report is  getting failed and giving following error message and status as Problem:


Output failed.
[INSTANCE_ID=lnappu008b.1439469102695] [OUTPUT_ID=3369] oracle.xdo.XDOException: java.lang.reflect.InvocationTargetException
And also, when I disabled the trigger and try running the report and then it completes success as data is already populated in the custom table, but we need before report trigger.
Is there any settings i need to make.
Please suggest.
Thanks,
phanindra