RS2005 crashing...stupid error

For some reason, our reports will just stop working...randomly.
It basically tells us it can't connect to our record sets. The report works
in the designer.
Also, if we re-deploy the report it starts working! Even if we don't change
anything it sometimes stops. Then, we re-deploy and it works.
What gives?
This is with different users and different reports.
Thanks!
-cbmeeksSorry to bump this but it is really becoming a problem.
At random, our reports just stop working. With different error messages.
Sometimes, it can't find a stored procedure. Sometimes, it can't find a
table. It's like the report is loosing its connection with the server.
I have confirmed the stored procedure/tables/etc are there and working. All
other apps access the data just fine. The newest SP has been installed on
the server.
Any clues?
Here is a copy of the error message:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'Customers'. (rsErrorExecutingCommand)
Could not find stored procedure 'dbo.up_get_customer_list_with_All'.
The last line changes. Sometimes it can't find a stored procedure,
sometimes it can't find a table. Once again, I have confimed they are indeed
there and working.
Thanks
-cbmeeks
"cbmeeks" wrote:
> For some reason, our reports will just stop working...randomly.
> It basically tells us it can't connect to our record sets. The report works
> in the designer.
> Also, if we re-deploy the report it starts working! Even if we don't change
> anything it sometimes stops. Then, we re-deploy and it works.
> What gives?
> This is with different users and different reports.
> Thanks!
> -cbmeeks