Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
You cannot upload the Utility Information data collection set in SQL Server 2008 R2
Article ID: 980497 - View products that this article applies to.
Consider the following scenario:
Violation of PRIMARY KEY constraint 'PK_sysutility_cpu_memory_related_info_internal_clustered'. Cannot insert duplicate key in object 'snapshots.sysutility_ucp_cpu_memory_configurations_internal'.
Violation of PRIMARY KEY constraint 'PK_sysutility_volumes_info_internal'. Cannot insert duplicate key in object 'snapshots.sysutility_ucp_volumes_internal'.
To resolve this issue, you must delete the Data Collector’s cached files. To locate the Data Collector cache directory and to delete the cache files, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To work around this issue, use one of the following methods.
Do not right-click the Utility Information collection set or click Collect and upload now.
Do not configure the collection set to run on a schedule.
The Utility Information collection set should be executed only by the “Sysutility_mi_collect_and_upload” SQL Server Agent job.
Article ID: 980497 - Last Review: May 10, 2010 - Revision: 1.1