Complex flat file

naidu · Post by **naidu** » Fri Oct 16, 2009 3:01 pm

Hi All
i have a CFF (Complex Flat File) stage as source and when i am trying to view the data it shows the following error msg
Error: -
<Complex_Flat_File_12> Formatted length of fields and record (0) less than declared length (164)
>##E IIS-DSEE-TOPK-00007 16:59:44(012) <PEEK_IDENT> Input dataset does not have field: "DISTRO_ORDER_NUMBER".
>##E IIS-DSEE-TOPK-00007 16:59:44(013) <PEEK_IDENT> Input dataset does not have field: "DISTRO_ENTRY_DATE".
>##E IIS-DSEE-TOPK-00007 16:59:44(014) <PEEK_IDENT> Input dataset does not have field: "DISTRO_INPUT_SOURCE".
>##E IIS-DSEE-TOPK-00007 16:59:44(015) <PEEK_IDENT> Input dataset does not have field: "DISTRO_CUSTOMER_STORE_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(016) <PEEK_IDENT> Input dataset does not have field: "DISTRO_LAWSON_CHAIN_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(017) <PEEK_IDENT> Input dataset does not have field: "DISTRO_LAWSON_STORE_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(018) <PEEK_IDENT> Input dataset does not have field: "DISTRO_CS_ITEM_CODE".
for all the fields

the record options are
Byte order: Native-endian Character: EBCDIC
Data format: Binary Record delimiter:
I have a single record

so can any one tell me how can i clear this error so that i can view the data in CFF stage

ArndW · Post by **ArndW** » Sat Oct 17, 2009 6:17 am

It is clear that your actual data format and metadata don't match. Start off with the first field, what is it called, what is the PIC clause for it and have you used a binary or similar editor to compare the actual file contents with your picture clause?

Kryt0n · Post by **Kryt0n** » Sun Oct 18, 2009 2:30 pm

We had this same problem, there is a client side patch you need to install (assuming it is exactly the same issue)

patch_JR31443v2_client_windows_81.zip
patch_JR31443v2_clientupdater_windows_8100.zip

Although best to contact support to confirm there isn't a more recent roll-up patch resolving this

naidu · Post by **naidu** » Sun Oct 18, 2009 5:03 pm

ArndW wrote:It is clear that your actual data format and metadata don't match. Start off with the first field, what is it called, what is the PIC clause for it and have you used a binary or similar editor to compare the actual file contents with your picture clause?

Hi Thanks for your reply my actual data format and metadata are same the job which i am trying to view the data is migrated from version 7.5 to 8.1 i can view the data in 7.5 but when i am trying to view in 8.1 it shows the error.

ArndW · Post by **ArndW** » Mon Oct 19, 2009 2:52 am

In that case it does sound like the patch listed by Kryt0n is your most likely solution.

naidu · Post by **naidu** » Wed Oct 21, 2009 4:25 pm

Kryt0n wrote:We had this same problem, there is a client side patch you need to install (assuming it is exactly the same issue)

patch_JR31443v2_client_windows_81.zip
patch_JR31443v2_clientupdater_windows_8100.zip

Although best to contact support to confirm there isn't a more recent roll-up patch resolving this

Hi Kryt0n
Thanqu we also installed the patch_JR31443 now i can view the data in CFF stage in datastage 8.1