Error - "There is already an object named 'VPXV_EVENT_1' in the database"

Products

• VMware

Issue/Introduction

The purpose of this article is to resolve error - "There is already an object named 'VPXV_EVENT_1' in the database".

Symptoms:

• Migrating from Windows vCenter Server 6.0 to the vCenter Server Appliance 6.5 fails with:
  
  Error while exporting events and tasks data: pyodbc.ProgrammingError: ('42S01', "[42S01] [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named 'VPXV_EVENT_1' in the database. (2714) (SQLExecDirectW)")
  
• The UpgradeRunner.log has the following error message:
  
  2016-12-20T11:22:24.137Z INFO upgrade.states.component_states vcdb:Export: PermanentError: Error while exporting events and tasks data: pyodbc.ProgrammingError: ('42S01', "[42S01] [Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named 'VPXV_EVENT_1' in the database. (2714) (SQLExecDirectW)")

Note: The UpgradeRunner.log can be found in /var/log/vmware/upgrade.

Cause

This issue happens if the first attempt to migrate fails at the database export. The initial failure could be due to a defect or manual interruption.

Resolution

To resolve this issue perform the upgrade again.

When the exception is caught, the database errors are automatically corrected. The next attempt will upgrade successfully.