Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 21 Jul 2012 @ 07:39:59 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   Intermittent - Numeric value out of range: Teradata ODBC problem
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 20, 2012 19:07 -->

This is in an Informatica work-flow I know the literal explanation of what this error means& and checked the mapping DDL to make sure that datatypes are consistent.

The error causes 12 rejects records and is immediately preceded by this event "Parameter array size"

When I manually pulled these rejects and tried to insert them they inserted just fine

2nd run- no rejects . The run after that I had 20 rejects .

I am using ODBC Informatica connection. I know other better alternatives exist but right now ETL just wont change their mappings in Production so easily

Has anyone encountered this problem in using Informatica and ODBC and can share the fix?

     Snippet of the log
     2012-07-12 18:23:46 : INFO : (25831 | WRITER_1_*_1) : (IS | INT_BA_PROD_p)
     Node01_INRPG : CMN_1021 : Database driver event...
     CMN_1021 [
     Teradata parameter array size: [2250].]

     2012-07-12 18:23:47 : INFO : (25831 | WRITER_1_*_1) : (IS | INT_BA_PROD_p)
     Node01_INRPG : CMN_1021 : Database driver event...
     CMN_1021 [
     Teradata parameter array size: [2405].]

     2012-07-12 18:23:47 : ERROR : (25831 | WRITER_1_*_1) : (IS |
          INT_BA_PROD_p) : Node01_INRPG : WRT_8229 : Database errors occurred:
     FnName: Execute -- [Teradata][ODBC Teradata Driver] Numeric value out of range
     2012-07-12 18:23:47 : ERROR : (25831 | WRITER_1_*_1) : (IS |
          INT_BA_PROD_p) : Node01_INRPG : WRT_8425 : ERROR: Writer execution failed.
     2012-07-12 18:23:47 : INFO : (25831 | WRITER_1_*_1) : (IS | INT_BA_PROD_p)
     Node01_INRPG : WRT_8276 : Execute failed.? Re-trying...
     2012-07-12 18:23:47 : ERROR : (25831 | WRITER_1_*_1) : (IS |
          INT_BA_PROD_p) : Node01_INRPG : WRT_8229 : Database errors occurred:
     FnName: Execute -- [Teradata][ODBC Teradata Driver] Numeric value out of range
     2012-07-12 18:23:47 : ERROR : (25831 | WRITER_1_*_1) : (IS |
          INT_BA_PROD_p) : Node01_INRPG : WRT_8425 : ERROR: Writer execution failed.
     2012-07-12 18:23:47 : ERROR : (25831 | WRITER_1_*_1) : (IS |
          INT_BA_PROD_p) : Node01_INRPG : WRT_8114 :
     Row # [1] in bad file

     2012-07-12 18:23:47 : INFO : (25831 | WRITER_1_*_1) : (IS |
          INT_BA_PROD_p) : Node01_INRPG : CMN_1053 : : Rowdata: (RowType=0(insert) Src Rowid=200 Targ Rowid=200
        Col1 (Col1:Dec28Fixed.0:): "2117379"
        Col2 (Col2:Dec28Fixed.0:): "432732717069"
        col3 (col3:Dec28Fixed.0:): "1000000000054253374"
        col4 (col4:UniChar.255:): "(NULL)"
        col5 (col5:UniChar.255:): "KHDTDGCP7KCW"
        col6 (col6:UniChar.255:): "(NULL)"
        col7 (col7:UniChar.64:): "AP139981008"
        col8 (col8:Dec28Fixed.0:): "0"
        col9 (col9:Dec28Fixed.2:): "68.65"
        col10 (col10:Dec28Fixed.2:): "10.28"
        col13 (col13:Dec18Fixed.0:): "1"
        col14 (col14:Dec28Fixed.2:): "69.99"
        col15 (col15:Dec28Fixed.2:): "10.48"
        col16 (col16:UniChar.255:): "14259823"
        col17 (col17:UniChar.3:): "CAD"
        col18 (col18:Date:): "07/11/2012 05:36:43.000000000"
        col19 (col19:UniChar.255:): "PURCHASE"
        col20 (col20:UniChar.100:): "(NULL)"
        col21 (col21:UniChar.100:): "(NULL)"
        col22 (col22:Dec18Fixed.0:): "0"
        col23 (col23:UniChar.255:): "(NULL)"
        col24 (col24:Date:): "07/12/2012 16:50:44.000000000"
        col25 (col25:Date:): "(NULL)"


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016