Skip to Content
0

Recordset Sequence Issue in SAP SFTP Adapter

Aug 24, 2017 at 03:16 AM

64

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Manoj K Aug 24, 2017 at 05:42 AM
0

Hi Prabhat,

Add this parameter for your module :

xml.recordsetStructureOrder  =  asc / dsc / var

For reference go through this blog

Br,

Manoj

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Manoj,

Thank you , I added

xml.recordsetStructureOrder = Variable.

Now it's working fine.

BR,
Prabhat Singh

0