| Author |
Topic |
|
joe8079
Posting Yak Master
127 Posts |
 Posted - 2012-09-18 : 20:14:58
|
| Just a general question regarding temp tables and SSRS. Whenever I use temp tables in SSRS and the query takes longer than 16 seconds, it will time out saying it could not populate all the fields while rendering the report. Does anyone know why this happens or what causes this? I use temp tables often, but I find that I cant use them in SSRS if the query takes longer than 16 seconds to run. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-19 : 12:13:56
|
| i've not seen this myself yet. I've used temp tables quite a lot in ssrs queries and have not had any issues with it.Are you rendering report from standard report viewer or from custom .net page?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-09-19 : 12:36:31
|
| its being rendered from a standard report viewer. Everything works fine, but if the query takes longer than 16 seconds, i'll get an error saying SSRS could not update all the fields. |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-09-19 : 20:40:57
|
| I ended up replacing all of my temp tables with CTEs and everything works perfectly. I just hate the fact that I can't use Temp Tables in SSRS if my query takes longer than 16 seconds to run. |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-09-20 : 11:06:38
|
| Now, i'm starting to get this message even with CTEs: Not really sure where to go with this one. It takes 1 minute to run in managment studio. An error occurred while the query design method was being saved. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-09-20 : 11:21:39
|
| I changed the timeout property for 15 seconds to 10,000 seconds so lets see if this works |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-20 : 11:49:14
|
| oh...if timeout is set as 15 s regardless of whether you use temp tables or not it will fail if query execution time goes beyond 15 s------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-09-20 : 11:57:29
|
| wow, this is getting worse - time out set to 10,000 and it still times out. |
|
|
|
joe8079
Posting Yak Master
127 Posts |
Posted - 2012-09-20 : 17:26:57
|
| for some reason, it seems to be working now. No issue anymore. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-09-20 : 23:27:29
|
| it might have been issue with load on report server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
SSRS and Temp tables