SSRS Report Can't Find SP

I've got a modified version of Ryan Creps' Interactive Seatmap. It works fine in BIDS. I've deployed it, and when I try to run it from Tessitura I get this:
  • An error has occurred during report processing.
  • Cannot read the next data row for the data set dsPerfSeats.
  • Cannot find the object 'LRP_PERF_SMAP', because it does not exist or you do not have permission. 
The procedure definitely exists, and ImpUsers has execute permission. I googled a bit and found suggestions for explicitly specifying the schema, which I did, but that hasn't made a difference. Has anyone encountered this before?

Parents
  • Glad you figured out the problem!

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Tuesday, November 23, 2010 1:50 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] SSRS Report Can't Find SP

     

    In case anyone else ever runs into this, I found my mistake. I noticed this morning I still had the Grant statement at the bottom of the procedure, and that's where the permission issue was coming from. As soon as I commented it out the report worked. 

    From: Amanda Freeman <bounce-amandafreeman5080@tessituranetwork.com>
    Sent: 11/22/2010 3:44:59 PM

    It's possible I'm not looking in the right place, in which case it's entirely possible that that is what is happening but I don't see it. I looked at the datasource from the Report Manager and it shows the correct shared datasource; and when I look at that datasource its initial catalog is set to impresario. Not necessarily related, but the datasource isn't called "ImpresarioDB". I know it was in the original, but I changed it to this other shared datasource before making my modifications. Although the dataset that populates the List dropdown is using the same shared datasource and it's showing up just fine, which makes me think the datasource is not pointed at the wrong db.

    I tried a trace but I think I must not have selected all the correct events, or I'm not doing it right. I can see when it starts to try to execute LRP_PERF_SMAP and it's using impresario and the parameters all look fine, and I see the SP Completed... but now I'm veering into territory where I don't really know what I'm talking about.




    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!

Reply
  • Glad you figured out the problem!

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Tuesday, November 23, 2010 1:50 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] SSRS Report Can't Find SP

     

    In case anyone else ever runs into this, I found my mistake. I noticed this morning I still had the Grant statement at the bottom of the procedure, and that's where the permission issue was coming from. As soon as I commented it out the report worked. 

    From: Amanda Freeman <bounce-amandafreeman5080@tessituranetwork.com>
    Sent: 11/22/2010 3:44:59 PM

    It's possible I'm not looking in the right place, in which case it's entirely possible that that is what is happening but I don't see it. I looked at the datasource from the Report Manager and it shows the correct shared datasource; and when I look at that datasource its initial catalog is set to impresario. Not necessarily related, but the datasource isn't called "ImpresarioDB". I know it was in the original, but I changed it to this other shared datasource before making my modifications. Although the dataset that populates the List dropdown is using the same shared datasource and it's showing up just fine, which makes me think the datasource is not pointed at the wrong db.

    I tried a trace but I think I must not have selected all the correct events, or I'm not doing it right. I can see when it starts to try to execute LRP_PERF_SMAP and it's using impresario and the parameters all look fine, and I see the SP Completed... but now I'm veering into territory where I don't really know what I'm talking about.




    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!

Children
No Data