HPL Loading error with Fatal error in server row processing - SQL error -271 ISAM error -151

HPL Loading error with Fatal error in server row processing - SQL error -271 ISAM error -151

Post by chetan.ana » Fri, 30 Nov 2007 07:52:11


Hi All

Seeking help on HPL loading.

HPL loading gives Fatal error in server row processing - SQL error
-271 ISAM error -151. However, exactly same project and job works fine
in another INFORMIX installation with slight version different. Data
gets converted from iso81 to utf8 using HP utility inconv and same is
used in both the boxes. Conversion is required to facilitate data from
various countries sitting in non-unicode database to central UNICODE.

Appreciate any help and please find details below on the project / job

Project
$ onpladm create project smpl_proj -T $INFORMIXSERVER -S
$INFORMIXSERVER

Job
$ onpladm create job load_job -p smpl_proj -d /tmp/data -D test -t
tablea -flc

Test Box INFORMIX
IBM Informix Dynamic Server Version 10.00.FC6

Production Box INFORMIX
IBM Informix Dynamic Server Version 10.00.FC4
Fatal error in server row processing - SQL error -271 ISAM error
-151

Database Load Completed -- Processed 220
Records
Records Inserted->
0
Detected Errors-->
0
Engine Rejected-->
0

Database is a UNICODE having en_US.utf8

Thanks in advance and really appreciate any help.