×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Problem with Enterprise Rescheduling a Historical Instance

Problem with Enterprise Rescheduling a Historical Instance

Problem with Enterprise Rescheduling a Historical Instance

(OP)
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?

RE: Problem with Enterprise Rescheduling a Historical Instance

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.

  1. I assign a new start date and click Update
  2. Click Schedule to create a new schedule.  It then takes me to the History tab where the new recurring instance is created.
  3. I delete the old recurring instance from the History

RE: Problem with Enterprise Rescheduling a Historical Instance

(OP)
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.  

RE: Problem with Enterprise Rescheduling a Historical Instance

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.

RE: Problem with Enterprise Rescheduling a Historical Instance

(OP)
Looks like restarting services fixed our issue.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close