piter197
Posts: 832
Joined: Sun Jan 09, 2011 3:32 am

NMEA error Column 'gate_event_id' is constrained..

Wed Nov 04, 2015 4:16 am

Hi Support,

In NMEA error log file we have a lot of this error message:

2015-11-04 08:00:11.7050 | Error | 33 | _BatchDAO._Update | Retry row: | System.Data.ConstraintException: Column 'gate_event_id' is constrained to be unique. Value '17085336' is already present.
at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at Franson.DAO.SharedBatch._BatchDAO._Update()
2015-11-04 08:04:53.8768 | Error | 34 | _BatchDAO._Update | Retry row: | System.Data.ConstraintException: Column 'gate_event_id' is constrained to be unique. Value '17085718' is already present.
at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at Franson.DAO.SharedBatch._BatchDAO._Update()
2015-11-04 08:05:20.2675 | Error | 33 | _BatchDAO._Update | Retry row: | System.Data.ConstraintException: Column 'gate_event_id' is constrained to be unique. Value '17085496' is already present.
at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int64 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at Franson.DAO.SharedBatch._BatchDAO._Update()


Please help to rectify this. Thank you.

Best Regards,
piter197

User avatar
johan
GpsGate
Posts: 15342
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

RE: NMEA error Column 'gate_event_id' is constrained..

Wed Nov 04, 2015 11:12 am

"Retry row: " means in this case that there is an error, but GpsGate recovers from this error.

The actual reason why this happen is still unknown to us, but as I mentioned GpsGate recovers without any issues.

Regards,
Johan

GpsGate Support

Return to “GpsGate Server - How to setup and use”