I have a report working that uses the data extension, but Report Services generates the following error when it tries to send an email with the report in it.

Failure sending mail: An error has occurred during report processing.

My SMTP config seems to be OK because I can subscribe and receive emails from other reports that are based on SQL data sources.

Any suggestions?
Jeff Richardson
Promega Biosciences, Inc.

Hi Jeff,
I have had a very productive week end and manage to solve the subscription problem as well as discover what could go wrong with integrated security.

To get the subscription to work properly you will have to modify the rssrvpolicy.config file and instead of using the $AppDirUrl$ keyword as stated in our documentation, you should use the absolute path to the Enesys RS Data Extension dll as in the following example :

              <!-- Enesys RS Data Extension - BEGIN -->
              <CodeGroup
                  class="UnionCodeGroup"
                  version="1"
                  PermissionSetName="FullTrust">
                <IMembershipCondition
                    class="UrlMembershipCondition"
                    version="1"
                    Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin\Enesys.ReportingServices.SpExtension2005.dll"
                            />
              </CodeGroup>
              <!-- Enesys RS Data Extension - END -->


The fact is that when the report is run through subscription, the $AppDirUrl$ syntax will not resolved to the correct path and the extension will not be given the necessary permissions.

Thanks you for pointing out this problem. We apologize for the inconvenience.

Regards,

PD: I will clarify the credentials matters in your other post...

---

Frederic LATOUR
ENESYS

Hi Jeff,
There are some known problems with email subscription incorporating reports (not specific to Enesys RS Data Extension) that may happen in some situations.
Here is a newsgroup post on the subject : Service Account and Subcriptions
as well as a kb article : http://support.microsoft.com/default.aspx?scid=kb;en-us;331951
Could your problem be related to what is explained there?
Does the email subscription (incorporating a report) works for you with a SQL Report?
Also you can send me your last "ReportServerService_timestamp" logfile located
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles
 so that I can have a look. The reason of the failure should be logged in it.
You can mail the file at support@enesys.fr. If you zip the file, please add a fake extension (eg: file.zip.aaa).
Regards,

---

Frederic LATOUR
ENESYS