Informix - Problem description
Problem IT18959 | Status: Closed |
GETTING ERROR -454('LOC_READ()' FAILED) AND -847(ERROR IN LOAD FILE LINE NUMBER) WHEN LOADING INTO TEXT TYPE COLUMN AND CODESET | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
There is a migration being performed from 11.50 to 12.10.FC8 using unload / load testing and during the loading phase an error 454 is being seen on some of the data rows. The old system has the following locale settings ... CLIENT_LOCALE=zh_HK.big5-hkscs DB_LOCALE=zh_HK.big5-hkscs The new system has the following locale settings ... export DB_LOCALE=zh_HK.UTF8 export CLIENT_LOCALE=zh_HK.big5-hkscs export GL_USEGLU=1 During the load from unl insert into tab there are some rows with Chinese characters resulting in an error 454 error. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Any * **************************************************************** * PROBLEM DESCRIPTION: * * Error is masked by GLU library during fileio/conversion, * * resulting in a condition that cannot be handled by higher * * level functions. * **************************************************************** * RECOMMENDATION: * * Update to Informix 12.10.xC9/CSDK 4.10.xC9. * * * * http://www.ibm.com/support/fixcentral * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.01.2017 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9, 4.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |