Getting a unique constraint error for a duplicate create message with the same SO #

Comments: 3 - Last Comment by Joel Getz on Sep 14, 2016   Comment Filter:
Posted on Jul 20, 2016

 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


Point your RSS reader here for a feed of the latest messages in this topic
RE: Getting a unique constraint error for a duplicate create message with the same SO #
Posted on Sep 14, 2016 in response to: 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.




Add a Comment

Please sign in on the right menu to comment.  If you do not have an account, please Join now.