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

This article has been archived. It is offered "as is" and will no longer be updated.
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'.
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:
  1. Run SQL Server Management Studio tool, and then connect to the instance of SQL Server 2008 R2 in which the error occurs.
  2. Expand the Management folder, right-click Data Collection, and then click Properties.
  3. 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
  4. Find all files that have a “.CACHE” file name extension, and then delete these files.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
WORKAROUND
To work around this issue, use one of the following methods.

Method 1

Do not right-click the Utility Information collection set or click Collect and upload now.

Method 2

Do not configure the collection set to run on a schedule.
MORE INFORMATION
The Utility Information collection set should be executed only by the “Sysutility_mi_collect_and_upload” SQL Server Agent job.
Properties

Article ID: 980497 - Last Review: 12/12/2015 03:32:06 - Revision: 1.1

Microsoft SQL Server 2008 R2 Datacenter, Microsoft SQL Server 2008 R2 Developer, Microsoft SQL Server 2008 R2 Enterprise, Microsoft SQL Server 2008 R2 Standard, Microsoft SQL Server 2008 R2 Web, Microsoft SQL Server 2008 R2 Workgroup

  • kbnosurvey kbarchive kbsurveynew kbqfe kbhotfixserver KB980497
Feedback