PM-31407-19-200928:

The cruncher at the time of processing the HW/SF inventory of both desktop and server computers generated a primary key violation error with respect to the AAM_LOCAL_GROUP table, which did not allow obtaining the updated inventories of the computers that contained accents in the fields (domain, name) of the AAM_LOCAL_GROUP table and the name field in the AAM_DEVICE_PRINTER table.

Message : Violation of UNIQUE KEY constraint ‘UX_AAM_LOCAL_GROUP’. Cannot insert duplicate key in object ‘dbo. AAM_LOCAL_GROUP’.

Adjustments are made to the collate of the fields (domain, name) of the AAM_LOCAL_GROUP table and the name field in the AAM_DEVICE_PRINTER table, so that inventories that contain accents in these fields are distinguished in the database and do not generate an error message when processing them.