Symptoms:
the ADDM inventory connection fails and the below error message is logged in the importer log.
2020-09-03 13:59:37,504 [INFO ] Failed to execute Reader 'Copy installer evidence on computers from the source to the FNMP database' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\bmc atrium discovery and dependency mapping\InstalledInstallerEvidence.xml, at step line 14
Error: Cannot resolve the collation conflict between "Latin1_General_CS_AS" and "SQL_Latin1_General_Pref_CP1_CI_AS" in the UNION operation.
Diagnosis:
The ADDM staging database messed up, the collation is not set correctly on the HostKey for some of the tables for some reason.
Solution:
Either check the collations on the HostKey of the tables in the ADDM staging database (Case sensitive) and fix if they are not set correctly,
or recreate the ADDM_staging database following the installation guide (and then do the customization if any)
