The snip above is from our Inservice Response Tool and we have a Create and then 15 seconds later a failed attempt on the same order. Below is the unique constraint error we see in the temp folder.

DB error occurred at 2016-07-19 21:43:47.463 UT
Process ID = 3740 Thread ID = 4392 Connection Object = CAD
CADDAC Error = 80040e2f
CADDAC Error Message = Value violated the integrity constraints for a column or table.
Method = Execute(insert into agency_event (ad_ts, ag_id, alarm_lev, assigned_units, cdts, cpers, cterm, dgroup, eid, esz, eta, status_code, evt_rev_num, loi_avail_dts, num_1, pend_dts, priority, rev_num, scdts, sdts, supp_info, is_open, rev_sec, ssec, ad_sec, tycod, sub_tycod, typ_eng, reopen, recom_incomplete, cbtime2, pending_timer, dispatch_timer, enroute_timer, arrive_timer, acknowledge_timer, rev_dts, rev_pers, rev_term, temp_lock, nwe_appt_date, nwe_due_date) values ('20160719214347UT', 'NWE', 0, 0, '20160719214347UT', 0, 'dcmomspv14', 'BOZ', 734913, 0, -1, 21, 1, '20160719214347UT', '9426072', '20160719214347UT', 9, 1, '20160719214347UT', '20160719214347UT', 0, 'F', 1468964627, 1468964627, 1468964627, 'FGSTS', 'default', 'GAS MTR SET- ON - SRV ONLY *NC', 'F', 'F', 0, 0, 0, 0, 0, 0, '20160719214347UT', 0, 'dcmomspv14', 'F', '07/27/2016 2:00 PM', '08/26/2016')
/* config id = 57 */)
ADO Error = 80040e2f
Source = OraOLEDB
Description = ORA-00001: unique constraint (OMSP1.AGENCY_EVENT_PK) violated
NativeError = 1

What are the two XML messages you are sending to InService?

Any log files that you could email to us of the services involved? If you are running multiple BatchCalls, we would like to get the log files of those as well.

Thanks,

Niek

After meetings with Chris Bennett, we decided to try and capture the multiple gets or puts on the MQ and that way we will be able to see if IDispatcher is the culprit or if we need to go to Vertex and SAP to discuss why they are sending duplicate xml messages. Will keep you posted as this will go in the end of the week during Category 1 Patching downtime.

Thanks,

Joel Getz

We were able to capture duplicate PUT createeventwithsuppinfo xml messages coming from our cis system. We have sent that information off to Vertex and they are reviewing the process and seeing where the bug is on their side.

Thanks,

Joel