ADDM import failed with collation conflict error

ADDM import failed with collation conflict error

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)

Labels (2)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
2 of 2
Last update:
‎Dec 25, 2020 10:53 PM
Updated by:
 
Contributors