Skip to Content
Aug 24, 2017 at 03:16 AM

Recordset Sequence Issue in SAP SFTP Adapter


One Scenario (SAP SFTP to Proxy )

We are using sender SAP SFTP adapter where file is fixed length. So we are converting it into XML and than updating staging Table .

Source structure is -

Header (key value is HH)
Detail (key Value AD)
Details (key value VA)
Trailer (key Value is TT)

At channel level we have given recordsetstructure - Header,1,Detail,* Details,*Trailer,1

File format ..

HH 01 02
AD 100 20000
VA 200 1000
AD 202002
AD 100000
VA. 101010101
TT 50050

As of now at channel level ,I'm getting an error . Error consistency in recordsetstructure

When I rearranged the file format like -

HH 01 02
AD 100 20000
AD 200 1000
AD 202002
VA 100000
VA. 101010101
VA. 20202010
TT 50050

Means all AD together and just after HH. Similarly all VA together and just after AD .

Than this file is picked by SAP SENDER SFTP channel...and processed successfully..

So Finally I want to know we can set recordset Sequence as "Variable" under module Bean parameters.

Please let me know ASAP as this is the production issue.

Thanks a lot in advance.

Prabhat Singh