Hello,

Suddenly our scheduled reports from crystal reports is running 18hrs late or even 23 hrs late. We checked the time on the server and also checked to see if any other queries or reports are blocking the database but did not find any. We also checked the queries for these reports by running them directly on the database and they returned results in a few seconds. I am also able to get the report out in a few seconds in the crystal report developer.

Also some of the reports no longer run at the scheduled time and people have to go in and run it manually. Has anyone seen this sort of behavior? Please help as we have run out of ideas..

Thanks,
Vaish.

Thanks. We actually did exactly that this morning (stopped services and restart) and that fixed it. I also found the server option earlier today under CMC which I was not aware of. I will do the cleanup some time. Thanks again for your help!