This discussion is archived
5 Replies Latest reply: Oct 15, 2012 12:49 AM by A. Drieux RSS

Error ODI-40406: Bytes are too big for array

778223 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points