When trying to patch a Linux server, you might get a message saying Recommended Action: Investigate Issue and hence are not able to patch the server.
The error will look like the following screenshot. The recommended action is Investigate Issue:
To resolve the issue, follow these steps on the VCM database:
Run this SQL query to know the
machine_id
for which it shows Investigate Issue:select machine_id, machine_name from ecm_dat_machines where machine_name = '<Machine Name>'
The machine name is the name of the service creating issues.
Update the timestamp for that
machine_id
value using the following query:update ecm_sysdat_imd_machine_timestamp_xref set timestamp = 0 where machine_id = <>
Carry out another assessment on that machine, and it will tell you that patches are required.