Validation Errors

[bgreiman]

SQL Anywhere Validation Utility Version 12.0.1.3810

Seeing several errors and wondering how critical each are and what it would take to correct:

Issue 1:

Orphaned page (00626777) found in database file "d:\\bersys\\central.db"
Orphaned page (0062677f) found in database file "d:\\bersys\\central.db"
Orphaned page (00627e43) found in database file "d:\\bersys\\central.db"
Orphaned page (00627e44) found in database file "d:\\bersys\\central.db"

Issue 2:

VALIDATE TABLE "DBA"."in_invoice_detail"
Row count mismatch between table "in_invoice_detail" and index "in_invoice_detail"
SQL error (-300) -- Run time SQL error -- Validation of table "in_invoice_detail" has failed
VALIDATE TABLE "DBA"."in_invoice_header"
SQL error (-300) -- Run time SQL error -- Validation of table "in_invoice_header" has failed

Thanks, Brian

[johnsmirnios]

Was the table modified by other connections while you ran the validation? If so, I believe it might be possible to see these errors reported. It is best to run validation when no other connections can change the database.

A bug with erroneous reporting of orphans was fixed in 12.0.1.3736 but it appears that you have that fix. Actually, the version you report comes from dbvalid -- does the server's version match?

[bgreiman]

It is possible that there was an open connection to the database. We run a validation once per week. I will see if the errors happen again.

Thanks, Brian

[bgreiman]

Validation ran successfully yesterday. Thanks for your help!!!