Manual SQL Reporting Deployment Tip

When manually moving a SQL Reporting report from one environment to another, you may encounter the “The item ‘[/reportfolder/reportname]‘ cannot be found. (rsItemNotFound)” issue.   Most of the technical blogs will lead you to believe there is a permission problem on the file.  While that may be true, we have experienced something different.

When you deploy a SQL Report from Visual Studio to a target repository, it creates a GUID to bind it to that environment.  If you copy the RDL file off that system and attempt to manually put the file in another system, you need to remove the following section of the RDL file, else you will get the error.

Look for a reference, typically at the bottom of a file, formatted as follows:

<rd:ReportID>395484f8-dea9-44d0-8efb-5f397b4b2a76</rd:ReportID>

Remove this reference, manually upload the file to the reporting server, and hook up your data sources.  It should resolve the issue.

Social Share:
  • Facebook
  • LinkedIn
  • TwitThis
  • Ping.fm
  • E-mail this story to a friend!
  • Print this article!
| Tags: , | Category: Reporting, Technical | Leave a comment

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

* Copy this password:

* Type or paste password here:

2,159 Spam Comments Blocked so far by Spam Free Wordpress

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=""> <strike> <strong>