Assertion error (200610, 201503)

[#1]

Hi All,

I have an issue report by my client on SQL Anywhere version 10.0.1.4051 database.

After further verification of database,  found that there is one table which is causing the problem and throwing the errors.

I tried dropping this table as it's just a reference table but it don't allow me to do that.

The error I am getting are

The table's row count could not be obtained from the database. Internal database error *** ERROR *** Assertion failed: 201503 (10.0.1.4051) Record 0x32e not present on page 0x0:0x398 -- transaction rolled back [Sybase][ODBC Driver][SQL Anywhere]Internal database error *** ERROR *** Assertion failed: 201503 (10.0.1.4051) Record 0x32e not present on page 0x0:0x398 -- transaction rolled back SQLCODE: -301 SQLSTATE: HY000 SQL Statement: SELECT COUNT(*) FROM "dev"."salesum"

E. 09/08 10:53:55. *** ERROR *** Assertion failed: 200610 (10.0.1.4051)

E. 09/08 10:53:55. Attempting to normalize a non-continued row (0x10:0x2)

Can someone help me identify the way to delete this particular table

Thanks

Ramendra

[Former Member · Accepted solution]

Hello Ramendra,

Please look at this KB article

http://service.sap.com/sap/support/notes/1959030

It describes how to unload and reload a database working around a corrupt table.

[Former Member · Accepted solution]

Hi Mark,

Thanks for the reply.

I am not able to access the link due to restricted access to the URL.

Can you please help me identify the alternate or please share the content.

Regards

Ramendra

[Former Member · Accepted solution]

Hello Ramendra,

I've exported the PDF content to the attached zip file.

Rename the file as a .PDF file when you extract it from the zip

Thanks

Mark

1959030 - How To Salvage Data When There are Corrupt Pages in the Database.txt.zip

[former_member207653 · Accepted solution]

https://websmp101.sap-ag.de/~sapidp/011000358700000560361996E

Ramendra,

It is recommended that you either contact SAP Global Support Customer Interaction Team (see link above) so they can create an account for you or ask the s-user in your company to access technical documents.

Thank you.

[Former Member · Accepted solution]

Thanks Mirco,

I am trying to get my ID created as soon as possible.

Regards

Ramendra