December 11, 2011 at 4:30 am
The jobs for System Data Collection Sets Query statistics collection and Server Activity collection failing with the following errors:
Date 12/11/2011 12:26:59 PM
Log Data Collection (Query Statistics)
Log ID 462688
Source Query Statistics
Collection Set Name Query Statistics
Collection Item Name
Status Error
Runtime Execution Mode Collection
Start Time 12/11/2011 12:26:59 PM
Last Iteration Time
Finish Time 12/11/2011 12:27:00 PM
Duration (ms) 1
Operator TEST\test
Package Execution ID
Event
Data Code
Message
Waiting on a kernel object(s) failed. Inner Error ------------------>
The handle is invalid.
Date 12/11/2011 12:58:24 PM
Log Data Collection (Server Activity)
Log ID 462693
Source Server Activity
Collection Set Name Server Activity
Collection Item Name
Status Error
Runtime Execution Mode Collection
Start Time 12/11/2011 12:58:24 PM
Last Iteration Time
Finish Time 12/11/2011 12:58:24 PM
Duration (ms) 0
Operator TEST\test
Package Execution ID
Event
Data Code
Message
Waiting on a kernel object(s) failed. Inner Error ------------------>
The handle is invalid.
The Environment is as follows:
Microsoft SQL Server 2008 (SP1) - 10.0.2808.0 (X64) Jan 6 2011 10:26:14 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)
After the above error the jobs gets disabled.
The other job for disk usage works fine. And other custom jobs are also working fine.
If anyone know's the solution for this issue, please update me as soon as possible.
Thanks and regards,
Atiq Rahman
December 12, 2011 at 6:44 am
looks like this is a known issue, addressed in a CU / SP2: http://connect.microsoft.com/SQLServer/feedback/details/585210/sql-server-2008-data-collection-execmasterpackage-timeout
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply