The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
345151624
accept rate: 0%

edited 15 Apr '13, 11:32

Volker%20Barth's gravatar image

Volker Barth
29.3k287438645


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
8.7k377106
accept rate: 40%

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:

×404
×79
×23

question asked: 15 Apr '13, 09:28

question was seen: 5,008 times

last updated: 22 Apr '13, 03:17