After updating my Virtual Center Server 2.5 from U2 to U3 (now Build 119598) my Update Manager had a problem to scan my esx 3.5 U2 host.
With U2 everything works ok. During the update there where not problems.
I also have removed the Update Manager from my server and also deleted the VIM_UMDB.* files and installed the update manager new.
But the problem still exists. Anyone seen this behaviour?
Here is the error message from Update Manager:
SQL execution failed: INSERT INTO VCI_SCANHISTORY_TARGETS (scanh_id, update_id, target_uid, target_status, failurereason) VALUES (?, ?, ?, ?, ?)
Bind parameters:
datatype: 1 size: 4datatype: INT32 size: 4Value: 1
datatype: 1 size: 4datatype: INT32 size: 4Value: 33878292
datatype: 11 size: 12
datatype: 1 size: 4datatype: INT32 size: 4Value: 1
datatype: 11 size: 0
Database error (vdb) "ODBC error: (23000) - [SQL Native Client][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_VCI_SHISTVMS_REF_SIG". The conflict occurred in database "VIM_UMDB", table "dbo.VCI_UPDATES", column 'ID'." is returned when executing SQL statement "INSERT INTO VCI_SCANHISTORY_TARGETS (scanh_id, update_id, target_uid, target_status, failurereason) VALUES (?, ?, ?, ?, ?)"
Task execution has failed: SingleHostScan : Database error (vdb) "ODBC error: (23000) - [SQL Native Client][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_VCI_SHISTVMS_REF_SIG". The conflict occurred in database "VIM_UMDB", table "dbo.VCI_UPDATES", column 'ID'." is returned when executing SQL statement "INSERT INTO VCI_SCANHISTORY_TARGETS (scanh_id, update_id, target_uid, target_status, failurereason) VALUES (?, ?, ?, ?, ?)"
A subTask finished: VciHostScanTask
SerializeToVimFault fault:
(integrity.fault.VcIntegrityFault) {
dynamicType = <unset>,
msg = ""
}
Converted fault:
(vim.fault.ExtendedFault) {
dynamicType = <unset>,
faultTypeId = "com.vmware.vcIntegrity.VcIntegrityFault",
data = (vim.KeyValue) [
(vim.KeyValue) {
dynamicType = <unset>,
key = "dynamicType",
value = "",
},
(vim.KeyValue) {
dynamicType = <unset>,
key = "dynamicProperty",
value = "",
}
],
msg = ""
}
VciTask , type: com.vmware.vcIntegrity.ScanTask }: Setting VC task state to: error
Task finished...
Task finished...
Removing task ScanTask that imposed Alpine load:2, new load: 3
Removing task VciHostScanTask that imposed Alpine load:1, new load: 2
Removing task ChainedTaskContainer that imposed Alpine load:0, new load: 2
Removing task SingleHostScanTask that imposed ESX load:3 for esx host-8, new load: 0 that imposed Alpine load:2, new load: 0
The number of tasks: 0
Filter removed for : session[B6BDD407-2D70-40E7-9FB6-A5FCA9AC7362]053D284A-35DE-4838-A62E-EB8AB596F450
Delete VC task from database: task-212
No changes to firewall configuration for: updateManager
Internal Scheduled Tasks Manager Timer callback...
InvokeCallbacks. Total number of callbacks: 4
Internal Scheduled Tasks Manager Timer callback end of this timer slice.....Rescheduling after 300000000 microseconds
Patch store disk free space is: 15263113216
Temp directory disk free space is: 15263113216
