Issue with Sender File Adapter file content convertion

[Former Member]

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.

ROU^ASIS.MLASIS.A02001^COMASN1.1.2

HDR^7072396166N^^{MAEU/SZH3PA288}20070724^8IF0708^2007090311^CAFXS^YATFXS^20070903

PPL^5705150010506^YAT25491540271358604⁵¹⁶²⁵⁴397173^{0000002723.000}C²⁷⁵0000000024.160^2007081120070903^^

SIM³⁰20070711^^20070730Y^^^00

CON^TTNU946652840^CN0579566 7335

CTN¹00069350800012609166²⁰9.85^0.08068.58^30.4838.10

DTL⁵20^01

CTN²00069350800012609173²⁰9.85^0.08068.58^30.4838.10

DTL⁵20^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

[Former Member]

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

[Former Member]

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

Thanks

Rinku

[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.

[Former Member]

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

[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