SOAPProcessingException: Insert Aborted : Error during insert

haider3 · ‎03-03-2017

Hi Everyone,

I am doing Soap integration with a 3rd party tool. First time they are able to insert record in the import set table. But after that if they try to insert the record with same incident number in Import set table, then we are getting the following error.

When i delete the previous record from Import Set table, then again it works fine. I don't understand what is happening.

If anyone has faced the same issue, please help me out here. Its an uregtn requirement.

Thanks in advance,

Haider

James_Neale · ‎03-06-2017

Have you checked the System Logs? I've seen this issue a couple of times and it's usually data policies, aborting business rules, or duplicate sys_ids. Note that you'll probably only see the duplicate sys_id issue in the system logs.

Also, you can try running an onAfter script to log the error (note you may want to modify this to be more detailed):

var source = 'SOAP Incident';

if (target.getLastErrorMessage()) {

   gs.log(target.getLastErrorMessage(), source);

} else if (target.isActionAborted()) { // From Fuji Patch 3

   gs.log('Action was aborted by external means e.g. business rule', source);

}

Failing that, download Xplore from Share (or use a background script) to try to replicate the issue. Insert a glide record, get the record and then try updating it. This could be long winded but you can turn on logging to get the business rule output, etc.

Hope that helps

View solution in original post

ananthagowraram · ‎03-03-2017

Hi Haider,

Check whether the incident number field in staging table is unique (coalesce= true).

Thanks

Anantha Gowraram

haider3 · ‎03-05-2017

HI ,

The incident number is set (coalesce= true) in transform map

Alikutty A · ‎03-03-2017

Hi,

Can you please show a screen print of your transform map coalesce and the Soap requests that are being send both times?

Also have you written any transform map script to ignore or error out?

Thanks

PS: Hit like, Helpful or Correct depending on the impact of the response

haider3 · ‎03-05-2017

I just exposed my WSDL to the client so that the can send data to our system. but for first time they are successfully able to send the data to the import set table but when they try it again issue occur ,

this issue is not occur when i tried to integrate it with my demo instance.

Please help ,

Thanks

Haider