0 Replies Latest reply on Mar 22, 2016 10:36 AM by 2895448

    BI Publisher giving error for Before Report Trigger

    2895448

      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