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
