SAGE CRM and SAGE 300 SQL collation conflict

sage-300-sage-crm-sql-collation-method-error

SAGE CRM and SAGE 300 Error Message: Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation

If you’re getting this error message we have somewhat bad news. Your Sage 300 ERP was installed with one SQL collation method and your SAGE CRM was installed with another SQL collation method.

A collation is similar to a Language dialect. As humans, we understand one person speaking a slightly different dialect of our native language and we can interpret the slightly different pronunciation of the words that form the sentence. Computer programs like Microsoft SQL cannot. So what can we do to help you?

From our experience, we recommend that you reinstall the system that has “Latin1_General_CI_AS” since SAGE 300 works better using “SQL_Latin1_General_CP1_CI_AS “ as the collation. The finder buttons and pick lists in SAGE 300 cannot recognize upper and lower case in searches without this collation.

For additional assistance please reach out to our technical support team for Sage 300 ERP at 866-392-6132 option 2.

Tags: ,