.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Report Execution Time Out/Delayed

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server

I have a report i have developed in Bids sourcing from AS cube. Whe I execute the report inside BIDS, i get the results within couple of seconds. But when i run the same report from Report Manager Site, It process for a long time and then generate the following error. Any ideas gues?

An error occurred during client rendering. An error has occurred during report processing. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


View Complete Post

More Related Resource Links

Crystal Report Asking for Database Authentication each time when I view Page.


Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for

User name
Data Name

each time.

Is there a way to avoid this and I save these authentication in my page once.

I am using VS2005, C#.

Any Help will be appriciated.


improve sql execution time

i need to select one of the record out of 10 thourands record,but when the program execute the sql , it takes a long time to extract data and my PC indicate low memory alert.   how can i improve the execution time to select the data from sybase

IE cannot display the webpage during report execution

Hi. I have a problem with a report having some T-SQL and MDX queries. When I execute it during the working hours I have an error about that Internet Explorer cannot display the web page, but in the other hours the execution is completed successfully. I have a look inside RS log but I cannot find any errors; no timeout is set about report execution inside the Report Manager. Any ideas to solve this issue, please? Many thanks

Get Query execution time

I need to find out the query execution time from the front end .Where should I insert the code for that.Please help.. I am using the bleow query: OracleConnection con = new OracleConnection(ConnStr); con.Open();  OracleCommand cmd = new OracleCommand("Stored_Proc",con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(); .................... ................ OracleDataAdapter oda = new OracleDataAdapter (cmd);  

Sql server Report services integration with moss 2007 giving hard time.

Hey guys, I have 2 servers  in seperate domain one for database and other for moss 2007. SERVER 1 :     AD,DNS,SMTP,SQL SERVER 2005 sp3 .... SERVER 2:    MOSS 2007 APPLICATION SERVER with sp2 and october cumilative updates applied. i have even installed NDP20-KB913384-X86.exe hot fix for .net framework 2.0 access voilation error. In CA my server 2 version is When i installed sql server 2005 on server 1 during installtion for report server i choosed install but do not configure. Now I decided to integrate the sql server report services into sharepoint and did some research and found some articles on msdn which says in order to integrate the report services into sharepoint i need to have a minimal install of moss 2007 on server hosting report services (correct me if i am wrong). since i have only 2 servers i decided to install the minimal installation of moss 2007 on my server 1 ( Web front end only ). Here are the steps i followed for it Installed .NET framework 3.0 Installed moss 2007 sp2 Installed october cumuilative update for wss then same for moss 2007. Installed .net framework 2.0 NDP20-KB913384-X86.exe hot fix. and then ran the psconfig from command line as psconfig -cmd configdb -connect -server <SQLServerName> -database SharePoint_Config_ <dbname> -user <domainusername> -password <passw

How to do Time bound workflow execution

The requirement is that the workflow should complete in a time specified as a workflow parameter, if it is not able to execute all the activities , it should terminate itself. Can anybody give me an idea how i can do that. regards

Display current time (live?) on report?

Is it possible on a report to display a clock showing the current time, ticking? Or, is it possible to display a static picture of an analog clock? I have the current time with an expression, but would love to have it updating real time. Any luck with javascript or anything?

Job Execution times / statistics report ...

We have several sites (countries if you may call them) and each site has its own set of ERP databases (Progress database). We have designed ETL layers that are open and which can be invoked for each of these sites. On top of the ETL layers, we scheduled the SSIS packages via SQL jobs for each site and scheduled them to run at various times of the day based on the site operating hours. I want to now present the amount of time it takes to copy data from the ERP system into our SQL 2008 Staging and finally into our DataWarehouse. I can manually right click on the SQL jobs and get the timings, however, I want to automate this report so that we can look at it initially weekly and maybe monthly when things start to run smoothly. Any pointers or ideas? I know I can run SQL Profiler and capture the SQL behind this report, would it actually work? ThanksJagannathan Santhanam

Execution Time changes in a fashion


Hi All,

Here is my problem,

I have an sp to retrieve max 1000 records(from joining 6 diff tables & conditions too). 

suddenly a bulk amount (millions)of records inserted to the tables.

Here is the statistics of the sp executed in an order :[any way result will be top 1000]

0 seconds for querying a dept of 10500 records without extra parameters.

0 seconds for querying a dept of 10500 records with extra parameters.

4 seconds for querying a dept of 700500 records without extra parameters.

8 seconds for querying a dept of 700500 records with extra parameters.

now the problem starts

3 minutes for querying a dept of 700500 records without extra parameters.[which previously executed in 4 seconds.]

Thanks for looking into this,

Any solution/suggestion will help me to recover from mental stress :(


Issue - The report execution has expired or cannot be found. (rsExecutionNotFound)


Hello Experts,

I am running a huge SSRS 2008 report (that returns 2 million records) and it gets rendered sometimes and sometimes it gives me an error,

"The report execution <some string> has expired or cannot be found. (rsExecutionNotFound)”.

When I see SQL Server log after this issue comes I see following message there;

"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"

IMPORTANT point to note here is when I am running reports with 1 million records or smaller than that, then I am able to execute them successfully without any issue.

I am using SSRS 2008 64 bit, Win Server 2003 64 bit. RAM is 8GB.

Please help me to know what are these issue, are these two issues related and how to fix it?


Multiple report execution is not in parallel


Hi everybody,

I experienced an issue with Sharepoint Foundation 2010. (Server 2008 and Sharepoint Foundation 2010 64bit)

When I use multiple Reportviewer Web parts on one page, the rendering (and most likely the Query itself) is not executed in parallel, i.e. every web part waits for its predecessor to finish.

I made two screenshots to show the difference in behavior (both are on the exact same hardware)

Sharepoint 2010 (Total execution Time 32 sec) : http://img807.imageshack.us/img807/6712/sp2010.jpg

Query execution time from 1 second in SQL 2000 to 20 Seconds in SQL 2008 R2


When I ran this query from SQL 2000 it takes 1 second. now in SQL 2008 R2  the same query is 20 times slower.

This is the query and the numer of records and the time in SQL 2008 R2:

SELECT * FROM dbo.CxP_Saldos 
0 seconds, 923 Rows
SELECT * FROM S_Conta.Cuentas
0 seconds, 662 Rows
SELECT * FROM S_Conta.Cuentas c INNER JOIN dbo.CxP_Saldos s ON c.id = s.CtaProv
18 seconds, 923 Rows

how can I submit the actual execution Plan?

About the scheduling of a report execution



I need to exceute a SSRS 2005 report in batch with the SQL Server Agent. This report has some parameters. How can I do know to SQL Server Agent which are these parameters? I don't want to write the values in the settings of report subscription.

Is it possible to do to read a table containing the report parameters or to save to a table the parameters when the user launches the report in the report manager? Many thanks

Nested Views execution time, how long does it take to "unpack" the SQL?


We have the case where in a reporting solution for an application it was decided to build a series of reporting views, fair enough. These views are layered, nested several levels deep at times and, not unexpectedly, as our customer's data grows so these views slow...

To complicate matters further, the report SQL may then join several of these top level reporting views to produce the data it needs.

In a recent support request for a slow performing report we ripped the sql out of the report, pasted it into SSMS and while investigating found a join error in the reports SQL that took execution time from ~ 2 minutes down to about 6 seconds...  Regardless of what we did after that we were unable to reduce the time below 6 seconds using our reporting views. Rewriting the SQL against our base tables takes a fraction of a second to return the needed information.

What I need to do is demonstrate where the extra time in getting the results from the views is spent.  My guess is that it is in untangling all the views and then ending up with a less than optimal query plan. Is there anyway to measure how long it takes the server to "unpack" the nested views into a single SQL statement before it can be executed? Knowing how much of the 6 seconds this is accounting for would be helpful to us in our decision making process.



Running Subreport and link to report ahead of time.



I have a question regarding running subreports ahead of time to ensure long running report does not take over 1 hour.

Problem Statment:

I have a top report subscription (Dashboard) that runs daily. In the top report, I have links to sub report that based its parameter to the top report row. The problem is the sub reports takes 20-30 minutes to run. How can pre run the sub reports once the top report has run, so that I do not have to wait 20-30 minutes to drill in to those sub report ?




Decrease Query execution time

Hello friends,
I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc.
I want to decrease it and want to make it execte withing 30-40 sec..
It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons.
so any ideas....
Confused D'Oh! 
One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table.
if its possible then how can i do it?Is there any other way to solve this problem?

Thanks in advance.. Smile 

Report Execution error when View page in VPN


I only have 1 user that cannot see reports. I even did a gotomeeting and we clicked refresh serveral times and we get the Report Execution Session died.


Every other user works on VPN. The rest of the wqeb site also works fine.


Does any have some pointers on find a resolution for this user. He is windows authenticated and using a VPN. ( I have 1 user out of at least 50 have worked fine with a report viewer over VPN.



Ideas appreciated. 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend