rsExecutionNotFound !

I have been frequetly visiting your blogs with a solution for rsExecutionNotFound. I used johngaallard's script to extend the accesstimeout(to 6000 ) eventhough that was not the base of the problem.

My Reports run in less than 15 sec (max). I have enabled caching for about 12 hours ( there are nightly updates) using [Cache a temporary copy of the report. Expire copy of report after a number of minutes option])

The reports are rendered using a ReportViewerControl in an ASP.Net2.0 web application.(The report is rendered as PDF and then shown in another IFrame using Adobe plugin).The ASP application session timeout is 100mts.

The problem i am facing is that after sometime, the rsExecutionNotfound starts occuring for some report with a specific set of parameters. No amount of rerunning the report will stop. The same report with different parameters renders fine. The only way to stop this is to set the cache option 'Do not cache temporary copies of this report'.

If i set ''Do not cache temporary copies of this report'' there are no errors. I am doing caching mainly to bring down report rendering from 15 sec to 2-3 secs. I am using PDF format .

I am now thinking of working around by trying to catch the Exception that occurs and trying to re-render the report. If this is the only way, how can i do it.

I had fought fiercely to use SSRS and now I am in a fix
Any help is appreciated.
Thanks,
Saj

You probably want to post this in the reporting services forum. There are many more experts in that area there.

RS tiered architecture

I've implemented a solution with application, database and report server on seperate machines. The application is a web app and is Internet facing. What is the best method for executing reports on the RS server that are initiated from the web server? Using URL access requires a login or anonymous access neither of which are desired. Web services works but I loose access to the toolbar. Is there some other way to pull this off where I can let the public access reports and give them access to the toolbar?

Thanks.

Assuming SSRS 2005, the best way will be to use the ASP.NET ReportViewer control since it generates the report on the server and preserves the report interactive features. This article may help to get you started.|||

Thanks.

My understanding is that the Web ReportViewer the report is rendered on the browser not on the server and as such we loose the benefits of server cashing.Does this present a performance issue?

I'll give it a shot.

|||>>

My understanding is that the Web ReportViewer the report is rendered on the browser not on the server and as such we loose the benefits of server cashing. Does this present a performance issue?

<<

Your understanding is incorrect, so it is difficult to gauge the performance issue <s>.

The ReportViewer (web or win) has two modes. One is local, the other is server. But in neither mode would the ReportViewer be rendering in the browser. The difference is whether it is rendering in the RS server or in your web server tier, and also which tier is preparing the data.

In your case it looks like you are going to be using server mode, which means the reports come from the RS server tier and the data is prepared there as well, of course. The web tier hosts the control, requests report pages from the RS server, and sends the full page content for sending to the browser

In local mode the web tier hosts the control *and* the rendering code for the report page(s) without delegating to an RS server.

In local mode, if you are talking about report caching rather than web page, yes you are not going to have it because that is provided by the RS server. But if you are in server mode the RS server is going to decide to deliver a cached report (snapshot) based on its own settings, regardless of the client, as far as I know.

HTH,

>L<

PS To be strictly accurate, in all cases and all types of content a browser also "renders" a web page for display. But how a browser chooses to "render" what a reportcontrol sends is more like how it renders an image downloaded from a server. It doesn't "render" the JPG in the sense of creating it.

|||

My understanding is that the Web ReportViewer the report is rendered on the browser not on the server and as such we loose the benefits of server cashing. Does this present a performance issue?

We need to clarify what you mean by "render" and "server caching". The VS.NET 2005 ASP.NET report viewer is no much different than an ASP.NET page. It submits report requests to the Report Server on behalf of the user, gets the report presentation, and streams it to the client. This all happens on the server side. As with any web application, it is the browser who renders the HTML content to the user but it is a thin client. As far as the "server caching" I have no idea what benefits you are referring to.

RS in an Application Service Provider solution?

Hi,
We are thinking about using reporting services in an asp (application
service provider) solution and I have 4 questions regarding this:
- How can I authenticate the users before they access the reporting services
server? I don't want to expose my SQLServer and I want a mechanism that make
sure the user is a valid user before he/she gets to my SQLServer. Is it
possible (and a good solution) for me to let all traffic to my reporting
server go via my asp server which in turn does the authentication and then
redirects all the traffic to the reporting server?
- How can I prevent my users to see ALL reports on the reporting server. I
only want to display the reports that belong to the current user.
- How can I prevent my users to see the data of other users when he/she has
designed a report in report builder? Can I set a parameter for the datamodel
like a UserID?
- Is it possible to execute the Report Builder via an asp solution?
- Anyone who has experience of reporting services in an asp solution? Or
anyone who knows any good materials out there on this subject?
Kind regards
ThomasHi Thomas,
Welcome to use MSDN Managed Newsgroup!
>> - How can I authenticate the users before they access the reporting
services
>> server? I don't want to expose my SQLServer and I want a mechanism that
make
>> sure the user is a valid user before he/she gets to my SQLServer. Is it
>> possible (and a good solution) for me to let all traffic to my reporting
>> server go via my asp server which in turn does the authentication and
then
>> redirects all the traffic to the reporting server?
Using Forms Authentication in Reporting Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/ufairs.asp?frame=true
>> - How can I prevent my users to see ALL reports on the reporting server.
I
>> only want to display the reports that belong to the current user.
You may specify differents role for different users to do this. For more
detailed information, check the article below
Reporting Services Security Model
(ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_3hia.htm)
Using Role-Based Security
(ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_8kqb.htm)
Understanding Role-Based Security
(ms-help://MS.RSBOL80.1033/rswork/htm/rms_security_v1_488h.htm)
>> - How can I prevent my users to see the data of other users when he/she
has
>> designed a report in report builder? Can I set a parameter for the
datamodel
>> like a UserID?
No, I am afraid you cannot.
>> - Is it possible to execute the Report Builder via an asp solution?
ASP or ASP.NET?
How do you want to interate the Report Builder with your asp solution?
You might have to access the report builder with the link directly
http://<localhost>/reportserver/reportbuilder/reportbuilder.application
where <localhost> is the name of the computer that is running Report
Server.
(make sure the Enable Report Design Client Button is set to True in the
ReportManager\RSWebApplication.config file by default)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

RS ADO.Net extensibility? (using a webservices as a datasource?)

Hi All,
I have to build a solution where end-users have to operate data input and
reports. (This means that the GUI must be very user friendly).
Because of this, I was thinking of using Windows Sharepoint Services (WSS)
as a front-end for data input and using Reporting Services for generating
reports on this data.
WSS will make it easy for users, because it has a real good interface for
adding columns or changing input fields. The downside is that the data in WSS
is stored in a SQL database, but it isn't very usable for an end user to get
it out of this Database (You can read why here).
So... I was thinking of building a web service that gets the information out
of WSS and presenting it in rows (record sets) for Reporting Services.
My Question:
Could the ADO.Net extensibility of Reporting Services realize that I can get
data from a webservice? And if so, can I get a recordset from a web services
and use it in the same way as querying a SQL database with RS?
I would be very happy with some help on this subject.
Any thoughts are welcome...
Grt. M.VisserYou can build custom data provider and register it in RSReportServer.config
RS exposes a lightweight version of interfaces (IDbConnection, IDbCommand,
IDataReader).
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5c2q.asp
--
Alex Mineev
Software Design Engineer
This posting is provided "AS IS" with no warranties, and confers no rights
"Maarten Visser" <MaartenVisser@.discussions.microsoft.com> wrote in message
news:1DE68EBF-E54A-41B0-A0FB-EA8034807ACD@.microsoft.com...
> Hi All,
> I have to build a solution where end-users have to operate data input and
> reports. (This means that the GUI must be very user friendly).
> Because of this, I was thinking of using Windows Sharepoint Services (WSS)
> as a front-end for data input and using Reporting Services for generating
> reports on this data.
> WSS will make it easy for users, because it has a real good interface for
> adding columns or changing input fields. The downside is that the data in
WSS
> is stored in a SQL database, but it isn't very usable for an end user to
get
> it out of this Database (You can read why here).
> So... I was thinking of building a web service that gets the information
out
> of WSS and presenting it in rows (record sets) for Reporting Services.
> My Question:
> Could the ADO.Net extensibility of Reporting Services realize that I can
get
> data from a webservice? And if so, can I get a recordset from a web
services
> and use it in the same way as querying a SQL database with RS?
> I would be very happy with some help on this subject.
> Any thoughts are welcome...
> Grt. M.Visser
>