Knowledge Base

Knowledge Base
Subject: Unable to add new audio cable numbers
Status Resolved
Product WireCAD v10
Product Level PRO
Database Type VISTADB
Build Number (last 4 digits of version) 0226
Upload No file!

Message

Customer
I am in the process of creating drawings for a complete broadcast studio with over a dozen drawings. I was adding audio cable numbers to my drawings one at a time, then suddenly I get an error 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 = 40
Exception type: VistaDB.Diagnostic.VistaDBException
Reported by: System.Windows.Forms.Application.ThreadException
For this project I use WireCAD on multiple machines at different locations, and all give that error. I am unable to continue because without those cable numbers I cannot print labels.
Any ideas on how to resolve?
Thanks.
05-June-2021 (01:43 PM)
Hi Bobby, It sounds like you need to Pack the project database. NOTE: This is NOT the Packup/Checkout function.
If you can get the project open in WireCAD (and it sounds like you can) you can use the menu function:
Database>Pack Project Database. See the attached screenshot.
This will repair the database so you can continue.


If you can't get the project open in WireCAD you will need to use an external utility.
First close WireCAD.
From your windows start button find the WireCAD 10 section and the VistaDB Data Editor and open it.
Then File>Open and browse to your project database <YOUR_PROJECT_PATH>\Project Databases\<YOUR_PROJECT_NAME>.vdb3
Once the database is open in the data editor you will see a [Pack] button on the main screen. Click it and wait until it says it's done.
Close the VistaDB Data Editor.
Open WireCAD and your project.
You should be good to go.
05-June-2021 (02:15 PM)
Support
Customer
That did. Thanks so much!
05-June-2021 (03:36 PM)