The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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
385171826
accept rate: 20%

edited 15 Apr '13, 11:32

Volker%20Barth's gravatar image

Volker Barth
32.4k328476693


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
9.5k381121
accept rate: 39%

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:

×425
×87
×27

question asked: 15 Apr '13, 09:28

question was seen: 5,829 times

last updated: 22 Apr '13, 03:17