We are getting lots of Unique Constraint Errors from the caddaccerror.batchcall where the system is processing duplicate create messages with the same SO#. Has anyone seen this before?
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
|
