Project

General

Profile

Bug #3786

Hand Error checking improvements

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

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

0%

Estimated time:
Bugzilla-Id:
3786

Description

A number of problems are encountered in Caroline Bernard's hand error checking:

1) The database crashes frequently in this mode in Access 2007 on Caroline's computer. Copying to local drive didn't seem to help. It seems to be an Access problem working with this amount of data. Perhaps some indexing could be added to help it work with the large amount of data, or perhaps we should load only one plot at a time. As a temporary workaround, we have upgraded project 89 to Access 2007 file format, and so far this seems to have solved the intermittent problem.

2) On the tree stems, some error is causing the database to crash from function: select0IfThere() which is a trivial function that should simply ignore errors. MTL to add error ignoring to that function.

3) there is also evidence in the logs of errors with too much data trying to be inserted when adding a new species in FormAddSpecies sci_name_afterUpdate. MTL to try to reproduce this bug and fix it.

4) log dates are included in the diff between versions of error embedding and these can't be caught and should not be included in the diff. Last update plot, row and person last updating plot and row are all included in the diff.

5) DBA mode takes precedence over error embedding, which is backwards. Error embedding should take precedence so that no one ever embeds errors in the real data.

In general, some hammering on the error embedding should help.


Related issues

Blocked by InfoVeg - Bug #3800: 1/28/2009 CONTAINER bugNew01/29/2009

History

#1 Updated by Michael Lee over 10 years ago

(In reply to comment #0)

done (v227p0204_mid5): 2) On the tree stems, some error is causing the database to crash from

function: select0IfThere() which is a trivial function that should simply
ignore errors. MTL to add error ignoring to that function.

#2 Updated by Michael Lee over 10 years ago

issue 3) from comment #0 is fixed in v227p0204_mid6

issue 4) from comment #0 if fixed in v227p0204_mid6

issue 5) from comment #0 is also fixed in v227p0204_mid6

I also fixed the herb data printing headers incorrectly for hand-error checking. Still need to fix the trees so they don't print on legal paper only.

#3 Updated by Michael Lee over 10 years ago

trees and now fixed and will print onto letter sized paper. I will now be importing project 89 data and testing this, so that counts as hammering on the database. I will also try to automate embedding errors (bug 3792)

#4 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 3786

Also available in: Atom PDF