locked
Data-driven subscription shows 0 errors when report execution fails - SSRS 2012 SP2 RRS feed

  • Question

  • User1187741373 posted

    Hello, I'm using SRSS 2012 Microsoft SQL Server 2012 - 11.0.5058.0 (X64) -May 14 2014 18:34:29 - Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    I've set up data-driven subscription, but my report failed to execute because of error in database query getting data from database. This error was logged in Report server log file, but my subscription status shows zero errors. "Done: 1 processed of 1 total; 0 errors."

    Actual database error was "Arithmetic overflow error converting float to data type numeric.". See log bellow.

    I've tried to create simple report with single dataset returning database error.

    ALTER PROCEDURE dbo.test
    AS
     RAISERROR (50005, 10, 1, N'abcde'); 
    GO

    Same thing happens, data-driven subscription shows status "Done: 1 processed of 1 total; 0 errors."

    When I've tried to set up regular subscription (not data-driven) it shows status correctly: "Failure sending mail: An error has occurred during report processing.Mail 
    will not be resent."

    Also I've noticed that status logged in ExecutionLogStorage table is rsProcessingAborted.I've tried same scenario on SSRS 2005 and it shows status correctly "Done: 1 processed of 1 total; 1 errors."

    Is this bug in SSRS 2012? Can anybody help me with this issue please? Thank you.

    processing!WindowsService_16!341c!10/29/2014-11:08:07:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'Location'. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting float to data type numeric.
    The statement has been terminated.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues)
       --- End of inner exception stack trace ---;
    processing!WindowsService_16!341c!10/29/2014-11:08:37:: e ERROR: An exception has occurred in data set 'Location'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'Location'. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting float to data type numeric.
    The statement has been terminated.
    processing!WindowsService_16!341c!10/29/2014-11:08:37:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
    processing!WindowsService_16!2ff4!10/29/2014-11:08:37:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'Location'. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting float to data type numeric.
    The statement has been terminated.
       --- End of inner exception stack trace ---;
    processing!WindowsService_16!2ff4!10/29/2014-11:09:04:: w WARN: Data source 'RavenDS': Report processing has been aborted.
    processing!WindowsService_16!2ff4!10/29/2014-11:09:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'Location'. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting float to data type numeric.
    The statement has been terminated.
       --- End of inner exception stack trace ---;
    library!WindowsService_16!2ff4!10/29/2014-11:09:04:: w WARN: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'Location'. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting float to data type numeric.
    The statement has been terminated.
    library!WindowsService_16!2ff4!10/29/2014-11:09:04:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
    emailextension!WindowsService_16!2ff4!10/29/2014-11:09:04:: e ERROR: Error sending email. Exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'Location'. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting float to data type numeric.
    The statement has been terminated.
    notification!WindowsService_16!2ff4!10/29/2014-11:09:04:: i INFO: Notification 90154b70-884c-48a7-b36e-18872926dfc8 completed.  Success: True, Status: Failure sending mail: An error has occurred during report processing.Mail will not be resent., DeliveryExtension: Report Server Email, Report: ApplicationSummary, Attempt 0

    Monday, November 3, 2014 12:15 PM

All replies

  • User-734925760 posted

    Hi,

    According to the error message, I searched some articles, please refer to check srsrp.log when the report is run, and look in smsdbmon.log to see if the site is having any issues in the database.

    For more information, please refer to the links below:

    https://social.technet.microsoft.com/Forums/en-US/e0fed0b4-e2a6-4ca5-a588-bd883406eb7b/most-reports-work-some-display-an-error

    http://documents.software.dell.com/DOC18050

    Hope it's useful for you.

    Best Regards,

    Michelle Ge

    Tuesday, November 4, 2014 3:22 AM
  • User1187741373 posted

    Hi, thank you for your reply. I'm not able to find those logs on my machine or server we are using for development.

    We are using Windows 7 SP1 64b on development machines and Windows server 2008 R2 on testing server. It seems like srsrp.log file is from System Center 2012 Configuration Manager. We don't use it on our machines.

    As you can see in my original post, I know exactly why report fails. It is database query error (conversion error in my real application). As a test case scenario I've also wrote simple database procedure which throws error (RAISERROR(...)).

    Problem I'm having is that this database error is not reported in UI in data-driven subscription status, which shows 0 errors, but report execution failed.

    If anybody else has other suggestions, it will be helpful. Thank you.

    Tuesday, November 4, 2014 4:49 AM