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'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