BAD CHARACTER ERROR WHILE USING TPUMP

Database

BAD CHARACTER ERROR WHILE USING TPUMP

We  are using  tpump  loader  to load  teradata  tables . while using  tpump  sometimes records are  rejected   .

The records in the data file  are 

0    1497924     44803720140329  99991231  1

0    1567138     44803720140329  99991231  0

This data file is used by teradata tpump loader as source and it loads into  terdata table . But  though it appears  in same format  the second data gets rejected.

this is the format  of the target  table  :

evnt_asoc

col name      datatype    precision   primary 

cc_evnt_id       int      10            y           

evnt_asoc_id     int      10            y

row_eff_dte      date     10

row_exp_dte      date     10            y

prmry_evnt_id char      1

the  is the  file structure created in  control file is created for  tpump  :: 

/* Begin Layout Section */  

.Layout InputFileLayout; 

.Field  RowIndicator                                 1 CHAR(    1) ; 

.Field  cc_evnt_id                                   2 CHAR(   11) KEY ; 

.Field  evnt_asoc_id                                13 CHAR(   11) ; 

.Field  row_eff_dte                                 24 CHAR(   10)  ; 

.Field  row_exp_dte                                 34 CHAR(   10) ; 

.Field  prmry_evnt_i                                44 CHAR(    1)  NULLIF prmry_evnt_i                             = '*' ; 

.Filler EOL_PAD                                     45 CHAR(    1) ; 

/* End Layout Section */  

I  want to know  why the  record  is rejected  though the two records appears to be same .  How to find it out ?

This is  the session log  :

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 TRANSF_1_2_1 DBG_21216 Finished transformations for Source Qualifier [SQ_PriorRow]. Total errors [0] 

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 TRANSF_1_1_1 DBG_21215 DBG_21215 Finished processing detail relation : (Fri Oct 24 10:01:51 2014)

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8167 Start loading table [evnt_asoc_rlshp_load_v] at: Fri Oct 24 10:01:51 2014

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 TRANSF_1_1_1 DBG_21216 Finished transformations for Source Qualifier [SQ_CurrentRow]. Total errors [0] 

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 TRANSF_1_7_1 DBG_21215 DBG_21215 Finished processing detail relation : (Fri Oct 24 10:01:51 2014)

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 TRANSF_1_7_1 TE_7032 The B-Tree being managed in files

/usr/apps/ciadw/evtp/Cache//PMAGG2816_524294_0_142113.dat for Data and

/usr/apps/ciadw/evtp/Cache//PMAGG2816_524294_0_142113.idx for Index has:

Index Size: 1

Row Size: 712

Order: 100

Minimum Order: 50

Height: 1

Entries: 1

IndexPageSize: 1296

IndexPages: 810

DataPageSize: 720

DataPages: 2913

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 TRANSF_1_7_1 DBG_21216 Finished transformations for Source Qualifier [Shortcut_to_MPLT_AuditWithMerge.AGG_RowCountsAct]. Total errors [0] 

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8167 Start loading table [adw_audt_prcsg_trgt_load_v] at: Fri Oct 24 10:01:51 2014

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8167 Start loading table [adw_audt_prcsg_src_load_v] at: Fri Oct 24 10:01:51 2014

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8027 Started [tpump] external loader process [22697] in [Staged] mode for target [evnt_asoc_rlshp_load_v]

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8168 End loading table [evnt_asoc_rlshp_load_v] at: Fri Oct 24 10:01:51 2014

INFO 10/24/2014 10:01:51 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8168 End loading table [adw_audt_prcsg_trgt_load_v] at: Fri Oct 24 10:01:51 2014

INFO 10/24/2014 10:01:52 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8141

Commit on end-of-data  Fri Oct 24 10:01:51 2014

===================================================

WRT_8036 Target: adw_audt_prcsg_trgt_load_v (Instance Name: [Shortcut_to_adw_audt_prcsg_trgt_load_v])

WRT_8038 Inserted rows - Requested: 2          Applied: 2          Rejected: 0          Affected: 2         

WRT_8036 Target: adw_audt_prcsg_src_load_v (Instance Name: [Shortcut_to_adw_audt_prcsg_src_load_v])

WRT_8038 Inserted rows - Requested: 1          Applied: 1          Rejected: 0          Affected: 1         

INFO 10/24/2014 10:01:52 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8168 End loading table [adw_audt_prcsg_src_load_v] at: Fri Oct 24 10:01:51 2014

ERROR 10/24/2014 10:01:59 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8047 Error: External loader process [22697] exited with error [12]

ERROR 10/24/2014 10:01:59 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8088 Writer run terminated. [External loader error.]

INFO 10/24/2014 10:01:59 AM NODE_VXPIP-EWKRCI01 WRITER_1_*_1 WRT_8035 Load complete time: Fri Oct 24 10:01:58 2014

Thanks,

Harish