SSRS Report

Hi,

I am getting an error when I try to make a connection between SSRS report and report setup(Tessitura Report).

I am pretty new to Tessitura.

 

Here is the ERROR:

Exception of type 'System.Web.HttpUnhandledException' was thrown.
There was an error processing this request. Please check the details below.
The item '/Tessitura_Custom/Tessitura_Reports/CEP_MS_Choral_Camp_Test2' cannot be found. (rsItemNotFound)

at System.Web.UI.Page.HandleError(Exception e)
 at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 at System.Web.UI.Page.ProcessRequest()
 at System.Web.UI.Page.ProcessRequest(HttpContext context)
 at ASP.reports_viewreport_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\testapi_tessituraweb\6d0322a1\16a301f7\App_Web_ka4x3sxe.0.cs:line 0
 at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
 at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Inner Exception

 at Tessitura.Web.Reports.ViewReport.Page_Load(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)

 

  • Hi Gurpreet,

    have you published report using visual studio? Error message seems to suggest that report does not exist in that directory.

    The item '/Tessitura_Custom/Tessitura_Reports/CEP_MS_Choral_Camp_Test2' cannot be found. (rsItemNotFound)

    Best,

    Dmtirij

  • Hi,

    We just ran into this same error today in our TEST environment.  What version of Tessitura are you running?

    Thank you,

     

    Dr. Laura House, Shared Services Database Manager

    Kauffman Center for the Performing Arts

    1601 Broadway | Kansas City, MO 64108

    direct 816.994.7214 | cell 816.301.1304 | fax 816.994.9037

    kauffmancenter.org | a non-profit 501(c)3 organization

    Kauffman-Center-Logo_5 Years_SMALL

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gurpreet Saini
    Sent: Monday, May 23, 2016 10:38 AM
    To: Laura House
    Subject: [Tessitura Technical Forum] SSRS Report

     

    Hi,

    I am getting an error when I try to make a connection between SSRS report and report setup(Tessitura Report).

    I am pretty new to Tessitura.

     

    Here is the ERROR:

    Exception of type 'System.Web.HttpUnhandledException' was thrown.
    There was an error processing this request. Please check the details below.
    The item '/Tessitura_Custom/Tessitura_Reports/CEP_MS_Choral_Camp_Test2' cannot be found. (rsItemNotFound)

    at System.Web.UI.Page.HandleError(Exception e)
     at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at System.Web.UI.Page.ProcessRequest()
     at System.Web.UI.Page.ProcessRequest(HttpContext context)
     at ASP.reports_viewreport_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\testapi_tessituraweb\6d0322a1\16a301f7\App_Web_ka4x3sxe.0.cs:line 0
     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Inner Exception

     at Tessitura.Web.Reports.ViewReport.Page_Load(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)

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • We are running the same version of Tessitura, then.  How did you resolve the problem?

    Thanks!

    Laura

  • Have you deployed your report in test?

  • Sorry. Shelley is out for maternity leave and I don’t have her level of skill. I can’t answer your question.

     

    Her emails are being forwarded to me.

     

    I think she is expected back about September 1 or so.

     

    Dorothy LaBounty

    Box Office Specialist

     

    cid:image001.jpg@01D0A509.EB58ABD0

     

    524 Trinity Avenue, St. Louis, MO 63130

    Direct 314 561 4877

    www.cocastl.org

     

     

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Laura House
    Sent: Tuesday, May 24, 2016 3:27 PM
    To: Shelley Espinoza
    Subject: RE: [Tessitura Technical Forum] SSRS Report

     

    We are running the same version of Tessitura, then.  How did you resolve the problem?

    Thanks!

    Laura

    From: Gurpreet Saini <bounce-gurpreetsaini8596@tessituranetwork.com>
    Sent: 5/24/2016 3:51:39 PM

    Version 12.5.1.120




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Yes,  we have, and that is where we ran into the error. 





    Happy Connecting. Sent from my Sprint Samsung Galaxy S® 5


    --------
    Original message --------
    From: Gurpreet Saini <bounce-gurpreetsaini8596@tessituranetwork.com>
    Date: 05/24/2016 16:04 (GMT-06:00)
    To: Laura House <lhouse@kauffmancenter.org>
    Subject: RE: [Tessitura Technical Forum] SSRS Report

    Have you deployed your report in test?

    From: Laura House <bounce-laurahouse8114@tessituranetwork.com>
    Sent: 5/24/2016 4:24:18 PM

    We are running the same version of Tessitura, then.  How did you resolve the problem?

    Thanks!

    Laura




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
  • I deployed report on test in SSRS. By default it was Live.