Upgrading or installing vCenter Server 6.0 with an external SQL Server database fails

Products

• VMware vCenter Server
• VMware vSphere ESXi

Issue/Introduction

• Upgrading vCenter Server 5.x with an external SQL Server database to vCenter Server 6.0 fails.
• In the VMware-VCS-logs-timestamp_number/vcsUpgrade/vcdb_req.err log file, you see the error:
  
  ERROR! The following jobs should be cleaned up
  
  
• A fresh installation of vCenter Server 6.0 with an existing external SQL Server database fails.
• In the installation wizard, you see the error:
  
  The specified @job_name ('Past Day stats rollupVCDB') does not exist

This issue occurs when you modify the vCenter Server database.

For example:

• When you move the vCenter Server database to a different server.
• When you change the login details, such as the ODBC DSN user login, for the database to which DSN points.

Environment

VMware vCenter Server 6.0.x
VMware vCenter Server 5.1.x
VMware vSphere ESXi 6.0
VMware vCenter Server 5.0.x
VMware vCenter Server 5.5.x

Resolution

Before you resolve this issue:

• Verify that your vCenter Server user has all permissions, as listed in the Configure Microsoft SQL Server Databases section in the vSphere Installation and Setup Guide.
• Backup the vCenter Server database.

To resolve this issue, remove the jobs created by a user different from your vCenter Server user.

1. Log in to SQL Server Management Studio with your vCenter Server user name, that is the user name specified in the ODBC DSN.
   
2. Open a new query window in vCenter Server database.
   
3. Run this query to list all jobs created by a different user.
   
   SELECT distinct j.name
FROM msdb.dbo.sysjobs j
JOIN msdb.dbo.sysjobsteps t
ON j.job_id = t.job_id
AND t.database_name = db_name()
LEFT JOIN msdb.dbo.sysjobs_view v
ON v.name = j.name
WHERE v.name IS NULL;

   
4. Log in to SQL Server Management studio as an administrator. For example sa.
   
5. Run this query for all the job name obtained from step 3:
   
   exec msdb.dbo.sp_delete_job @job_name = N'job name'
   
   

For translated versions of this article, see:

外部の SQL Server データベースを使用する環境で、vCenter Server 6.0 のインストールやアップグレードに失敗する (2111374)