Xen VMs Tab will be empty due to disk name is lengthy

Xen VMs Tab will be empty due to disk name is lengthy



Xen discovery issue:  Virtual Machines tab will be empty in the host snapshot page due to the Disk name is exceeded more than 100, and the below exception will be found in stderr log

Caused by: java.sql.SQLException: Batch entry 21 INSERT INTO XenSRVDIProps (VDI_ID,UUID,NAME,SR_ID,LOCATION,MANAGED,VIRTUAL_SIZE_MB,PHYSICAL_UTIL_MB,SHARABLE,TYPE) VALUES ('50000000697','1593ad2c-f24a-4ab6-8432-4febdf0bac46','en_windows_server_2008_r2_standard_enterprise_datacenter_and_web_debug_checked_build_x64_dvd_408075.iso','50000000627','en_windows_server_2008_r2_standard_enterprise_datacenter_and_web_debug_checked_build_x64_dvd_408075.iso','1','2880','2880','0','user') was aborted.  Call getNextException to see the cause.
 

Please follow the below steps to fix

1. delete both master and slave hosts
2. run the below queries

PGSQL:
  • ALTER TABLE XenSRVDIProps ALTER NAME TYPE VARCHAR(450)
  • ALTER TABLE XenSRVDIProps ALTER LOCATION TYPE VARCHAR(450)
MSSQL:
  • ALTER TABLE XenSRVDIProps ALTER COLUMN NAME VARCHAR(450)
  • ALTER TABLE XenSRVDIProps ALTER COLUMN LOCATION  VARCHAR(450)

3. restart opmanager service and add the master xen.

          • Related Articles

          • Find the missing VMs and Hosts - HyperV and Xen

            After the HyperV discovery if the VMs are missing, query the below table and check select * from hyperventitymomap where entity_type = 'HyperV-VM'; select * from hyperventitymomap where entity_type = 'HyperV-Host'; When the MOID is -4, check whether ...
          • Configuring threshold values for disk partitions in OpManager

                                                                                  For the Servers, we discover Disk utilization using both WMI and SNMP. Also, we monitor the drive partitions that are available in those Servers. The customers found this very ...
          • Find the missing VMs and Hosts - VMWare

            After the vcenter discovery if the VMs and Hosts are missing, query the below table and check select * from vwentitymomapping where entity_type = 'VirtualMachine'; select * from vwentitymomapping where entity_type = 'HostSystem'; When the MOID is -4, ...
          • Server Disk utilization Formula(SNMP)

            OpManager uses HostResources.mib and its OIDs to calculate the disk utilization. The OIDs(and the responses) that you have to check are 1).1.3.6.1.2.1.25.2.3.1.2 :hrStorageType 2).1.3.6.1.2.1.25.2.3.1.4 : hrStorageAllocationUnits ...
          • To test Xen connectivity

            If xen discovery is failed,  Follow the steps: 1. Download the attached XenSessionCheck.zip file and extract here in \OpManager\ 2. Open the command prompt, go to \OpManager\ and execute VirtualXenExe.bat file by giving xen master details. For ...