RimFire007
asked on
Platform VMware ESXi 6.5 VCenter UI don`t open properly.
Our problem is:
Platform VMware ESXi 6.5
VCenter UI don`t open properly. It won`t show the list of virtual servers.
Please check the attached file
Below you see the error message which we found in VCenter Windows application logs:
An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) "ODBC error: (23505) - ERROR: duplicate key value violates unique constraint "pk_vpx_vm_virtual_device" ; Error while executing the query" is returned when executing SQL statement "INSERT INTO VPX_VM_VIRTUAL_DEVICE (ID, DEVICE_KEY, CONN_AL_GU_CONTROL_FLAG, CONN_CONNECTED_FLAG, CONN_START_CONNECTED_FLAG, CONN_STATUS, DEVICE_INFO_SUMMARY, DEVICE_INFO_LABEL, DEVICE_CONTROLLER_KEY, DEVICE_UNIT_NUMBER, DEVICE_TYPE, DEVICE_TEXT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
This all begun when one of virtual servers hung up. We tried forced shutdown, but it didn`t work and hung out too. After that we shut down all servers by normal way. Then we tried to restart whole VMWare platform, which also hung up. Then we cold boot the whole VMserver by power button. After that VMWare platform started normally and all virtual servers worked normally. Only VCenter UI don`t open properly. It won`t show the list of virtual servers.
Platform VMware ESXi 6.5
VCenter UI don`t open properly. It won`t show the list of virtual servers.
Please check the attached file
Below you see the error message which we found in VCenter Windows application logs:
An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) "ODBC error: (23505) - ERROR: duplicate key value violates unique constraint "pk_vpx_vm_virtual_device"
This all begun when one of virtual servers hung up. We tried forced shutdown, but it didn`t work and hung out too. After that we shut down all servers by normal way. Then we tried to restart whole VMWare platform, which also hung up. Then we cold boot the whole VMserver by power button. After that VMWare platform started normally and all virtual servers worked normally. Only VCenter UI don`t open properly. It won`t show the list of virtual servers.
Restart vCenter Server 6.5.
You can try the steps in the below article
https://communities.vmware.com/thread/547479
http://rvavmware.com/vcenter-appliance-503-service-unavailable-error/
https://communities.vmware.com/thread/547479
http://rvavmware.com/vcenter-appliance-503-service-unavailable-error/
ASKER
Andrew, reboot didn't help.
Murali, I have noticed 547479.
1. Bring the problematic VM down (I knew which one it is because of a specific device mentioned in the log output, but otherwise it could be a problem).
2. Unregister the VM on the host.
3. Bring the vpxd service back up.
4. Unregister the now "orphaned" VM on vCenter.
5. Re-register the VM on the host, and start it again.
Unregister the VM on the host.
Since this is a v-Center server the "Unregister the VM on the host" etc. needs to be done via vSphere 6.5 Web Client, right?
Remove Virtual Machines from vCenter Server in the vSphere Web Client is the correct procedure:
Bring the vpxd service back up
At this point we have vCenter down. At which server we should do this?
Unregister the now "orphaned" VM on vCenter
At this point we have vCenter down. Can't do this.
Furher more. We have Veeam installed using vCenter as the "source". To me it seems that above method guarantees the Backup setup / and the backups stays untouched.
Finally, this seems to be a bug within VMware. Have you noted that there is a fix / update covering this problem. I think we have vCenter 6.5b.
Thanks in advantage.
Murali, I have noticed 547479.
1. Bring the problematic VM down (I knew which one it is because of a specific device mentioned in the log output, but otherwise it could be a problem).
2. Unregister the VM on the host.
3. Bring the vpxd service back up.
4. Unregister the now "orphaned" VM on vCenter.
5. Re-register the VM on the host, and start it again.
Unregister the VM on the host.
Since this is a v-Center server the "Unregister the VM on the host" etc. needs to be done via vSphere 6.5 Web Client, right?
Remove Virtual Machines from vCenter Server in the vSphere Web Client is the correct procedure:
Bring the vpxd service back up
At this point we have vCenter down. At which server we should do this?
Unregister the now "orphaned" VM on vCenter
At this point we have vCenter down. Can't do this.
Furher more. We have Veeam installed using vCenter as the "source". To me it seems that above method guarantees the Backup setup / and the backups stays untouched.
Finally, this seems to be a bug within VMware. Have you noted that there is a fix / update covering this problem. I think we have vCenter 6.5b.
Thanks in advantage.
Latest Build is vCenter Server 6.5 U2b - update to it.
This is the Windows version ?
This is the Windows version ?
ASKER
Thanks Andrew
Have been at holidays but back in business on Monday.
Yes, it is Win Server. So I think the correct version to download is:
VMware vCenter Server and modules for Windows,
VMware-VIM-all-6.5.0-88155 20.iso
right?
Just mount the iso and start the the installer and it will notice that this is not a new installation but an update.
Have been at holidays but back in business on Monday.
Yes, it is Win Server. So I think the correct version to download is:
VMware vCenter Server and modules for Windows,
VMware-VIM-all-6.5.0-88155
right?
Just mount the iso and start the the installer and it will notice that this is not a new installation but an update.
That is correct.
ASKER
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The "vCenter – VdbODBCError – unique constraint pk_vpx_vm_virtual_device – fix" really did the trick. vCenter Server is up and running now. The problem really were the problematic USB disk which generated this error:
An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) “ODBC error: (23505) – ERROR: duplicate key value violates unique constraint “pk_vpx_vm_virtual_device” ;
Thank everybody for helping me.
An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) “ODBC error: (23505) – ERROR: duplicate key value violates unique constraint “pk_vpx_vm_virtual_device”
Thank everybody for helping me.