Urgent help on rsExecutionNotFound
Deaar all, I need to get a real solution to my issue based on reporting services. My scenario is as follow: We have report template define with Reportbuilder 2.0 hosted under IIS RSS database under Windows Server 2008 We are calling those reports to be print from a WPF application. SO based on that here are trouble we face : When starting the application and printing the first report, application freeze for 45 s . We have notice that the same thing occurs if we call the report server from the explorer by enterign the http://localhots/reports How to avoid this on the first print or seting up a way the the http adress is send a request before aplciation start then printing works all the time and no delay durig that time ? Second trouble we get is that after a while we have the folloing error : Execution 'h2gzyn55w5qzjo55nky2sa55' cannot be found (rsExecutionNotFound) and no more report can be printed anymore Please not that I am not an expert in this so please provide stepby steps procedure for somving this as my customer start be be in a bad mood cause I could not solve it Please not that I have check many thing on the net and even try to run the following script but after a while it come again Public Sub Main() Dim props() as [Property] props = new [Property] () { new [Property](), new [Property]() } props(0).Name = "SessionTimeout" props(0).Value = timeout props(1).Name = "SessionAccessTimeout" props(1).Value = timeout rs.SetSystemProperties(props) End Sub If I need to retry the script please tell me how to lanch it and where to launch it automatically in regular period Thnaks for your prompt assistance regards Serge Your knowledge is enhanced by that of others.
November 24th, 2010 8:05am

Hi Serge, For your first issue " the same thing occurs if we call the report server from the explorer by enterign the http://localhots/reports", it might be due to the compilation of .NET application, as SQL Server Reporting Services can be considered as a .NET application. I assume the issue only happens when we open the report manager first time. To work around the issue, we can invoke the SQL Server Reporting Services(SSRS) web service while loading the WPF application, and before printing the report. We can use the HttpWebRequest to do so: System.Net.HttpWebRequest Req = (System.Net.HttpWebRequest)System.Net.WebRequest.Create("http://server/reportserver"); Req.Credentials = System.Net.CredentialCache.DefaultCredentials; Req.Method = "GET"; For your second issue, it is caused by the ExecutionId is not found from the report server catalog database. Usually, it happens when the report execution is timeout. As you mentioned, we can change the SessionTimeout and SessionAccessTimeout to solve the issue. SessionAccessTimeout corresponds to how long we will wait when trying to access session information before timeing out, and SessionTimeout corresponds to how long the session is kept alive between requests. About how to use the script you posted, please follow these steps: New a text file, paster the code you posted in the file, and then save the file with extension name .rss(means replacing .txt with .rss. E.g. sessionTimeout.rss) Open a Command window by typing CMD in the RUN In the Command window, execute the following command: rs -i c:\sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000" If there is anything unclear, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2010 12:30am

Thnaks for your reply : Does doing thise : rs -i c:\sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000" is enought to do it once at application start or does it have to be done regulary periode ? regards sergeYour knowledge is enhanced by that of others.
November 25th, 2010 12:03pm

Thnaks for your reply : Does doing thise : rs -i c:\sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000" is enought to do it once at application start or does it have to be done regulary periode ? regards sergeYour knowledge is enhanced by that of others.
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2010 12:03pm

Thnaks for your reply : Does doing thise : rs -i c:\sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000" is enought to do it once at application start or does it have to be done regulary periode ? In otehr words, can I execute this command at the start of my WPF application after the : System.Net.HttpWebRequest Req = (System.Net.HttpWebRequest)System.Net.WebRequest.Create("http://server/reportserver"); Req.Credentials = System.Net.CredentialCache.DefaultCredentials; Req.Method = "GET"; If yes ho can I launch it ? regards serge Your knowledge is enhanced by that of others.
November 25th, 2010 12:04pm

Hi Serge, The command is used to change two configurations(SessionTimeout and SessionAccessTimeout) in the report server. It is a once execution command, we just need to execute it once in the Command window. The C# code is used to simulate the accessing to the report server, this will led the report server to be initiated before the actions in the WPF application. Thanks, Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 25th, 2010 8:39pm

hello thnaks for your reply. Does this command : rs -i c:\sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000" can be executed as a normal windows user regards sergeYour knowledge is enhanced by that of others.
December 17th, 2010 10:29am

I have try your suggesting and I still have same issue, Does IIS need to be resarted or anything to restart from RSS in order to get tilme out taken in account ? regards serge Your knowledge is enhanced by that of others.
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2010 6:28pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics