I am in the process of upgrading to 2021.2. My company has 2 separate environments, one for our US operations and one for our European operations. I upgraded the US environment about a month ago without issue and am working on getting our EU environment upgraded now. Some months ago I got our Kinetic server up and going so we could start testing. So far everything has been great. I noticed that I missed the “SSRS Reports Root Folder” when I deployed it, so I wanted to fix that. I changed that and re-deployed, then used Powershell to move all my reports into the new root folder, also changing the Datasource path on each report in the process. Well, none of the reports worked. I keep getting the following error:
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
Ice.Core.SsrsReportService.ReportExecutionSoapException: Exception of type ‘Ice.Core.SsrsReportService.ReportExecutionSoapException’ was thrown.
SOAP Fault: The report server cannot process the report or shared dataset. The shared data source ‘dsPackSlip101’ for the report server is not valid. Browse to the server or site and select a shared data source. —> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceReferenceException: The report server cannot process the report or shared dataset. The shared data source ‘dsPackSlip101’ for the report server is not valid. Browse to the server or site and select a shared data source.)
So I went back and made sure that my path was correct. It was. I figured I would try re-importing all the stock reports. So I did that and that fixed the default reports but my custom reports still aren’t working. I compared the datasource connection in the RDL and they are the same. I then tried changing the datasource in Report Builder. What do you know, that worked! I have no idea why, but it worked. I downloaded one of my custom reports, made the datasource change in Report Builder, then redownloaded the report so I could compare them.
Contents are identical.
What the heck am I missing here? I have done this before without issue…