I reviewed the release notes on the EpicWeb for version 10.2.200 and found no reference to the issue. “EPIC03” sounds like a reference to the education database. Is this report the only one having issues after the upgrade?
Been on 10.2.200.7 for almost 2 months now without issue. I was thinking it was a reference to one of their databases but can’t find a way to clear it.
I have a call into support but not sure how long that is going to be seeing as how it is Friday.
Support just got back to me and referenced the below KB.
“The issue you’re having has already been reported and the solution can be found in KB0042057”
They also included a script to run against the DB which got me past the initial error and on to a new one on the report generating side. Looks like they changed multiple column names and now it can’t decide what to do.
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 column name ‘FormType’.