Skip to main content

VMware vCenter 5.5 getting Disconnected Sporadically


I recently experienced an issue with vCenter 5.5 was getting disconnected sporadically. vCneter was running on windows 2012 server. I was able to see following errors in windows logs.




vCenter Logs were showing following errors - 

         2018-08-18T01:30:03.630-04:00 [11432 error 'Default' opID=92132b4] An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) ODBC error: (08S01) - [Microsoft][SQL Server Native Client 11.0]TCP Provider: The specified network name is no longer available.
        2018-08-18T01:30:03.630-04:00 [11432 error 'Default' opID=92132b4] An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) ODBC error: (08S01) - [Microsoft][SQL Server Native Client 11.0]TCP Provider: The specified network name is no longer available.
        2018-08-19T19:28:31.801-04:00 [06368 warning 'Default' opID=40159464] [VdbStatement] Diagnostic data from driver is 08S01:1:64:[Microsoft][SQL Server Native Client 11.0]TCP Provider: The specified network name is no longer available.

 I worked with VMware support and they found out that vCenter failure was due to a disconnect of vCenter from the database. It is a known issue with VMware vCenter Server regarding these extract disconnects and is fixed with 5.5 Update 3i.

If you don't want to upgrade your vCenter, you can mitigate the issue by cleaning up the database. The largest factor that slows the database down is your events tables. I recommend taking a backup (for auditing purposes in case you need to go back and look at a specific event) and then truncate the events using the instructions below.

1. Stop the vCenter Server Service (Must do).
2. Take the Full backup of DB (Must do).
3: Execute following SQL Queries:

alter table VPX_EVENT_ARG drop constraint FK_VPX_EVENT_ARG_REF_EVENT, FK_VPX_EVENT_ARG_REF_ENTITY

alter table VPX_ENTITY_LAST_EVENT drop constraint FK_VPX_LAST_EVENT_EVENT

truncate table VPX_ENTITY_LAST_EVENT

truncate table VPX_EVENT

truncate table VPX_EVENT_ARG

alter table VPX_EVENT_ARG add constraint FK_VPX_EVENT_ARG_REF_EVENT foreign key(EVENT_ID) references VPX_EVENT (EVENT_ID) on delete cascade, constraint FK_VPX_EVENT_ARG_REF_ENTITY foreign key (OBJ_TYPE) references VPX_OBJECT_TYPE (ID)

alter table VPX_ENTITY_LAST_EVENT add constraint FK_VPX_LAST_EVENT_EVENT foreign key(LAST_EVENT_ID) references VPX_EVENT (EVENT_ID) on delete cascade
  
4. Restart the vCenter Server Service.
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Check Up Time of ESXi Host or Virtual Machine from vCenter Server

To check up time of ESXi host from vCenter server - Logon to vCenter Server -  If using C# (fat) client - click on cluster - on right side pane click on Hosts - select the up time option by right clicking on the header. The column will be added at the end. You can drag and drop column to place it in your view. If using HTML client - click on cluster - on right side pane click on Hosts - select the up time attribute from show/hide column by clicking on the header  If using web (Flash)  client - click on cluster - on right side pane click on related objects - hosts - right click on the header to show/hide column - click on up time attribute Similarly,  you can check the up time for a virtual machine by clicking on the virtual machine tab instead of host tab, but only caveat  is vCenter gives you up time of a virtual machine according to reboots performed from the vCenter. So, rather than rebooting server fr...
Post a Comment
Read more

Upgrading HPE 3PAR SRA (Storage Replication Adapter) from 6.1 to 6.5

Here  are the high level step to upgrade the HPE 3PAR Storage Replication Adapter (SRA) - If old SRA is visible in add remove programs -  View certificates for old array (that will be removed after migration) from SRM server using following path and TPDsrm utility -        C:\Program Files\VMware\VMware Site Recovery manager\Storage\SRA\3Parinsrv>              TPDsrm.exe viewcert Uninstall old 3PAR SRA from SRM server using uninstall program feature. Reboot the SRM server. Install new 3PAR SRA using the .exe file provided by vendor. Check if you can see the new SRA in Program list. If so, reboot the SRM server.  Validate certificates for new array using following path and command on SRM server -        C:\Program Files\VMware\VMware Site Recovery manager\Storage\SRA\3Parinsrv>               TPDsrm.exe validatecert -s...
Post a Comment
Read more

VMware NSX Manager Not Showing up in vCenter inventory

The NSX manager was deployed and configured correctly. It was showing up in vCenter, when I configured it. After few days when I checked suddenly NSX  disappeared from the vCenter inventory. I logged in to NSX manager and it was all fine. It was showing as connected with its respective vCenter but wasn't showing up in the vCenter.  I tried to restart the vCenter services and vCenter server that did not resolve the issue. Easiest fix that worked with me for this issue is to restart the NSX manager and then it shows up back in vCenter.  
Post a Comment
Read more