• Replies 5 replies
  • Subscribers 337 subscribers
  • Views 160 views
  • Users 0 members are here
Related

Probably a question for RAMP clients. Reporting Services report issue.

Debbie Harland (Past Member)
$organization

Hi All,

I've raised a TASK ticket for this already, but I thought I'd try the collective brain power of the Tessitura users as well.

I have an SSRS report which was working wonderfully well, but has now stopped rendering. It will return all the correct data from the SP in Management Studio, and the VS Query will do the same. I've even been able, now, to get it to Preview in Visual Studio, that was failing for a while. It deploys without issue. It runs OK from Tessitura, just displays a blank screen.

Has anyone seen this before and does anyone have any suggestions?

Thanks, Debbie

Parents
  • $organization
    We get this quite a lot too, especially since upgrading to v14.  There’s a lot of overhead in SSRS, and so optimizing the stored procedure, even if it does appear to run quick enough in SSMS, will still be helpful.  Additionally, if the report takes a list parameter, and the list being used to run the report is dynamic, that can also slow things down.
     
    There’s are a couple of timeout setting in the TessituraWeb config, that you may find helpful.  The default timeout for SQL seconds is 60.

    Nancy Sheleheda
    Sr. Director of Application Development and Support Services
    Pittsburgh Cultural Trust
    803 Liberty Avenue, Pittsburgh, Pa 15222
    412-456-1387
    Sheleheda@trustarts.org | TrustArts.org

Reply
  • $organization
    We get this quite a lot too, especially since upgrading to v14.  There’s a lot of overhead in SSRS, and so optimizing the stored procedure, even if it does appear to run quick enough in SSMS, will still be helpful.  Additionally, if the report takes a list parameter, and the list being used to run the report is dynamic, that can also slow things down.
     
    There’s are a couple of timeout setting in the TessituraWeb config, that you may find helpful.  The default timeout for SQL seconds is 60.

    Nancy Sheleheda
    Sr. Director of Application Development and Support Services
    Pittsburgh Cultural Trust
    803 Liberty Avenue, Pittsburgh, Pa 15222
    412-456-1387
    Sheleheda@trustarts.org | TrustArts.org

Children
  • $organization in reply to Nancy Sheleheda

    It should also be pointed out that depending on what data you are retrieving, there is a fair amount of overhead added in v14.1 for all of the privacy features.  All personal information (names, salutations, addresses, phones, emails, associations, etc.) have to be checked to see if the report runner has permission to see them.  Whether this comes into play depends on whether your report code makes use of the standard functions like FT_GET_ADDRESS, etc. which is where this new code is embedded.