Skip to Content

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

BR,
Prabhat Singh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 24, 2017 at 05:42 AM

    Hi Prabhat,

    Add this parameter for your module :

    xml.recordsetStructureOrder  =  asc / dsc / var

    For reference go through this blog

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded