IDS Forum

Re: HPL error on IDS11.50 FC3 (AIX)

Posted By: PING TANG
Date: Friday, 21 November 2008, at 6:53 p.m.

In Response To: HPL error on IDS11.50 FC3 (AIX) (jak aka)

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.

Messages In This Thread

• HPL error on IDS11.50 FC3 (AIX)
  jak aka -- Thursday, 20 November 2008, at 5:52 a.m.
  • Re: HPL error on IDS11.50 FC3 (AIX)
    PING TANG -- Friday, 21 November 2008, at 6:53 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.