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 asked 15 Apr '13, 09:28 bgreiman Volker Barth |
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? answered 15 Apr '13, 09:40 John Smirnios 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
(16 Apr '13, 16:52)
bgreiman
Validation ran successfully yesterday. Thanks for your help!!!
(21 Apr '13, 12:50)
bgreiman
|