We are getting the following error as soon as the database is started.

[Sybase][ODBC Driver][SQL Anywhere]Internal database error ERROR Assertion failed: 200114[Proper] (11.0.1.2661) Can't find values for row 212b76:39 in index 'APRE_KEXTENDEDVALUE' -- transaction rolled back

Not certain about the best thing to do next. We have the last backup but not its log, and the current active log.

I also get the error almost as soon as the validating starts, so things dont look good for this db. Does this mean that the db is corrupted? So I'm now looking at going to the last backup and translating the current active log, but I have never done this before.

asked 05 Dec '12, 15:07

Aragorn's gravatar image

Aragorn
1112
accept rate: 0%

edited 05 Dec '12, 15:39


I found your error message (at least a very similar one) indicating a corrupted file.

Hope that helps.

http://www.symantec.com/connect/forums/sep121-ru1-assertion-failed-200114sem5-11012472

permanent link

answered 05 Dec '12, 15:13

Derli%20Marcochi's gravatar image

Derli Marcochi
1.6k323877
accept rate: 33%

edited 05 Dec '12, 15:14

Comment Text Removed

Assertion 200114 occurs when the server has attempted to lookup a value in the named index but for some reason the index entry was not found. This may happen either because your database is corrupted, a hardware glitch, or a software problem (Note: build 11.0.1.2583 fix such a problem - with LIKE predicate range queries - that would have caused this assertion).

I would start by validating your database (a full validate database, not an express check) to verify (or confirm) that your database is (or is not) corrupted.

If the database appears to not be corrupted then if the problem occurs again then I would suggest that you contact Tech Support (see Contact Us link at bottom of this page) to work with them to determine the cause of your problem.

permanent link

answered 05 Dec '12, 15:18

Mark%20Culp's gravatar image

Mark Culp
24.9k10139297
accept rate: 41%

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:

×48
×7

question asked: 05 Dec '12, 15:07

question was seen: 5,446 times

last updated: 05 Dec '12, 15:39