FCC problem

[Former Member]

I have a problem on sender channel.

I have below structure:

HEADERField1Field2DETAILF1F2F3DETAILF1F2F3DETAILF1F2F3......FOOTERF1

Detail record is repeating. And File is coming in a single line(without any separator)

Let's say Length of each fields:

Header.Field1 =2

Header.Field2 =2

Detail.F1 = 3

Details.F2 = 4

Details.F3 =4

Footer.F1 =10

I have below config on sender comm channel

xml.recordsetName = FILE

xml.recordsetStructure = HEADER_G,1DETAIL_G,*,FOOTER,1

xml.HEADER_G.fieldFixedLengths=6,2,2

xml.HEADER_G.fieldNames = Rec_Type,F_1,F_2

xml.HEADER_G.keyFieldValue =HEADER

xml.HEADER_G.endSeparator ='0x00'

xml.DETAIL_G.fieldFixedLengths=6,3,4,4

xml.DETAIL_G.fieldNames = Rec_Type,F_1,F_2,F_3

xml.DETAIL_G.keyFieldValue =DETAIL

xml.DETAIL_G.endSeparator ='0x00'

xml.FOOTER.fieldFixedLengths = 6,10

xml.FOOTER.filedNames= Rec_Type,F_1

xml.FOOTER.keyFieldValue=FOOTER

xml.FOOTER.endSeparator='0x00'

xml.keyFieldName = Rec_type

xml.keyFieldType =CaseSensativeString

xml.processFieldNames=fromConfiguration

But I am getting below error. Any suggestion pls?

Transform: failed to execute the transformation: com.sap.aii.messaging.adapter.trans.TransformException: Error converting Message: 'java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 1: missing structure(s) in last recordset';

[Former Member]

Hi,

in FCC, remove the .endSeparator lines. then activate your sender file adapter. re-run your scenario.

Regards,

Rajeev Gupta

[Former Member]

Hi Rajeev,

I tried with this but it works when records are coming with line feed.

[VijayKonam]

You have to create only one recordset strucuture given your file format. Though they are header detail and footer for you.. it is actually a single fixed length recordset.

VJ

[Former Member]

Hi VJ,

But detail record is repeating. How can I handle these detail record?

[Former Member]

Hi VJ,

Detail record is repeating. How can I handle the multiple detail record?

[Former Member]

Hi VJ,

But detail record is repeating. How can I handle the multiple detail record?

[Former Member]

In your file, for the F1 of the footer, do you really have 10 characters for it? Also the endseparator is 0x00, I wonder how your file could look like with that endseparator, 0x00 is NUL which has no visible symbol. Can you try with different endseparator?

Jayson

[Former Member]

BTW, is your adapter a file adapter or JMS adapter? For file adapter, you do NOT put the text xml. in front of your recordset name in the configuration.

[Former Member]

Hi,

I have tried with without giving any value for endSeparator and getting the same error.

[Former Member]

hi,

I hope this is syntax error in FCC parameters:

xml.recordsetStructure = HEADER_G,1DETAIL_G,,FOOTER,1*

as per syntax there must be a comma between 1 and DETAIL_G.

SAP Help says:

Under Recordset Structure, enter the sequence and the number of substructures as follows: <NameA,nA,NameB,nB,...>.

Therefore, nA=1,2,3,... or * (for a variable, unlimited number, including 0).

Try this

If not will search for other solution

Regards

Praveen

[Former Member]

Hi Praveen,

I forgot to mention , in this post but in my config it is present.

[Former Member]

Hi,

As per the error I can understand that you are not sending a file which doesn't have a footer.

But in FCC parameters you have given the Recordset Structure for footer. So it is expecting a recordset

structure Footer.

Error explains the same:

ERROR consistency check in recordset structure validation (line no. 1: missing structure(s) in last recordset';

Regards

Praveen