[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


sybase consistency check errors

Posted on 2010-01-08
Medium Priority
Last Modified: 2012-05-08
I getting below consistency check error, what should I do next to fix the problem

PleTax01 MYSQL_DBPT1> zcat MYSQL_DBPT1.Test.100106020001.cons.log.Z

Consistency Check is started as part of
backup_sybase MYSQL_DBPT1 -checkstorage started 10-01-06.02:00:00
Consistency Check run 02:00:01 - 10-01-06.02:05:55

MYSQL_DBPT1.Test   : Consistency check FAILED CS 10-01-06.02:05:55


Database Name : Test

 Table Name              Index  PartitionId Fault Type                Page Number
 ----------------------- ------ ----------- ------------------------- -----------
 Test_Belian_Dua      2   772314657 100012 (wrong type error)       76892
(return status = 0)
Question by:motioneye
LVL 24

Accepted Solution

Joe Woodhouse earned 2000 total points
ID: 26210216
Ok, first of all, we can't tell what you're doing since it looks like you're running an in-house script. It seems like the script is running dbcc checkstorage though.

If checkstorage throws an error, the next thing to do is to run dbcc checkverify instead (depending on exactly what version of ASE you have, though). Checkverify looks at the most recently run checkstorage and tries to verify if there's really a problem.

It might take a while to run!

It's all written up pretty well in the ASE 12.5.x Troubleshooting Guide, or the ASE 15.0.x Administration Guide.

Author Comment

ID: 26278044
OK let me try with checkverify.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Often times it's very very easy to extend a volume on a Linux instance in AWS, but impossible to shrink it. I wanted to contribute to the experts-exchange community a way of providing a procedure that works on an AWS instance. It can also be used on…
Moore’s Law has proven itself time and time again since it was first introduced. So what’s next? Will Moore’s law continue to remain relevant, or will new technology take over and bring us the next big advancement in computing?
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question