Skip to Content
avatar image
Former Member

Issue with Sender File Adapter file content convertion

Hi Everybody,

I am facing an issue in FCC at the sender side.

Below is sender text message which contains 9 rows.Each row represents one node in the source structure.

ROUASIS.MLASIS.A02001COMASN1.1.2

HDR7072396166N^MAEU/SZH3PA288200707248IF07082007090311CAFXSYATFXS^20070903

PPL5705150010506YAT254915402713586045162543971730000002723.000C2750000000024.1602007081120070903^^

SIM3020070711^20070730Y^^^00

CONTTNU946652840CN0579566 7335

CTN100069350800012609166209.850.08068.5830.4838.10

DTL520^01

CTN200069350800012609173209.850.08068.5830.4838.10

DTL520^01

In the above message CTN row is repeating after each DTL because of which i am getting the error.

<b>Conversion of file content to XML failed at position 0: java.lang.Exception: ERROR consistency check in recordset structure validation</b>

Can somebody help me out in resolving this issue.

Thanks in Advance,

Arvind

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 03, 2007 at 01:22 PM

    hi

    please use the following parameters in the communication channel

    document name: ur message type name

    document namespace: ur message type namespace

    Recoredsetname: parentnode name

    Recordsetstructure: ROU,1,HDR,1,PPL,1,SIM,1,CON,1,CTN,,DTN,

    recordsetsequence: variavle

    recordsetpermessage: *

    keyFieldname: ur key field value

    in in the parameter tab give following parameters

    parentnodename.fieldSeparator :^

    parentnodename.fieldNames: all field names under this parent node

    parentnodename.keyFieldValue:ur key field value

    Thanks

    Rinku

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rinku,

      I have given the FCC parameters as mentioned by you and my datatype is 0...unbounded for all the nodes so i gave it as

      Recordsetstructure: ROU,,HDR,,PPL,,SIM,,CON,,CTN,,DTN,*.

      I hope this is not going to do much of a difference but still the problem exists.It is basically because i have alternating CTN and DTL rows repeating continously.

      Can you have any idea how to handle such situations in FCC.

      Thanks,

      Arvind

  • avatar image
    Former Member
    Oct 03, 2007 at 02:50 PM

    can you please send the exact file structure with multiple occurence.

    Thanks

    Rinku

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rinku,

      The file contains the same records what i have mentioned above in the query. I checked out giving the record set structure given by you that is

      ROU,1,HDR,1,PPL,1,SIM,1,CON,1,CTN,,DTN, and its working fine for this test file.But my issue is that as i have mentioned, my data type is <b>0 to unbounded</b> for all the rows (ROU,HDR,PPL,SIM,CON,CTN,DTN) and i need a solution to handle this condition too.

      I hope you got the requirement.

      Thanks,

      Arvind.

  • avatar image
    Former Member
    Oct 04, 2007 at 05:29 AM

    Hi Arvind

    plas use the following parametes in the sender communication channel.

    i have tried one scenario

    my source structure is like that:

    data (0..unbounded)

    record (0..unbounded)

    key (1..1)

    fname (1..1)

    lname (1..1)

    age (1..1)

    detail (0..unbounded)

    key (1..1)

    salary (1..1)

    empid (1..1)

    so use the following parameters at the sender side

    document name: messge type name

    document namespace: ur message type namespace

    Recordset name: data(as per according to my source structure)

    RecordsetStructure: record,,detail,

    recordsetsequence: variable

    recordsetpermessage: *

    keyfieldname: key

    and different parameters:

    RECORD.fieldSeparator ,

    RECORD.fieldNames KEY,FNAME,LNAME,AGE

    RECORD.keyFieldValue 1

    DETAIL.fieldSeparator ,

    DETAIL.fieldNames KEY,SALARY,EMPID

    DETAIL.fieldNames 2

    if you still have the problem pleas reply back.

    Thanks

    Rinku

    Add comment
    10|10000 characters needed characters exceeded