Data Collection Error - Query Statistics Collection Set

• Marios Philippopoulos

  SSC Guru

  Points: 57190

  More actions

  August 5, 2009 at 9:11 am

  #203525

  I have Data Collection running on my SQL-2008 instance (version 10.0.2531), but I keep getting the following error in the Query Statistics Collection Set:

  Date8/5/2009 11:00:03 AM

  LogData Collection (Query Statistics)

  Log ID4698

  SourceQueryActivityUpload

  Collection Set Name

  Collection Item Name

  Status

  Runtime Execution Mode

  Start Time8/5/2009 11:00:03 AM

  Last Iteration Time

  Finish Time8/5/2009 11:00:03 AM

  Duration (ms)

  Operator

  Package Execution ID

  EventOnError

  Data Code-1071636471

  Message

  SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E57.

  An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E57 Description: "Arithmetic overflow error converting expression to data type int.".

  Anyone else seen this?

  __________________________________________________________________________________
  SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
  Persisting SQL Server Index-Usage Statistics with MERGE[/url]
  Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

• jsterrett

  SSC-Addicted

  Points: 459

  More actions

  December 17, 2009 at 11:04 am

  #1093634

  Yes, I also have this problem. This is a known bug with SQL Server 2008. You need CU#5 or greater.

  http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=484224