KB36662: "The string contains an untranslatable character" error occurs when running a data load in MicroStrategy Enterprise Manager 9.x and 10.x against a Teradata warehouse

SYMPTOM:
When running a Strategy Enterprise Manager 9.x and 10.x data load against a Teradata warehouse the following error may occur:
 
Error
Error executing SQL :Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. The string contains an untranslatable character. INSERT INTO IS_REP_FACT 
 
 
CAUSE:
One possible cause of this error is a character set mismatch between columns in the IS_REPORT_STATS and the IS_REP_FACT tables as shown below:
 
IS_REPORT_STATS
Sql
CHARACTER SET UNICODE NOT CASESPECIFIC
 
IS_REP_FACT
Sql
CHARACTER SET LATIN NOT CASESPECIFIC
 
 
ACTION:
To resolve this issue, examine the character sets used for the columns in the IS_REPORT_STATS and IS_REP_FACT tables. If there is a mismatch, contact the database administrator for assistance changing the character set used to UNICODE.