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
I should point out that we are RAMP users.
I've seen it here as well. We are self hosted and it seems to be related to a timeout, but I haven't figured where yet. Your bet best is optimize the procedure to reduce the overall time of the query.
Thanks Troy, When I run the SP in Management Studio it takes just over one minute, which doesn't seem excessive, but I think you are on the right track. I'll carry on playing around with it.
Debbie
Nancy ShelehedaSr. Director of Application Development and Support ServicesPittsburgh Cultural Trust803 Liberty Avenue, Pittsburgh, Pa 15222412-456-1387 Sheleheda@trustarts.org | TrustArts.org
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.