Skip to Main Content

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 bursting and scheduler queries

721819Sep 10 2009
Hi,
I am new to BIP and we use BI Publisher Enterprise edition.

Following are my problems:

1. I have scheduled the reports and they are running fine. I have provided the option for storing the output. I want to know where in the file system are the reports stored. I can definitely view it from the BIP, but wat if the storage is full. Basically the path where the scheduled reports are stored and the format in which they are stored.

2. I am trying to burst my reports. here, when I enable bursting in the report, the notifications generated by the scheduler gets problems. Normally , The scheduler is to send a mail notification with a link to the BI Report. here is the example
----------------------------------------
Oracle BI Publisher Notification:

Job Name: GPF-CDCG
Job Executed Date: Tuesday, September 1, 2009 2:00 AM GMT Job was successfully processed.
Document URL: http://labmwap4.gia:7777/xmlpserver/servlet/scheduler?mode=dl&dl_target=doc&outputid=5893&content_type=application/zip&report_url=/UATCB/GPF-CDCG/GPF-CDCG.xdo
-----------------------------------------------
And this happens too when I dont enable bursting. But if I enable bursting, in the report, the notifications do not show the Document URL. It does giv the rest of the mail, but not the URL.

Why is it so and what should be done to make it work properly.

3. I have one report called GPF-Polish in folder :/UAT/2. I have scheduled it on weekly basis. Now I have the same report with same name in other folder say UAT:/UAT/training/2. its like I have copied the report in new folder. Now I schedule the first report (:/UAT/2) to run immediately or daily. This run fails.
It gives below exception :

Line:-----
Status Failed
System Message oracle.apps.xdo.servlet.scheduler.ProcessingException: oracle.apps.xdo.servlet.CreateException: Report definition not found:/UAT/2/GPF-Polish/GPF-Polish.xdo
at oracle.apps.xdo.servlet.scheduler.XDOJob.generateReport(XDOJob.java:896)
at oracle.apps.xdo.servlet.scheduler.XDOJob.execute(XDOJob.java:361)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: oracle.apps.xdo.servlet.CreateException: Report definition not found:/UAT/2/GPF-Polish/GPF-Polish.xdo
at oracle.apps.xdo.servlet.ReportException.fillInStackTrace(ReportException.java:124)
at java.lang.Throwable.<init>(Throwable.java:196)
at java.lang.Exception.<init>(Exception.java:41)
at oracle.apps.xdo.servlet.ReportException.<init>(ReportException.java:36)
at oracle.apps.xdo.servlet.CreateException.<init>(CreateException.java:18)
at oracle.apps.xdo.servlet.ReportRepository.getReport(ReportRepository.java:69)
at oracle.apps.xdo.servlet.scheduler.XDOJob.generateReport(XDOJob.java:884)


Line:-----
although the report is present.

Please let me know what should be done for this.

4. Is there any provision of sending the Document URL in the Bursted mails instead of attachment?

Please help me out.

Thanks,
Saurabh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2009
Added on Sep 10 2009
0 comments
1,770 views