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.

We have a client who is running Sybase 16.0.0.1535 and experienced an assertion error. We are trying to assist them with repairing the database by re-applying the current translated log file to the last good backup (using DBISQL to read the translated log file to the DB). It runs for a while and then crashes with the error:

Could not execute statement. Internal database error ERROR Assertion failed: 200610 (16.0.0.1535) Attempting to normalize a non-continued row (0xb26:0x0) -- transaction rolled back SQLCODE=-301, ODBC 3 State="HY000" File: "Trans.sql" on line 83027, column 1 You can continue executing or stop.

--SQL-1012-0004124849 alter table "DBA"."user_tab6_data" alter "Type_of_Misdemeanor" varchar(35)

Any help on this is greatly appreciated!

asked 13 Sep '13, 16:26

JGiguere's gravatar image

JGiguere
61116
accept rate: 0%

Have you validated the database to make sure the originaly DB is not corrupt?

(14 Sep '13, 16:29) ASchild

An unload/reload of a copy of the backup database may be necessary to remove any inconsistencies. Also, are you running any TRUNCATE statements on the database start-up event? It may be necessary to upgrade to the latest EBF

(14 Sep '13, 17:14) Mikel Rychliski

Thanks so much for the prompt replies! I had validated the backup copy of the database and also rebuilt that backup copy prior to trying to apply the translated log file to it and had receved the same error.
We are not running any truncate statements at startup.
I just got done trying to fix it with the latest EBF (16.0.0.1644) that was posted on Friday and that did fix the issue! I was able to apply the translated log file to the backup copy without any issues.

permanent link

answered 16 Sep '13, 13:42

JGiguere's gravatar image

JGiguere
61116
accept rate: 0%

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:

×186
×31

question asked: 13 Sep '13, 16:26

question was seen: 773 times

last updated: 16 Sep '13, 13:42