Skip to Content
avatar image
Former Member

FCC Problems

Hi,

I have a recordset structure like this.

DTLegacyHeader,DTLegacyItemMasterData,DTLegacyTrailer

The communication channel is giving an error like KeyFieldName is mandatory. What do i need to specify in the FCC

This is the Recordset Structure

DTLegacyHeader,1,DTLegacyItemMasterData,*,DTLegacyTrailer,1

I have specified the necessary parameters like field separator, end separator,ignore recordset etc.,

Let me know what woyuld be the error.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 28, 2009 at 03:27 PM

    Hi you have to specify the keyfield which is mandatory.

    Please check the following blogs

    /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

    /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 28, 2009 at 03:25 PM

    Krish,

    Since you have three structures you need to have a key field which identifies the structure separately. This would be different for each structure. With this xi will identify the record belongs to which structure.

    If you two strucures DTLegacyHeader,1,DTLegacyItemMasterData,* then xi will convert the first one to header and the rest to ItemMasterdata. Since you have three DTLegacyHeader,1,DTLegacyItemMasterData,*,DTLegacyTrailer,1 xi will not know when your ItemMasterData is completed becasue it is *. So to handle this you definitely need to have a key field.

    So ask the guys who gave you the file to have a key field in the first column say H, D, T which says header, detail and trailer and give this key field in your comm. channel.

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Krish,

      So then there is some problem in your content conversion. Can you give the parameters you have given and also the sample file you are trying to pick so that somebody can help you out.

      Regards,

      ---Satish