maintain order at runtime while inserting in tables in sequence

[former_member474221]

Hi

I have a requirement where I need to insert the data in 2 tables in sequence .Receiver Database is the same

if I use "maintain order at runtime " in the interface determination , Will it also maintain sequence if the first receiver JDBC channel fails

OR it will maintain the sequence only if the first operation mapping fails ??

[iaki_vila · Accepted solution]

Hi Hema,

Will it also maintain sequence if the first receiver JDBC channel fails
OR it will maintain the sequence only if the first operation mapping fails ??

As far as i know i think if you check Maintain Order  at runtime if the first receiver fails the execution is not stopped and it continues with the second interface, with EOIO the execution of the second interface would be stopped. Maintain order at runtime maintains the order inside the PI but if you choose quality of service EOIO the order is from sender to the receiver.

JDBC supports EOIO, then you can use EOIO.

http://help.sap.com/saphelp_nw04/helpdata/EN/42/ea20e737f33ee9e10000000a1553f7/content.htm

Regards.

[former_member474221 · Accepted solution]

thanks for your replies...stored procedure is not an option as client is not ready for that

my sender is Proxy and receiver is jdbc

so will sender proxy support EOIO

[rajasekhar_reddy14 · Accepted solution]

Yes, Proxy supports EOIO, piece of code required in proxy program check below link and search in SCN

https://scn.sap.com/message/9134800

[Former Member]

Hello,

I would suggest you to go with SP. Please refer below thread:

http://scn.sap.com/thread/2154629

In past, i have worked on this kind of scenario and using "MOAR" results into some erratic behavior and eventually i opted SP. 

Thanks

Amit Srivastava

[rajasekhar_reddy14]

Maintain run time order will not guarantee EOIO processing hence you have to set EOIO processing configuration at sender adapter.

The best design for your requirement is stored procedure  and pass data to stored procedure and ask your data base team to write a logic to process data in sequence manner(very easy for them).