Knowledge Base

Knowledge Base
Subject: Concurrency Error
Status Resolved
Product WireCAD v9
Product Level XLT
Database Type VISTADB
Build Number (last 4 digits of version) 7075

Message

Customer
I cannot assign cable numbers anymore due to the following error I am seeing.

Log Message:
Error 455 (Provider v. 3.5.1.84): Concurrency error. The row is being updated or deleted by another active transaction:
Error 251 (Provider v. 3.5.1.84): Cannot update row:
Table: 'NextNumbers', RowId = 26
Exception type: VistaDB.Diagnostic.VistaDBException
Reported by: System.Windows.Forms.Application.ThreadException

Exception:
EntitySpaces.Core : VistaDB.Diagnostic.VistaDBException
Error 455 (Provider v. 3.5.1.84): Concurrency error. The row is being updated or deleted by another active transaction
Error 251 (Provider v. 3.5.1.84): Cannot update row:
Table: 'NextNumbers', RowId = 26
at EntitySpaces.Core.esEntityCollection`1.Save(esSqlAccessType sqlAccessType, Boolean continueUpdateOnError)
at EntitySpaces.Core.esEntityCollection`1.Save()
at WireCAD.CableNumberHelper.GetNewNumberEx(Cables c, CableNoFormatMaster master, String multiCoreBase)
at WireCAD.CableNumberHelper.BuildCableNoString(Cables c, CableNoFormatMaster master, String MultiCoreBase, String leadingZeros, String startingNumber, SignalTypes sigType)
at WireCAD.frmAssignCableNos.InitNewCable(Cables cable, DrawCableInfo cdi, vdPolyline pline, Int32 sIndex, Int32 dIndex, String MultiCoreBase, String leadingZeros, String startingNumber)
at WireCAD.frmDraw.AssignCableNumber(vdSelection sel, gPoint cursorPos)
at WireCAD.frmDraw.BaseControl_DoubleClick(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnDoubleClick(EventArgs e)
at VectorDraw.Professional.Control.VectorDrawBaseControl.OnDoubleClick(EventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at VectorDraw.Professional.Control.VectorDrawBaseControl.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

VistaDB.NET20 : VistaDB.Diagnostic.VistaDBException
Error 455 (Provider v. 3.5.1.84): Concurrency error. The row is being updated or deleted by another active transaction
at iq.ij.a(iv )
at iq.ij.OnUpdateRow(iv , iv )
at iV.it.iO(Boolean )
at tG.ty.2(Boolean )
17-July-2017 (05:06 PM)
It appears that you need to pack the project database. There is a menu command Databases>Pack Project Database. That may not work though. If that does not work use this procedure:
https://www.wirecad.com/wiki/index.php?title=HOWTO:Pack_Database
17-July-2017 (05:25 PM)
Support
Customer
Nice! Thank you! The Pack Project Database menu button did the trick.
17-July-2017 (05:42 PM)