When viewing any of the Monitor Agent install, uninstall, and upgrade policies, the following error occurs.
The program that this Agent installation refers to could not be located. Please select another program
This behavior may occur if certain item references in the database have been deleted. It is not yet known what causes these rows to be deleted. Neither running a repair on Monitor Solution for Servers or "aexconfig /configure" on any .config file resolves the issue.
Refer to the attached SQL script which manually inserts the missing rows into the dbo.ItemReference table. First, review the respective operating system's policy type and query the dbo.ItemReference table to see if the entries exist. If they do not, run the below insert commands. You may also choose to run the entire SQL script; If any of the rows already exist, the insert command for that row will simply fail.
Monitor Solution for Servers 7.x
SQL script to replace missing rows in the dbo.ItemReference table