VMware VirtualCenter Server service fails with the error: cannot insert NULL into ("VPXADMIN"."VPX_ACCESS"."PRINCIPAL")

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• Starting the VMware VirtualCenter Server service fails when installed on an Oracle database.
• You see the error:
  
  cannot insert NULL into ("VPXADMIN"."VPX_ACCESS"."PRINCIPAL")
  
  
  
• In the vpxd.log file, located at C:\ProgramData\VMware\VMware VirtualCenter\Logs\, you see entries similar to:

mem> YYYY-MM-DD TIME.740-07:00 [10116 info 'Libs'] WMI_CreateWMIObjectInstance: failed to enum an instance of class: 0x00000001 0 'Win32_ComputerSystemProduct'
mem> YYYY-MM-DD TIME.740-07:00 [10116 info 'Libs'] Failed to get system information
mem> YYYY-MM-DD TIME.740-07:00 [10116 info 'Libs'] UUID: Failed to obtain host UUID
mem> YYYY-MM-DD TIME.786-07:00 [10116 error '[SSO][SsoAdminFacadeImpl]'] [RefreshSsoToken] AcquireToken exception: Authentication failed: Authentication failed
mem> YYYY-MM-DD TIME.786-07:00 [10116 error '[SSO]'] [UserDirectorySso] GetDefaultPrincipal NormalizationException: RemoteGetDomainNames RuntimeServiceFault exception: sso.fault.RuntimeServiceFault
mem> YYYY-MM-DD TIME.786-07:00 [10116 info '[SSO]'] [UserDirectorySso] GetDefaultPrincipal(, true)
mem> YYYY-MM-DD TIME.818-07:00 [10116 warning 'Default'] [VdbStatement] SQL execution failed: INSERT INTO VPX_ACCESS (ID, PRINCIPAL, ROLE_ID, ENTITY_ID, FLAG) VALUES (?, ?, ?, ?, ?)
mem> YYYY-MM-DD TIME.818-07:00 [10116 warning 'Default'] [VdbStatement] Execution elapsed time: 0 ms
mem> YYYY-MM-DD TIME.818-07:00 [10116 warning 'Default'] [VdbStatement] Diagnostic data from driver is HY000:1:1400:[Oracle][ODBC][Ora]ORA-01400: cannot insert NULL into ("VPXADMIN"."VPX_ACCESS"."PRINCIPAL")
mem> -->
mem> YYYY-MM-DD TIME.818-07:00 [10116 warning 'Default'] [VdbStatement] Bind parameters:
mem> YYYY-MM-DD TIME.818-07:00 [10116 warning 'Default'] [VdbStatement] datatype: 1, size: 4, arraySize: 0
mem> YYYY-MM-DD TIME.818-07:00 [10116 warning 'Default'] [VdbStatement] value = 132001
mem> YYYY-MM-DD TIME.818-07:00 [10116 error 'Default'] [Vdb::IsRecoverableErrorCode] Unable to recover from HY000:1400
mem> YYYY-MM-DD TIME.818-07:00 [10116 error 'Default'] [VdbStatement] SQLError was thrown: "ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-01400: cannot insert NULL into ("VPXADMIN"."VPX_ACCESS"."PRINCIPAL")
mem> --> " is returned when executing SQL statement "INSERT INTO VPX_ACCESS (ID, PRINCIPAL, ROLE_ID, ENTITY_ID, FLAG) VALUES (?, ?, ?, ?, ?)"
mem> YYYY-MM-DD TIME.989-07:00 [10116 warning 'win32vpxdOsLayer_win32'] [VpxUnhandledException] Win32 Exception (3765269347) detected at 000007fefd1c940d
mem> -->

Environment

VMware vCenter Server 5.1.x
VMware vCenter Server 5.5.x

Cause

This issue occurs because the PRINCIPAL column requires an entry on starting the VMware VirtualCenter Server service. When the entry is null, it prevents the VMware VirtualCenter Server service from starting up.

Resolution

To resolve this issue, you have to reinstall Single Sign-On and repoint the components. For more information on repointing the components, see Re-pointing and re-registering VMware vCenter Server 5.1 / 5.5 and components (2033620).

Additional Information

How to repoint and re-register vCenter Server 5.1 / 5.5 and components
VMware VirtualCenter Server サービスが次のエラーで起動しない： cannot insert NULL into ("VPXADMIN"."VPX_ACCESS"."PRINCIPAL")