SSRS 2005 Report Subscription problem

Question

SSRS 2005 Report Subscription problem

Ludo-ZX7R

SSCrazy

Points: 2882
More actions
October 16, 2009 at 7:32 am

#211147

Hi
I have created some reports and would like them to be run and e-mail to key people in our organisation.
I have therefore created a Subscription.
1-
If I just include the link in the e-mail, I receive the e-mail. However when I click on the link I get the following error:
The type Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement ITemporaryStorage or could not be found
2-
When I choose to include the report file (Excel format) in the e-mail I receive no e-mail and the Subscription fails with the following error:
Failure sending mail: An error has occurred during report processing.
Does anybody have any idea of what's going wrong here? ... apart from me of course. 🙂
Cheers
Ludo

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

nahk.fussuy Ten Centuries Points: 1042 More actions · Answer 1

I've never seen this problem before, but have you tried a few of the below troubleshooting steps:

1. Create a "Hello World" report and try sending that as a subscription ? do not set to run from a snapshot or anything like that.

2. What does the URL look like in your email ? and where does the error come from? Internet explorer? or email client? I have had problems with firefox and reporting services, are you using IE ?

3. Can you export the report normally as excel without error?

a url from one of my reports looks like:

The report is accessible at the following address:

http://zebdeesql01/reportserver?%2fMRS+Reports%2fMRS+-+Data+load+Status&ShowExtraDebugInfo=1&rs%3aParameterLanguage=en-IE

Ludo-ZX7R SSCrazy Points: 2882 More actions · Answer 2

Hi

My report works fine when I call it directly from http://<server>/reportserver. I can see the results and save them in an Excel file locally.

When I get the e-mail with the link I get this:

http://<server>/reportserver?%2fCHO+Hire+Duplicate%2fCHO+Hire+Duplicate&CaseType=Open&ReceivedEndDate=01%2f12%2f2009+00%3a00%3a00&ReceivedStartDate=01%2f01%2f2009+00%3a00%3a00&rs%3aParameterLanguage=en-GB

When I click on this link, the error I mentionned in my previous post is displayed in Internet Explorer.

Does that help?

Cheers

Ludo

nahk.fussuy Ten Centuries Points: 1042 More actions · Answer 3

Ok , if report usually works ok, but fails with the link....

I note you have some dates in the parameters you are passing, are these datetime datatype? always a good way to right royally fark things up when some subsystem decides to switch it between European and US conventions.

If you remove the datetime parameters (or switch them to use a default) does it start working ok?

Ludo-ZX7R SSCrazy Points: 2882 More actions · Answer 4

I'm ashame to admit it but ... even running the report normaly now fails with the same error.

Let me check what changes I have made to get this far and get them working again.

Damn!!

Ludo

nahk.fussuy Ten Centuries Points: 1042 More actions · Answer 5

😛 heeheee ahh ever changing sands farkin up the troubleshooting!!

Ludo-ZX7R SSCrazy Points: 2882 More actions · Answer 6

Hi

Phew what a nightmare but I got everything working now.

1-

In IIS my default webserver page was not setup properly which prevented all the reports from being run successfully.

2-

For the scheduling to work, the database source connection must be set to "Credentials stored securely on the report server".

You have to enter a Login Name and Password of your choice.

3-

Create a new login on the Database Server (the one accessed by the Data Source above) which match the Login/Password.

Et Voila!

I can now schedule my reports and include a link, an Excel file, ... all done!! :w00t:

Thanks again for your help guys

Ludo