Question Re: Assertion error (200610, 201503) in Technology Q&A

Assertion error (200610, 201503)

Former Member — Tue, 08 Sep 2015 02:06:00 GMT

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

Re: Assertion error (200610, 201503)

Former Member — Tue, 08 Sep 2015 09:30:55 GMT

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.

Re: Assertion error (200610, 201503)

Former Member — Wed, 09 Sep 2015 00:51:46 GMT

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

Re: Assertion error (200610, 201503)

Former Member — Thu, 10 Sep 2015 08:51:13 GMT

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

Re: Assertion error (200610, 201503)

former_member207653 — Thu, 10 Sep 2015 09:49:30 GMT

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.

Re: Assertion error (200610, 201503)

Former Member — Fri, 11 Sep 2015 01:20:01 GMT

Thanks Mirco,

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

Regards

Ramendra