Post reply

Capturing and reporting execution errors

  • August 17, 2005 at 6:42 pm

    #165719

    We have a report subscription that emails an excel file every morning at 11am. For the past two mornings the subscription fails due to one of the parameters being null. This was caused by another programmer changing a stored procedure used in the report.

    What I'd like to know is how can I capture and report that the report failed to be produced. I have loaded the Execution Log sample reports and the relevant DTS package to load the logs is run every 5 mins. However, this error does not show up in the reports. The entries in the Report Server log file are as follows,

    ReportingServicesService!dbpolling!25a4!17/08/2005-11:00:12:: EventPolling processing 1 more items. 1 Total items in internal queue.

    ReportingServicesService!dbpolling!2c5c!17/08/2005-11:00:12:: EventPolling processing item e2d1a693-e9fc-44ce-970b-75d14f689c4c

    ReportingServicesService!library!2c5c!17/08/2005-11:00:12:: Schedule 3e2cd921-2554-44a5-be88-47d226097bb7 executed at 17/08/2005 11:00:12 AM.

    ReportingServicesService!schedule!2c5c!17/08/2005-11:00:12:: Creating Time based subscription notification for subscription: 07c2bf8a-97f4-4103-a425-25e05a643801

    ReportingServicesService!library!2c5c!17/08/2005-11:00:12:: Schedule 3e2cd921-2554-44a5-be88-47d226097bb7 execution completed at 17/08/2005 11:00:12 AM.

    ReportingServicesService!dbpolling!2c5c!17/08/2005-11:00:12:: EventPolling finished processing item e2d1a693-e9fc-44ce-970b-75d14f689c4c

    ReportingServicesService!dbpolling!25a4!17/08/2005-11:00:12:: NotificationPolling processing 1 more items. 1 Total items in internal queue.

    ReportingServicesService!dbpolling!2c5c!17/08/2005-11:00:12:: NotificationPolling processing item b4298569-a7dd-42dc-92e2-90805203b76c

    ReportingServicesService!processing!2c5c!17/08/2005-11:00:13:: e ERROR: There is no data for the field at position 0.

    ReportingServicesService!processing!2c5c!17/08/2005-11:00:13:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was thrown., ;

     Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type Microsoft.ReportingServices.ReportProcessing.ReportProcessingException was thrown.

    ReportingServicesService!notification!2c5c!08/17/2005-11:00:13:: e ERROR: Error occured processing notification. The property ‘nullable’ of report parameter ‘dteReport’ is set to false. However, the corresponding parameter (default) value is null or contains an empty string.

    ReportingServicesService!notification!2c5c!08/17/2005-11:00:13:: Notification b4298569-a7dd-42dc-92e2-90805203b76c completed.  Success: False, Status: The property ‘nullable’ of report parameter ‘dteReport’ is set to false. However, the corresponding parameter (default) value is null or contains an empty string., DeliveryExtension: Report Server Email, Report: Morning Debtors Trading, Attempt 0

    ReportingServicesService!dbpolling!2c5c!08/17/2005-11:00:13:: NotificationPolling finished processing item b4298569-a7dd-42dc-92e2-90805203b76c

    --------------------
    Colt 45 - the original point and click interface

  • August 22, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • July 3, 2008 at 8:41 am

    #837902

    I am not commenting on a solution, but I was going to post a request for this same issue. The only thing I can think is to set up an IIS package and load the reporting services log regularly. This is, in my mind, a complex, convoluted solution (considering the database exists). I will let you know if I can find a better way.

Viewing 3 posts - 1 through 2 (of 2 total)

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