• 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

    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!

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

    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.

  • $organization in reply to A. Freeman

    Hi Amanda,

    Good day.

    you can open the sql profiler, see what is in there.

    have fun.

    Ben

     

Reply Children
No Data