Problem with Enterprise Rescheduling a Historical Instance

trixiegrrl · Oct 2, 2008

I am having this problem, and I am wondering if there may be some setting that may have gotten turned on in Business Objects Enterprise. Where I work, we have many Scheduled Reports. What is happening, is, I am updating the Scheduled report via Crystal by doing a Save As, from Crystal to Enterprise (when doing so, I also fill in the password). In the past this process has worked with no issues. Now, it seems that if the report is already scheduled, although I am overwriting the file, it seems to be taking a historical instance and rescheduling that, rather than the new overwritten file.

When this happened to me last time, I just destroyed the original scheduled instance and created a new file, and scheduled it, but I have never had this problem before and would like to not continue having it, as it would be tedious considering the amount of scheduled reports I have. I also double checked the refresh options in Business Objects Enterprise and the Record Selection Formula was checked. Save Date with Report is unchecked, and I am not using any Parameters. Any ideas what’s going on?

kskid · Oct 2, 2008

Hmmmm.... I was not aware that it could be done automatically.

I have always gone into CMC, locate the report, click on the schedule tab and update the schedule.

[ol]
[li]I assign a new start date and click Update[/li]
[li]Click Schedule to create a new schedule. It then takes me to the History tab where the new recurring instance is created.[/li]
[li]I delete the old recurring instance from the History[/li]
[/ol]

trixiegrrl · Oct 2, 2008

That works fine for me, and will resolve the issue, but I have always done this automatically just by doing a Save As from Crystal Reports and updating the password in the CMC.

hilfy · Oct 7, 2008

When you schedule a report, BO makes a copy of it and then runs that copy and creates the next scheduled instance based on that copy. So, when you update the report template, it doesn't ever update the next scheduled instance. So, you have to reschedule it from scratch in order to get the new version (clicking on reschedule will get you a copy of the report that you're rescheduling instead of a new copy of the template.)

There is a way that you might be able to handle this in code using the SDK, although this is not supported by BO's tech support. You could get the file name associated with the scheduled instance and copy the report template over the top of it (giving the same name as the existing file.) I have written a program to do this type of thing when publishing reports - we have separate folders containing the same set of reports for each of our clients and it's time consuming to have to publish updated reports to 10 or more folders. So the program gets the file name, copies the new version over the top of it, refreshes the report in BO and sets the login info to the database for that client. However, our separate batch scheduling software schedules 99.9% of our reports, so I haven't had to deal with setting up new schedules.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

trixiegrrl · Oct 8, 2008

Looks like restarting services fixed our issue.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Problem with Enterprise Rescheduling a Historical Instance

trixiegrrl

Programmer

kskid

Technical User

trixiegrrl

Programmer

hilfy

Active member

trixiegrrl

Programmer

Similar threads

Part and Inventory Search

Sponsor