Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

vCenter Server using an Oracle database fails when registering a virtual machine with a VMDK file on a missing datastore (1032726)

Symptoms

  • vCenter Server using an Oracle database fails when registering a virtual machine with a VMDK file on a missing datastore
  • vCenter Server using an Oracle database may also fail when executing a Site Recovery Manager failover test

  • The vCenter Server logs contain an error similar to:

    [2010-12-03 10:49:02.511 05260 error 'App'] An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) "ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-01400: cannot insert NULL into ("VPXADMIN"."VPX_VM_FLE_FILE_INFO"."NAME")

    " is returned when executing SQL statement "INSERT INTO VPX_VM_FLE_FILE_INFO (VM_ID, KEY_VAL, NAME, FILE_SIZE, TYPE) VALUES (?, ?, ?, ?, ?)"

Resolution

This issue occurs when vCenter Server receives virtual machine configuration information from the host. The host passes an empty string for the VMDK's missing datastore. Oracle treats an empty string as NULL, and therefore violates a "NOT NULL" column constraint when inserting this data into the database, which causes vCenter Server to fail.
 
To resolve this issue, relax the column restraint and allow NULL values by executing this query against the vCenter Server database:

ALTER TABLE VPX_VM_FLE_FILE_INFO MODIFY NAME NULL;

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 8 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 8 Ratings
Actions
KB: