ERROR consistency check in recordset structure validation

[vishnu_pallamreddy]

Hi All,

Our requirement is File(SFTP) to Proxy.

when i execute my scenario we get an error in RWB, Like:

"Error: com.sap.aii.af.sdk.xi.adapter.trans.TransformException: Error converting Message: 'java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 5: missing structure(s) in last recordset'; nested exception caused by: java.lang.Exception: ERROR consistency check in recordset structure validation (line no. 5: missing structure(s) in last recordset".

In our input file we have 4 detailer records and 1 trailer record.

once u check my module configuration in below screen shot.

what is the problem.

please guide me to resolve this issue.

Thanks in Advance,

vishnu pallamreddy.

[Former Member]

Hi.

The problem could be the File , check if Nro of field is according to your FieldNames and FieldFixedLength.

Is the problem is with your last field you can use the parameter MissingLastField.

http://help.sap.com/saphelp_nw73/helpdata/en/44/6713ec3f914ddee10000000a1553f7/content.htm?frameset=...

Regards.

[vishnu_pallamreddy]

Hi Luis,

if we use the parameter MissingLastField it reads the only trailer data.

in my file we have plan number with same for both detailer and trailer.

we configure plan is key field for detailer, and record id for trailer.

is it possible to ignore keyfield?

is it possible to read total file as single record?

please guide me.

why its not read the detailer data?

Thanks in Advance,

vishnu pallamredy.

[Former Member]

Hi..

Pls. Read the above link :

is it possible to ignore keyfield?

NameA.keyFieldInStructure

■  If the key field of the substructure is to be added to the XML document, enter add. This is the default.

■  If the key field is to be ignored, enter ignore.

is it possible to read total file as single record?

Yes it's posible , read as each line , so in your MM you can handle it.

Regards

Lucho.

[vishnu_pallamreddy]

Hi Luis,

Yes it's posible , read as each line , so in your MM you can handle it.?

please give me one example

Thanks in Advance,

vishnu pallamreddy.

[nabendu_sen]

Hi Vishnu,

Check the below blog to get return as xml.

http://scn.sap.com/people/jyothi.anagani/blog/2010/06/17/convert-the-input-xml-to-string-in-pi-71-us...

http://scn.sap.com/people/william.li/blog/2008/02/14/sap-pi-71-mapping-enhancements-series-copy-xml-...

[vishnu_pallamreddy]

Hi Nabendu,

Please check my source and target data types,

please give me how can i read that data into single field.

and also find my module configuration in my sender communication channel.

i am not getting any pay load in RWB.

please help me to resolve this issue.

in my input file we have 4 detailer records and one trailer record is there.

Thanks in Advance,

vishnu pallamreddy.

[Former Member]

Vishnu,

I checked your source data type structure &  amazed to see that you defined additioanl parent strcuture 'TRowePriceLoanData_Rset' with occurance 1 which is unncessary node only increasing the structure hierarchy. Had its cardinality more than once than you should have this additional node in the structure.

Try to remove this one & then test it.

This would work definitly.

Regards,
Ashish

[vishnu_pallamreddy]

Hi Ashish,

i remove "TRowePriceLoanData_Rset" and i tested.

there is no use.

there is no payload in RWB and error in SXMB_MONI like

"com.sap.aii.utilxi.misc.api.BaseRuntimeException:Premature end of file".

please see my input file.

Thanka in Advance,

vishnu pallamreddy.

105212 SAMPLE P105212 LNEXTR_test.txt.zip

[Former Member]

how you are defining your recordset structure in FCC parameters? Share it..

If the input file is not matching with structure you defined in FCC parameters then it should throw error in RWB at adapter engine & not in SXMB_MONI.

[Former Member]

how you are defining your recordset structure in FCC parameters? Share it..

If the input file is not matching with structure you defined in FCC parameters then it should throw error in RWB at adapter engine & not in SXMB_MONI.

[nabendu_sen]

Hi Vishnu,

Its clearly saying your Content Conversion is not working properly. Other than this, it could happen only for below 2 cases:

1)The Inbound payload is not correct or well formed,check your Inbound payload.

2)The Inbound payload has any special characters.

Check and let us know.

[vishnu_pallamreddy]

Hi Ashish,

Record set structure: please find attached screen shot.

we also put a condition for detailer and trailer in mapping.

Thanks In Advance,

vishnu pallamreddy.

[vishnu_pallamreddy]

Hi Nabendu,

There is no Inbound Payload, i mean no inbound payload generated.

and there are no any special characters.

Thanks in Advance,
vishnu pallamreddy.

[nabendu_sen]

Hi Vishnu,

I think the number of records for Detailer and Trailers are not matching in your Recordset structure , Please specify wildchar character. Dont give max numbers.  The errors says expecting the specified number for recordset and  since it is missing gives errror.

[vishnu_pallamreddy]

Hi Nabendu,

As u said i mention in my record set structure as detailer,4 and trailer,1.

now interface executed and payloads generated, but i have an error like this "

"com.sap.aii.mappingtool.tf7.IllegalInstanceException: Cannot create target element"

and "Values missing in queue cont."

in my sender data type there is no record set structure.

my data type:

datatype

   detaile

   trailer.

Thanks in Advance,

vishnu pallamreddy.

[vishnu_pallamreddy]

Thank you Nabendu

and thank you all.

Thanks in Advance,

vishnu pallamreddy.

[vishnu_pallamreddy]

Hi Nabendu,

When i give detailer,4 and trailer,1 in rrecordset structure in module configuration we get payloads in both RWB and SXMB_MONI.

if i give * instead of 4 i am getting "

"ERROR consistency check in recordset structure validation" error in RWB.

what is the problem?

Thanks in Advance,

vishnu pallamrreddy.

[nabendu_sen]

Hi Vishnu,

This mapping error comes for mismatch of different queues generating from a function (mainly Node Functions). By any chance are you using formatByexample or useOneasMany functions? Can you provide your mapping screenshot for the Target field this error is coming. I am sure in the error it will specify for which Target Field this error is coming.

[nabendu_sen]

Hi Vishnu,

As per my understanding, now you are able to generate the Source Payload successfully (using Detailer <4> and Trailer <1>) but getting Mapping Error as mentioned above. I have provided comment regarding that. Provide the details of the Target Field and it corresponding mapping screen shot.

[vishnu_pallamreddy]

Hi Nabendu,

My mapping screen shots,

i put a condition for detailer and trailer.

i didn,t use any extra conditions like formatByexample or useOneasMany functions.

I mentioned Key field name and detailer key field value and trailer key field value as "ignore" in module configuration.

Thanks in Advance,

vishnu pallamreddy.