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 )
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
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)