I am getting the below error in the Data inventory page.
Cannot resolve the collation conflict between "Latin1_General_CS_AS" and "SQL_Latin1_General_Pref_CP1_CI_AS" in the UNION operation.
When i searched in the forum i have get this solution and attached in the document.
But that is very old and now we are using the FNMS2019R1 version.
Please suggest to proceed further and it is the inventory stopping the Reconcile also.
File is attached with logs and screen shots
Feb 05, 2020 11:21 PM
It looks like your FNMS databases have different collations. That is generally to be avoided. The Installation documentation states:
Especially "Latin1_General_CS_AS" is a problem, because it is CS - case sensitive. I guess you'll have to change that one, maybe just re-create this DB using the same collation as the rest.
Feb 06, 2020 12:24 AM