• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 65 views
  • Users 0 members are here
Related

SSRS Report Can't Find SP

A. Freeman
$organization

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
  • $organization

    Have you checked the data source directly from the Report Manager for the report?  When deploying from BIDS, by default you don’t overwrite the datasource on the report server.  Could it be that it’s called “ImpresarioDB” but it points to the wrong database...perhaps the right server, but the wrong initial db (master, for instance).

     

    -Ryan

     

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

     

    I don't see anything wrong in the datasource. It's a shared datasource, defniitely set to impresario. Plus all the other reports using the same shared datasource are fine.

    From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com>
    Sent: 11/19/2010 1:35:55 PM

    Is the datasource configured to use the Impresario DB and the right database connection?

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman
    Sent: Friday, November 19, 2010 2:02 PM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] 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?




    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!




    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!

  • $organization in reply to Ryan Creps (Past Staff Member)

    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.

Reply
  • $organization in reply to Ryan Creps (Past Staff Member)

    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.

Children