Loading data from an Oracle Database fails with Partial Multibyte Character Error

[Anonymous]

When loading data from an Oracle Database through manual reload or through task it fails with following error:

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 29275, ErrorMsg: [Oracle][ODBC][Ora]ORA-29275: partial multibyte character

Note the following strings specifically:

Oracle message: ORA-29275: partial multibyte character

Environment:

QlikView , all versions

Qlik Sense Enterprise on Windows 

Cause:

From ORA-29275: partial multibyte character tips 

Cause: The requested read operation could not complete because a partial multibyte character was found at the end of the input.

Resolution:

This is an error related to the data's NLS character set used in the Oracle DB. Possible solutions are:

• find the records containing partial multibyte character and remove them from the Oracle Database - time consuming and prone to error
• use a data conversion function when loading data in order to convert data into the correct charset
• set the NLS_LANG environmental variable on the Webserver or your local machine or to correspond with the machine hosting the Oracle Database. For example: Webserver NLS is american_america.al32utf8; Oracle DB settings are the following: NLS_LANGUAGE --> AMERICAN NLS_TERRITORY --> AMERICA NLS_CHARACTERSET --> AL32UTF8 

Please see more at:
http://www.dba-oracle.com/t_ora_29275_partial_multibyte_character.htm