none
rsItemNotFound issue while using ReportViewer

    Question

  • I have a web server A and Server B. I am in ASP.net and using ReportViewer Control. My application is pointing to following URL for a report. It runs fine on Server A but when i move my application to Server B, it does not work. I have spent two days almost to figure out the issue but could not find any clue. I am using the same domain\user on server A and Server B. so not sure what is causing this issue.

    The item '/QA/Managed/Service Operations/Private/TestApp/DataStatisticsReport' cannot be found. (rsItemNotFound)
    at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters) at ClaimsStatisticsReport.AddReportParameters(String startDate, String endDate, String criteria) in d:\Inetpub\wwwDefault\TestWeb\DataStatisticsReport.aspx.cs:line 147 at DataStatisticsReport.Page_Load(Object sender, EventArgs e) in d:\Inetpub\wwwDefault\TestWeb\DataStatisticsReport.aspx.cs:line 52 at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)
    Thursday, February 4, 2010 9:28 PM

Answers

  • Hi Moonis,

     

    From your information, I assume the Report Viewer is used in remote mode, and the server report path is ‘/QA/Managed/Service Operations/Private/TestApp/DataStatisticsReport’. If I have misunderstood, please do not hesitate to let me know.

     

    Generally, the issue is caused by the Report Server URL provided in the Report Viewer control is not correctly.

    Sometimes, we make a mistake that provide the Report Manager URL (http://<reportserver>.<port>/reports_<instance>) instead of Report Server URL.

     

    The available URL should be in the following syntax:

    http://<reportserver>.<port>/reportserver_<instance>

    If this is a default instance, the URL should be:

    http://<reportserver>.<port>/reportserver

     

    Another possible issue is that:

    If the Report Server is deployed in Server A, and we use http://localhost/reportserver for Report Viewer in Server A, after moving the application to Server B, the Report Server URL for Report Viewer won’t be change. In this case, if Server B also has Report Server installed in, the URL will work, but the report may have not been deployed to Server B. Or the Server B does not have a Report Server, the URL is invalid.

     

    So, please check the Report Server URL to solve the issue.

    1.       Please make sure the Report Server URL is in the available syntax.

    2.       Please make sure the Report Server URL point to the correct Report Server.

     

    By the way, I would also like to check the issue in the following steps:

    1.       Login Server B with a domain user that has permissions to access reports.

    2.       Open Internet Explorer(IE)

    3.       Go to the Report Manager using http://<reportserver>.<port>/reports_<instance> (or http://<reportserver>.<port>/reports )

    And go to the Report Server using http://<reportserver>.<port>/reportserver_<instance> (or http://<reportserver>.<port>/reportserver )

    4.       If we are able to access the Report Manager or Report Server from this server, the issue may be the one I mentioned before.

    5.       If Not, please follow the error message the Report Manager (or Report Server) throw to solve the issue.

    The Report Server logs and Windows Event logs also do us a good help. If possible, could you please help to collect this logs?

    We can find SQL Server Reporting Services from

    <Install Driver>:\Program Files\Microsoft SQL Server\<Instance>\Reporting Services\LogFiles

     

    If there is anything unclear, please feel free to ask.

     

    Thanks,

    Jin Chen


    Jin Chen - MSFT
    • Marked as answer by Moonis Tahir Saturday, February 6, 2010 9:51 PM
    Friday, February 5, 2010 6:47 AM
    Moderator
  • Jin Chen, Report server url was incorrect. i overlooked web.config of server B.  :)

    However error was quite misleading. Because report server URL was still valid and was point to a different reporting server. Error should have been access denied. because when i copied the URL in web browser, it gave me access denied and but report viewer was saying rsItemNotFound exception.
    But any way, it is resolved now. Thanks alot for your time on this issue.
    Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)
    • Marked as answer by Moonis Tahir Saturday, February 6, 2010 9:54 PM
    Saturday, February 6, 2010 9:54 PM

All replies

  • is your report viewer property setting is as below?

    Me.ReportViewer1.ServerReport.ReportPath = "/nsPortalReports/rptFinanceAssociation".

    Failure in Life is failure to try...
    Thursday, February 4, 2010 9:47 PM
  • Also May I know what code written at line 52 and 147?
    Failure in Life is failure to try...
    Thursday, February 4, 2010 9:59 PM
  • Hi Moonis,

     

    From your information, I assume the Report Viewer is used in remote mode, and the server report path is ‘/QA/Managed/Service Operations/Private/TestApp/DataStatisticsReport’. If I have misunderstood, please do not hesitate to let me know.

     

    Generally, the issue is caused by the Report Server URL provided in the Report Viewer control is not correctly.

    Sometimes, we make a mistake that provide the Report Manager URL (http://<reportserver>.<port>/reports_<instance>) instead of Report Server URL.

     

    The available URL should be in the following syntax:

    http://<reportserver>.<port>/reportserver_<instance>

    If this is a default instance, the URL should be:

    http://<reportserver>.<port>/reportserver

     

    Another possible issue is that:

    If the Report Server is deployed in Server A, and we use http://localhost/reportserver for Report Viewer in Server A, after moving the application to Server B, the Report Server URL for Report Viewer won’t be change. In this case, if Server B also has Report Server installed in, the URL will work, but the report may have not been deployed to Server B. Or the Server B does not have a Report Server, the URL is invalid.

     

    So, please check the Report Server URL to solve the issue.

    1.       Please make sure the Report Server URL is in the available syntax.

    2.       Please make sure the Report Server URL point to the correct Report Server.

     

    By the way, I would also like to check the issue in the following steps:

    1.       Login Server B with a domain user that has permissions to access reports.

    2.       Open Internet Explorer(IE)

    3.       Go to the Report Manager using http://<reportserver>.<port>/reports_<instance> (or http://<reportserver>.<port>/reports )

    And go to the Report Server using http://<reportserver>.<port>/reportserver_<instance> (or http://<reportserver>.<port>/reportserver )

    4.       If we are able to access the Report Manager or Report Server from this server, the issue may be the one I mentioned before.

    5.       If Not, please follow the error message the Report Manager (or Report Server) throw to solve the issue.

    The Report Server logs and Windows Event logs also do us a good help. If possible, could you please help to collect this logs?

    We can find SQL Server Reporting Services from

    <Install Driver>:\Program Files\Microsoft SQL Server\<Instance>\Reporting Services\LogFiles

     

    If there is anything unclear, please feel free to ask.

     

    Thanks,

    Jin Chen


    Jin Chen - MSFT
    • Marked as answer by Moonis Tahir Saturday, February 6, 2010 9:51 PM
    Friday, February 5, 2010 6:47 AM
    Moderator
  • Hi Moonis,

    Another possible caused to be mentioned:
    If the reports are deployed to Reporting Services 2008, and we are going to show the reports using Report Viewer 2005, it will fail.

    To solve it, please install Report Viewer 2008, and use Report Viewer 2008 to show the report.

    Microsoft Report Viewer 2008 SP1 Redistributable: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6

    Thanks,
    Jin Chen
    Jin Chen - MSFT
    Friday, February 5, 2010 8:22 AM
    Moderator
  • Jin Chen,

    Thanks for taking time to respond the issue. I have double check that URLs are correct. I did login with user that i am using in Application pool on Server B and verified that i can see the reports on report server url.

    my reporting server is a different server Server C. so my URL stays the same when i am on Server A or Server B. It is reporting service 2005.

    I will install RS 2005 Redistributable viewer on Server B just to make sure it is there. i know it is there but i will do this one step extra. i am running out of ideas on it 
    Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)
    Friday, February 5, 2010 1:19 PM
  • Jin Chen, Report server url was incorrect. i overlooked web.config of server B.  :)

    However error was quite misleading. Because report server URL was still valid and was point to a different reporting server. Error should have been access denied. because when i copied the URL in web browser, it gave me access denied and but report viewer was saying rsItemNotFound exception.
    But any way, it is resolved now. Thanks alot for your time on this issue.
    Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)
    • Marked as answer by Moonis Tahir Saturday, February 6, 2010 9:54 PM
    Saturday, February 6, 2010 9:54 PM