for some unknown reason I get the following error on Sqlanywhere 10 Database:

Internal database error ***ERROR*** Assertion failed: 202000 (10.0.1.3903).
Invalis string continuation at row id 0x11bee:0x0 -
transaction rolled back
SQLCODE=-301, ODBC 3 State="HY000"

Even when I try to rebuild the DB I get the same error during unloading. Could someone please help finding a solution?

asked 28 Aug, 07:11

Sarkis's gravatar image

Sarkis
2202725
accept rate: 0%

edited 28 Aug, 07:27

Breck%20Carter's gravatar image

Breck Carter
26.9k438609883

Restore from a backup.

(28 Aug, 07:27) Breck Carter

You might also try with the latest 10.0.1 EBF (10.0.1.4310 on Windows, AFAIK), if that issues the same assertion...

(28 Aug, 08:00) Volker Barth
Replies hidden

Where do you find V10 EBFs? I've only been able to find V12 in the archives...

https://support.sap.com/software.html
Support Packages & Patches - Access downloads
Archive by Alphabetical Index (A-Z)
S - SYBASE SQL ANYWHERE - 12.0
WINDOWS ON X64 64-BIT
Latest download: SQL Anywhere 12.0.1.4436 EBF
(28 Aug, 08:27) Breck Carter

I don't find them, I just happen to save the last EBF of each major version we have used:)

(Not sure whether I could find that within archived versions of our SAP Support Portal accounts...)

(28 Aug, 09:20) Volker Barth

(28 Aug, 09:30) Breck Carter

LOL! That was not meant by my claim "I don't find them":)

Of course, they are perfectly filed so I don't have to search for them...

(28 Aug, 10:16) Volker Barth

I could isolate the error source, there is was one cell (1 row / 1 column) in one of the tables which included some EXPLODABLE content. as soon as I try to query the row containing this row then I get the error, even when I try to update the value of this cell to a new value I get the same error.

The only solution was for me to delete this entire row, and then could find the same row in another remote DB and inserted it to this defective DB. The funny thing is that the remote DB has a correct value in this cell!! The DB is now healthy. Thanks for your efforts, could you but tell me what is meant with EBF?

(29 Aug, 07:34) Sarkis

An EBF is an Emergency Bug Fix, the former name for what now is called a SP aka Support/Service Pack.

Note when data is corrupted silently, it may be due to bad RAM...

(29 Aug, 07:48) Volker Barth

OK, thanks. Is there any such repairing tool available for DB of SQLAnyhwere 10?

(29 Aug, 07:50) Sarkis
Replies hidden

The second time you suggest it :)

(29 Aug, 10:11) Vlad
showing 5 of 11 show all flat view
Be the first one to answer this question!
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:

×86
×32

question asked: 28 Aug, 07:11

question was seen: 97 times

last updated: 29 Aug, 10:11