Select the product you need help with

You cannot upload the Utility Information data collection set in SQL Server 2008 R2

Article ID: 980497 - View products that this article applies to.

SYMPTOMS

Consider the following scenario:

You have a computer that is running Microsoft SQL Server 2008 R2.
You open the SQL Server Management Studio tool, and then right-click Utility Information data collection set.
You click Collect and upload now, or you change the collection set properties.

In this scenario, you cannot upload the Utility Information data collection set. Additionally, you receive one of the following error messages.

Message 1

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'.

Message 2

Violation of PRIMARY KEY constraint 'PK_sysutility_volumes_info_internal'. Cannot insert duplicate key in object 'snapshots.sysutility_ucp_volumes_internal'.

Back to the top | Give Feedback

RESOLUTION

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:

Run SQL Server Management Studio tool, and then connect to the instance of SQL Server 2008 R2 in which the error occurs.
Expand the Management folder, right-click Data Collection, and then click Properties.
If a directory is specified as a Cache directory directory, the directory that is specified is the location of the Data Collector cache files.

If a directory is not specified as a Cache directory directory, the default cache directory is the local temporary directory of the account that runs the collection set. This account may be the SQL Server Agent service account. For example, the collection set is run by an account that is named “sqlacct” in Windows Server 2008. In this example, the temporary directory of this account is located in a path that resembles the following:
C:\Users\sqlacct\AppData\Local\Temp
Find all files that have a “.CACHE” file name extension, and then delete these files.