SAP Knowledge Base Article - Preview

3444854 - 605 error occurs on table, dbcc tablealloc full fix did not resolve - table corruption message shown.

Symptom

The table corruption message shown.
The Error 605 occurs on table while running 'dbcc tablealloc' with full fix.

00:0007:00000:00912:2024/03/03 20:16:23.08 server  Error: 625, Severity: 21, State: 1
00:0007:00000:00912:2024/03/03 20:16:23.08 server  Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the entry in the offset table for that RID is less than or equal to 0. Rid pageid = 183594679; row num = 47. Page pointer = 0x0x7fa1c90fc800, pageno = 183594679, status = 0x91, ptnid = 71631994, indexid = 0, level = 0, pnextrno = 84.
00:0001:00000:00000:2024/03/03 20:17:16.36 kernel  Warning: The internal timer is operational and has recovered from previous failure.
00:0013:00000:00788:2024/03/03 20:19:49.00 server  Maxdumps (1) reached for error 625. Not performing shared memory dump.
00:0013:00000:00788:2024/03/03 20:19:49.00 server  Error: 625, Severity: 21, State: 1
00:0013:00000:00788:2024/03/03 20:19:49.00 server  Adaptive Server failed to retrieve a row via its RID in database 'xxx' because the entry in the offset table for that RID is less than or equal to 0. Rid pageid = 183594679; row num = 47. Page pointer = 0x0x7fa1c90fc800, pageno = 183594679, status = 0x91, ptnid = 71631994, indexid = 0, level = 0, pnextrno = 84.


Read more...

Environment

SAP ADAPTIVE SERVER ENTERPRISE 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Error: 625, Error: 605, dbcc tablealloc, dbcc checktable, index corruption , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.