on 06-30-2014 3:16 AM
Hi PI experts,
I've come across a scenario where the customer requires Delete records before Insert records but would like to have it using EO (so that if it errors, it processes subsequent records).
The messages are created from a proxy interface in CRM - would this be possible, and if so, how?
Thanks in advance!
Hi Vivian,
Not sure if I understood your requirements completely, but this should be possible. In your proxy code, make it such that you always send the delete records (one message) and then send the insert records (another message) afterwards. By default, abap proxy uses EO for asynch interfaces.
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Mark/Vivian,
Though it is batch job, unless you make sure that delete job executes first (till target), we can not insert the records.
The one way in can think of is, use the multiple statements in mapping, Statement 1 for delete and Statement 2 for insert and in rcv channel use the isolation level as "serializable". so that you can make sure that delete statement executes at database first then insert.
Now, when sending data to PI, just think about how effectively you can split the data. Means, create batch jobs based on plant or location ot club etc.. this way you can make sure that per a given plant data, delete job works first and then insert.
Hope this gives you an idea. please let me know your thoughts.
--Naresh
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.