Project

General

Profile

Bug #2751

Error checking caused out-of-sync error that led to instability

Added by Michael Lee over 12 years ago. Updated over 12 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
01/26/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2751

Description

Forbes was error checking all plots (from the QA tab) and somehow got an out-of-sync error. Error checking needs to make sure all forms are not dirty before starting, then requery forms (trouble of keeping on same row...).

I have Forbes' database and should try to see what I can find out from it.

History

#1 Updated by Michael Lee over 12 years ago

the memo field "headerrors" on entry_plots_stems was corrupted and was valued #Deleted and access couldn't do anything with that field value (not delete it or anything). This was fixed with a compact and repair.

TODO: need to add to general error checker that if this error comes up (3167 or -2147467259) to suggest compact and repair.

TODO: resolve whatever caused the write-write conflict.

#2 Updated by Michael Lee over 12 years ago

done: need to add to general error checker that if this error comes up (3167 or
-2147467259) to suggest compact and repair.

remaining:
TODO: resolve whatever caused the write-write conflict.

#3 Updated by Michael Lee over 12 years ago

added a command that refreshes all open forms before trying to reset the errors field to null or resolved.

also required that "Errors resolved" will only stick around for one error checking session.

also added link to errors form without doing the error checking.

#4 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2751

Also available in: Atom PDF