Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BI Publisher giving error for Before Report Trigger

User_4M27JMar 22 2016

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

Comments

30614
This may be a blindingly obvious question but do you have sufficient disk space on /sisdev01/dbs/ partition?
276231
Would you mind telling me how to check it?

Thanks,
Victor
30614
If it's AIX it's

cd /sisdev01
df -k .

for all volumes use

df -k


nshe_dba
df will work but you'll get more info on HP-UX with
bdf
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 19 2016
Added on Mar 22 2016
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
0 comments
292 views