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's gravatar image

bgreiman
400181927
accept rate: 20%

edited 15 Apr '13, 11:32

Volker%20Barth's gravatar image

Volker Barth
40.0k361549819


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?

permanent link

answered 15 Apr '13, 09:40

John%20Smirnios's gravatar image

John Smirnios
11.9k396164
accept rate: 38%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×438
×94
×30

question asked: 15 Apr '13, 09:28

question was seen: 7,337 times

last updated: 22 Apr '13, 03:17