cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Cannot resolve the collation conflict between "Latin1_General_CS_AS" and "SQL_Latin1_General_Pref_CP1_CI_AS" in the UNION operation.

Hi Team,

 

I am getting the below error in the Data inventory page.

Error message:

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

 

Thanks,

Dhananjayan

 

(1) Reply
mfranz
By Level 17 Champion
Level 17 Champion

Hi Dhananjayan,

It looks like your FNMS databases have different collations. That is generally to be avoided. The Installation documentation states:

DB Collations.png

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.

Best regards,

Markward