Tallan's Technology Blog

Tallan's Top Technologists Share Their Thoughts on Today's Technology Challenges

SSRS Error After Cumulative Updates Applied

Brian Zebarth

SharePoint

After installing windows updates, SharePoint 2013 Service Pack 1 and the March 2016 Cumulative Update some users reported a problem with SSRS reports. They were receiving the following error message.

“Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘http://sharepoint/sites/SiteName/LibraryName/FileName.rdl‘ cannot be found.”

The error was occurring sometimes as soon as they clicked the link to the RDL file and sometimes the report viewer would come up and the error appeared when attempting to run the report.

I reviewed the ULS Logs and found the following errors:

“Cannot find site lookup info for request Uri http://webservername:12345/{guid}/ReportExecution.svc.”

“Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘http://sharepoint/sites/SiteName/LibraryName/FileName.rdl‘ cannot be found.;”

I did some research on the errors and found a few posts from people who had similar issues and they had success deleting and re-adding the Reporting Services Service Application. I decided I didn’t want to do that if I didn’t have to so I thought I would try to re-provision the service application first. I ran the following PowerShell.

Add-PSSnapin microsoft.sharepoint.powershell

Get-SPServiceApplication

# Review the list of Service Applications to find an appropriate DisplayName to use for matching in the next command

$rssa = Get-SPServiceApplication | ?{$_.DisplayName -match “Reporting Services”}

$rssa

#You should see information about the Reporting Services Service Application. If not double check the value used in the match above.

$rssa.Provision()

After the Provision command completed I tested some of the RDL files again and was able to successfully run the reports without error.

_________________________________________________________________________________________

To learn more about SharePoint and how Tallan can help you build enterprise productivity solutions to help you meet your business goals, CLICK HERE.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>