Automatically rescheduling failed reports

[Former Member]

Hi ALL

BO 4.1 SP7

Is there a way to automatically reschedule the failed reports.

It just need to run once since the recurring scheduled was created already.

Any solution will help

Also is there a query to get  top 10 most run Business Objects Reports?

Thanks

JS

[DellSC · Accepted solution]

There is no way to "automatically" do this from within the system.  There are two options I can think of:

1.  Manual:  Go into the Instance Manager in the CMC.  Filter on "Failed" reports.  Reschedule failed each report manually.

2.  Write code using either the Java or .NET SDK that will look for failed instances and re-run them.

-Dell

[Former Member · Accepted solution]

Thanks Dell 

I know the option 1,

option 2 will be very helpfull, will implement that

I need a  query to get  top 10 most run Business Objects Reports from a folder

any help

Thanks

[DellSC · Accepted solution]

That you'll have to go to the Auditing database for.  Looking at two possible definitions of "run":

In both cases, look for ADS_EVENT_TYPE_STR.Language = 'EN'

- Schedule only:  look for ADS_EVENT_TYPE_STR.Event_Type_Name = 'Run'

- View on demand, modify and schedule: look for ADS_EVENT_TYPE_STR.Event_Type_Name = "Refresh"

I usually turn on the "Folder Path Details" for auditing if there's any possibility that there will be multiple reports with the same name (for example, if users copy reports to their Favorites).  I'll then group the data by ADS_EVENT.Object_Folder_Path and ADS_EVENT.Object_Name to determine which reports are being used.  There's also a User_Name field in ADS_EVENT that you can use to determine who is using the reports.

-Dell

Edit:  See here for a good audit universe and sample reports: 

Message was edited by: Dell Stinnett-Christy

[DellSC · Accepted solution]

You can find more info about the SDKs here:

Both spaces have links to sample code.  If you have any questions about using the SDK, ask them in the appropriate space.

-Dell

[Former Member]

This message was moderated.

[amitrathi239]

one option you can try to set the "Number of retries allowed" & "retrieval interval in seconds" option.If job fail and you will set these two settings then based on the setting automatic schedule job will try  after set of retrieval intervals.

If within the time your BO server will up  then recurring job will be successful.

[Former Member]

Thanks Amit

where do l change the CMS retry parameter to 4 retries during a failure?

[DellSC]

As shown in the image Amit posted, this is a parameter in the Recurrence section of the schedule itself.

-Dell

[Former Member]

I know you can do it for individual report, where to l change the retry setting for failed reports to 4

for all reports.

[amitrathi239]

This is you have to set at the time of BO report scheduling from CMC.or you can update the details in the recurring job.

right click on the report->History->Select recurring Instance->reschedule->under the recurrence you can set this.Also when you are changing the recurring instance->under the replace section->select option "Replace existing schedule".

[Former Member]

Amit

this detail is not applicable

right click on the report->History->Select recurring Instance->reschedule->under the recurrence you can set this.Also when you are changing the recurring instance->under the replace section->select option "Replace existing schedule".

From BO CMC cant see  your above navigation

can not locate Replace existing schedule or reschedule->under the recurrence

see my screenhot sap bo 4.1 sp7

[amitrathi239]

have you selected the recurring instance and then reschedule?

[Former Member]

I want to reschedule the failed reports

[amitrathi239]

ok.tell me your report is running daily or you are scheduling for only.

Number of retrival option you need to select first time scheduling or if your report is running daily then you have to update in the existing recurring job only

[amitrathi239]

follow these steps if you have recurring job.

[Former Member]

This message was moderated.