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

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

book

Article ID: 328222

calendar_today

Updated On:

Products

VMware vCenter Server

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.