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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Scheduleing Report Events - Problem with Event Triggers

Status
Not open for further replies.

HarryPotter1

IS-IT--Management
Jun 20, 2003
13
US
I'm trying to find out if anyone has experienced this problem.

We have about 250 reports using scheduled events to run every day. ie. If report 1 ran then run report 2. Then if report 2 ran then run report 3. The first report was scheduled to recur every day at the same time.

The Crystal Enterprise ID that had scheduled the recurrence of the reports was deleted from the server. The morning after we deleted the ID we noticed that the reports were not running. The intial report showed failed as the status with this error message: "Object failed to run due to insufficent security privledges." All other reports just were held in recurring state as if the event was never triggered for the first report.

We noticed that the user id that used to show up next to the instances that had run successfully (when the ID existed) and the recurring instances was blanked out. This lead us to believe we needed to delete all recuring instances that were set up with that id and use a current admin id on the server to set the reports to run. We did this and it still seems that the first report that is scheduled to run won't trigger the event after it has run. Even using a new ID, a newly published report, and a new Schedule event.

Has anyone had this experience?

We are running Crystal Enterprise 8.5 and use e-Portolio out of the box as our front end.

Thanks!
 
I think you are on the right track with the scheduling of your daisy chain of events.

The one thing frustrating in CE is the inability to edit scheduled reports. You must delete the recurring one, then reschedule it. I suspect there is a link in your environment that got hosed when the Report1 got deleted.



Cheers,

SurfingGecko
Home of Crystal Ease
 
I spoke to the Crystal Decisions help desk about this problem. They recommended run the most recent hot fixes on my CE server:
ce85wcswin
ce85servwin
ce85sdkwin
ce85apswin
ce85comwin
dbexdrvrwin

I'm grabbing them on 6/24/2003. We'll see what happens.




 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top