Data-driven Subscription doesnt send out an email but job history shows its successfull

• xXShanXx

  Right there with Babe

  Points: 731

  More actions

  October 31, 2014 at 8:54 am

  #300703

  Hi All

  Please give me some advice about this Data-driven Subscription runs every hour misses out once or twice a day, but the subscription job history shows it ran sucessfull but it doesnt trigger the e-mail out.

  I got ReportingServerService LogFiles and can seethe error

  Timeout error :

  ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'SSRSSRV02_interface'., ;

  Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'SSRSSRV02_interface'. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

  Email Error:

  ReportingServicesService!notification!3!10/30/2014-22:38:33:: Notification faac99a8-48a2-4262-b699-f798589a2ecc completed. Success: False, Status: Failure sending mail: An error has occurred during report processing., DeliveryExtension: Report Server Email, Report: 9105 - ALERT - Negative Margin by Destination Account, Attempt 0

  * If its a failure, then why did it update the subscription job history as success ?

  * Is there a way to monitor this log files and alert when it fails ?

  So - Kindy advice me how can I proceed my findings on this.

  Thanks a lot in advance.