SAP PI issue, Different WSDL actions through SPROXY and ECC Program

[Former Member]

Hi All,   We have Client proxy to SOAP scenario. When we run the program in ECC it creates the records in SOAP Application(SFDC), when we run the exact same payload from SPROXY or soapUI, it updates the records. It should update the records from Program also, if the record already exists.   Why the program is causing duplicate records in SOAP Application and not in SPROXY call or soapUI. Is there any problem with the WSDL, PI 7.1 piece etc ?   Any info/help will be appreciated.   Thanks

[former_member190681]

dear,

for this type issues, you should validate at receiver side application. if you want validate duplicate records you should trim the fields in mapping lever.

[rajasekhar_reddy14]

Hi,

Your SFDC application has validation mechanism to identify duplicate records hence you are getting validation error at SFDC level, but when you ran program in ECC you dont have any validation check hence no error.

If you want to incorporate the same logic then handle it in Proxy level(if you really want to supress duplicate records) this is good design to go ahead.

Best Regards,

Raj

[Former Member]

Hi Raja,

Thanks for the reply. Do you have any documentation as well which recommends to do the trim/cleans the field values at sender ECC side either in program or proxy, We know we can do this at Web Service Receiver side as well but want to weigh out options to do it at sender side in Proxy/Program or in PI Message Mapping for each and every field to cleanse/trim the data.

Please advise with any SOA/best practice documentation or feedbacks

[rajasekhar_reddy14]

There is no document such but the basic rule in SAP is based on data validation, if you want to process same record then go with same approch, if receiver system not expecting same data then check with your functional team and explain the problem by saying that like handling this reuirement in ECC is right idea.

[Former Member]

No, we cannot accomodate duplicates. The SFDC application is causing the duplicates because the ECC program/proxy sends the field values in this format "ABC    " for "ABC" which does not match with already existing "ABC" record in SFDC, hence creates a new one instead of updating. So , to trim it down and validate for all fields that data in fields does not have following NULL character spaces should be done in SAP ECC side or PI ? As a best practice and good design review .

[rajasekhar_reddy14]

  Hi JB,

Best design for your requirement is handle it in ECC Proxy program only, validation we can do PI level also but request your ABAP team to write a validation and if your data having spaces then check with functional team to check wether data is valid or not or even you can check at table level.

Trim can be done in PI mapping but maintaining correct data in ECC always right idea.

Best Regards,

Raj