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
Complex flat file
Moderators: chulett, rschirm, roy
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 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?
Thanks
Naidu
Naidu
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
Thanks
Naidu
Naidu