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.
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • 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 ...

                        Related Products