Re-Running the failed reports

security CMC
1

Hi,

I’m working on Business Objects Enterprise XIR2 and deploying the crystal reports XIR2 into it.

Because of a failure in the database refresh, about 900 reports failed to run, as a part of our schedule…As a result, we had to manually run all of them.

Is there a way, we can avoid these manual runs and automate the failed instances?

Thanks!
sarma

pvsbandi (BOB member since 2005-05-13)

2

Create event based scheduled report, once DB refresh is complete run file bases events and this will trigger reports. This will take care of your issue.

Regarding failed instance there is no automated way which i can think of other then SDK which keeps on checking failed reports and resubmit.

mchoure :india: (BOB member since 2003-09-04)

3

We use the APOS Instance Manager 3rd party tool to do this type of work re-running the failed reports…

MJRBIM :canada: (BOB member since 2007-03-23)

4

Yes, APOS lets you do it but if you do not want to spend the money or have restrictions within your company, then Events are your best option. BOBJ Enterprise has taken care of this for your and it is fairly straightforward to use. All you need to do is create “watcher” reports that fail unless a database load is complete. When the load is complete the watcher is successful and this in turn sets off the event which causes your real report to run. I have seen this in-use personally and really like the way it works.

Thanks,
Nizar Nadeem
www.datamanagementgroup.com
“Transforming Data into Information”

niznad (BOB member since 2010-06-22)

5

As a note, it’s also crazy easy to re-run them manually in 3.1. Go to your Instance Manager, select the whole screen worth of instances (I have my preferences set to show 100 at a time, mostly for this reason), and hit the re-run button. The Instance Manager in 3.1, while still far from perfect, is SO much better than in R2.

Lugh (BOB member since 2009-07-16)