Skip to Content

Automation on failed Schedules in BO

Sep 20, 2017 at 09:44 AM


avatar image

Hi Techies,

Is there any way to automate failed schedules in BO using CMC or external source like macros/java scripts ?

I know there is option as "Number of retries allowed" under Recurrence for each schedule. This can be activated through CMC. But in our case there are already around 2000+ schedules so, to implement this whcich does not look practical at this point.

I also know there is a concept called as PACKAGE, where we need to copy all the scheduled reports under package and schedule it. But i think this method has some drawbacks based on few scenarios.

Are there any other methods, where instead of manually running the failed schedules, if it can be automated then HIGHLY APPRECIATED.

Note: Current environment in the Project is BO 4.2 SP4. All the schdules are running on WEBI reports.

Thanks in Advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Denis Konovalov
Sep 20, 2017 at 11:53 AM

If your schedules run fine after you re-run them means that your system is not sized properly for the load your schedules put on it.
Why else running them first time fails and second time they run ?
I think you should address "why they do not run first time" first.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Thanks for you answer Denis.

Firstly, most of the reports and schedules are created by the users. So this might be area of concern where many of those reports are scheduled on the same time and there could be some other reason where the system is overloaded.

But in our project we have 3 clusters and load balancing have been done among those servers.

I would be glad to know,how can we define system sizing under this scenario. More over I may not have the privileges to modify sizing right now, but i can suggest my management if i come to any conclusion.

Most of the errors, where the schedules are successful post re-run are as follows:

1.Object could not be scheduled within the specified time interval.

2.exception raised: com.businessobjects.sdk.core.CoreException

3.The server is busy. Please save any pending change and try again later. If the problem persists, contact your BusinessObjects administrator. (Error: ERR_WIS_30284)

4.connection error. [Communication error while reading data from FTP server: WSA10038]: [CrystalEnterprise.Ftp] An internal error occurred while calling 'openDocument' API. (Error: ERR_WIS_30270)

5.The document cannot be retrieved from the File Repository Server. (WIS 30951)

6.An internal error occurred while calling 'getPages' API. (Error: ERR_WIS_30270)

7.Unable to connect to service WebiPlugin.WebiSession from server via CMS osca:iiop://;SI_SESSIONID=6045732JGXso5W7GguU9Tn8Z2ABLux,SI_TENANT_ID=0,SI_SERVER_LOGON_SESSION=1 (FWM 01006)

If the cause and resolution to prevent the above errors in future should be an answer to my issue.

In few scenarios, when the BO services are down, schedules fail in large numbers. So automation could be useful in such cases.

So, I was thinking if automation using macros/java scripts are possible in BO and how ?


Definitely sounds like sizing issue. See

You can definitely write some SDK code to search for failed instances and re-schedule them. But you'll be not solving the issue.
With BI4.2 Sp4 you can set the processing groups per folder and per user group, so you can segment the load and make sure more taxing reports run on most powerful nodes.
You need to monitor who does most schedules and who runs most taxing ones and devise strategy on how to address their needs without breaking the system.


Thanks Denis for your advise.

I shall go through the link.