Solved

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 Jul 21, 2016 in response to: Joel Getz
 
   
 

Joel,

 

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

RE: Getting a unique constraint error for a duplicate create message with the same SO #
Posted on Aug 22, 2016 in response to: nbrasa
 
   
 

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

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
 
   
 

Niek,

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

 


Add a Comment

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