Follow

Error: The locale id of the source column and the locale id of the destination column do not match.

Symptoms

Executing a staging area table results in an error message.

Error Message

The locale id '####' of the source column '<ColumnName>' and the locale id '####' of the destination column '<ColumnName>' do not match.

Underlying Cause

The TX DWA staging area database and one or more of the data source databases are using different collation options.

Solution

Check "Force Codepage Conversion" in the data source settings.  This will ensure that TX DWA is able to translate the source data into a format the staging area database can understand.  

Note that if you add an additional connection that requires this option to an existing data source, you must select "Force Codepage Conversion" in the options for that new connection.  You must take this step even if you've already selected the option in the primary data source's settings.  The reason for this is that additional connections do not inherit any settings from the primary data source.  

Having this option enabled for the main data source but not for an additional connection is a common cause for this error.  

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.