Oninit cdi / Archive
Talk to an expert →

HPL error on IDS11.50 FC3 (AIX)

Posted in 2008

Topics: Error Codes & Troubleshooting, Versions, Editions & End-of-Life

jak aka — — source: IIUG Forums & Mailing Lists

Dear all, I try to load data into new instance. I got an error in HPL log. Anyway if I load by using "load from .. insert into ..." , It's OK. No error happens. How to fix this. Please help. Best regards, Jakkrit A. ################################################################################ #### Sever Detail: $ uname -aAIX Despina15 3 5 000B25DED700 $ oslevel -gFileset Actual Level Maintenance Level ----------------------------------------------------------------------------- bos.rte 5.3.8.0 5.3.0.0 ################################################################################ #### Informix Version: IBM Informix Dynamic Server Version 11.50.FC3 Software Serial Number AAA#B000000 ################################################################################ #### --- HPL LOG ----------- Thu Nov 20 04:42:38 2008 SHMBASE 0x0700000000000000CLIENTNUM 0x0000000049010000 Session ID 96 Load Database -> realtime Load Table -> test Device Array -> test Record Mapping -> test Convert Reject -> /tmp/test.rej Filter Reject -> /tmp/test.flt Error occurred on record 961 in file /data/data/realtime/detl_trns_200810_1.dat Error occurred on record 962 in file /data/data/realtime/detl_trns_200810_1.dat Error occurred on record 963 in file /data/data/realtime/detl_trns_200810_1.dat Error occurred on record 964 in file /data/data/realtime/detl_trns_200810_1.dat Error occurred on record 965 in file /data/data/realtime/detl_trns_200810_1.dat Error occured at HPL failpoint: 10570 Fatal error in server row processing - SQL error -407 ISAM error 0Error occured at HPL failpoint: 10570 Database Load Completed -- Processed 966 Records Records Inserted-> 828 Detected Errors--> 5 Engine Rejected--> 0 Thu Nov 20 04:42:42 2008

↪ replying to jak aka
PING TANG — — source: IIUG Forums & Mailing Lists

Hi Would you provide me a copy of the schema for your targeted table and the five records which generated errors? Do you see this problem on previous IDS versions? Thanks! -Ping > Error occurred on record 961 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 962 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 963 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 964 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 965 in file > /data/data/realtime/detl_trns_200810_1.dat --- On Thu, 11/20/08, jak aka <jakkritakeng@yahoo.com> wrote: > From: jak aka <jakkritakeng@yahoo.com> > Subject: HPL error on IDS11.50 FC3 (AIX) [14063] > To: ids@iiug.org > Date: Thursday, November 20, 2008, 4:52 AM > Dear all, > > I try to load data into new instance. I got an error in HPL > log. Anyway if I > load by using > "load from .. insert into ..." , It's OK. No > error happens. > How to fix this. Please help. > > Best regards, > Jakkrit A. > > > ################################################################################ #### > > Sever Detail: > $ uname -a> AIX Despina15 3 5 000B25DED700 > $ oslevel -g> Fileset Actual Level Maintenance Level > ----------------------------------------------------------------------------- > > bos.rte 5.3.8.0 5.3.0.0 > > > ################################################################################ #### > > Informix Version: > IBM Informix Dynamic Server Version 11.50.FC3 Software > Serial Number > AAA#B000000 > > > ################################################################################ #### > > --- HPL LOG ----------- > Thu Nov 20 04:42:38 2008 > SHMBASE 0x0700000000000000> CLIENTNUM 0x0000000049010000 > Session ID 96 > Load Database -> realtime > Load Table -> test > Device Array -> test > Record Mapping -> test > Convert Reject -> /tmp/test.rej > Filter Reject -> /tmp/test.flt > Error occurred on record 961 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 962 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 963 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 964 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occurred on record 965 in file > /data/data/realtime/detl_trns_200810_1.dat > Error occured at HPL failpoint: 10570 > Fatal error in server row processing - SQL error -407 ISAM> error 0 > Error occured at HPL failpoint: 10570 > Database Load Completed -- Processed 966 Records > Records Inserted-> 828 > Detected Errors--> 5 > Engine Rejected--> 0 > Thu Nov 20 04:42:42 2008 > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in > the discussion forum.

Glossary