5 Replies Latest reply: Oct 15, 2012 2:49 AM by A. Drieux RSS

    Error ODI-40406: Bytes are too big for array

    778223
      Hello ,

      I am trying to load a flat file from a table. I am working on ODI 11G.
      Following are performed.
      Staging area different from SOurce is checked.
      IKM used is : IKM SQL to File Append
      Truncate is True
      No LKM is used.

      I am getting following error:
      java.lang.IllegalArgumentException: ODI-40406: Bytes are too big for array

      The backend code generated regarding the same
      ====================================
      create header     (SALES_PERSON_ID,
           FIRST_NAME,
           LAST_NAME,
           DATE_HIRED)

      /*$$SNPS_START_KEYSNP$CRDWG_TABLESNP$CRTABLE_NAME=TRG_SALES_PERSONSNP$CRLOAD_FILE=C:\oracle\product\11.1.1\Oracle_ODI_1\oracledi\demo\file/TRG_SALES_PERSON.txtSNP$CRFILE_FORMAT=FSNP$CRFILE_SEP_FIELD=0x0009SNP$CRFILE_SEP_LINE=0x000D0x000ASNP$CRFILE_FIRST_ROW=0SNP$CRFILE_ENC_FIELD=SNP$CRFILE_DEC_SEP=SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=SALES_PERSON_IDSNP$CRTYPE_NAME=NUMERICSNP$CRORDER=1SNP$CRLINE_OFFSET=1SNP$CRLENGTH=11SNP$CRPRECISION=11SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=FIRST_NAMESNP$CRTYPE_NAME=STRINGSNP$CRORDER=2SNP$CRLINE_OFFSET=12SNP$CRLENGTH=50SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=LAST_NAMESNP$CRTYPE_NAME=STRINGSNP$CRORDER=3SNP$CRLINE_OFFSET=62SNP$CRLENGTH=50SNP$CRPRECISION=50SNP$CRSNP$CRDWG_COLSNP$CRCOL_NAME=DATE_HIREDSNP$CRTYPE_NAME=STRINGSNP$CRORDER=4SNP$CRLINE_OFFSET=112SNP$CRLENGTH=20SNP$CRPRECISION=20SNP$CR$$SNPS_END_KEY*/

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

      Can some one please help me to resolve the issue.