We have a couple custom report styles for the WIP Report. Things were running fine for many, many months, and then suddenly when we tried to run the reports it gives an error:
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'RptParameter'. ---> System.Data.SqlClient.SqlException: Invalid object name 'RptParameter_7609a185543d4930a32a86635fc24c6d'.
Each time we try to run it, it looks for the same temporary table in the SSRS database instead of creating a new table each time.
If I try to copy the WIPReport definition to a totally new definition, it still errors even if I don’t modify the definition.
The standard report still works but doesn’t have the additional data we added to the other styles.
Our Test environment still works but that data is a couple of months behind, so something happened since that data backup in July.
Anyone encounter this before or have any ideas why the report data is not being generated?