Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

edited 15 Apr '13, 11:32

Volker%20Barth's gravatar image

Volker Barth
40.5k365556827


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
12.0k396166
accept rate: 37%

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:

×439
×95
×30

question asked: 15 Apr '13, 09:28

question was seen: 7,476 times

last updated: 22 Apr '13, 03:17