[YYYY-MM-DDTHH:MM:SS 'SingleVMHardwareScanTask.SingleVMHardwareScanTask{726}' 139794540906240 ERROR] [singleVMHardwareScanTask, 365] VDB error while saving compliance state "ODBC error: (23503) - ERROR: insert or update on table "vci_vmhw_scanresults" violates foreign key constraint "fk_vci_sres_ref_versions"; Error while executing the query" is returned when executing SQL statement "INSERT INTO VCI_VMHW_SCANRESULTS(additional_details, host_vmhw_id, scanh_id, target_uid, target_vmhw_id) VALUES (?, ?, ?, ?, ?)"
[YYYY-MM-DDTHH:MM:SS 'SingleVMHardwareScanTask.SingleVMHardwareScanTask{726}' 139794540906240 ERROR] [singleVMHardwareScanTask, 432] Scanning error for VM VMNAME(vm-id): Error while scanning: VDB error while saving compliance state "ODBC error: (23503) - ERROR: insert or update on table "vci_vmhw_scanresults" violates foreign key constraint "fk_vci_sres_ref_versions"; Error while executing the query" is returned when executing SQL statement "INSERT INTO VCI_VMHW_SCANRESULTS(additional_details, host_vmhw_id, scanh_id, target_uid, target_vmhw_id) VALUES (?, ?, ?, ?, ?)"
As a workaround, please update the VM Hardware version manually.
Below are the steps to update the virtual hardware on multiple virtual machines:
You can upgrade virtual hardware on multiple virtual machines in a single operation using the following steps:
For more details, please refer the below KB article:
Upgrading a virtual machine to the latest hardware version (multiple versions) .