SAP Knowledge Base Article - Preview

2439360 - 2540 Table Corrupt: Page is allocated but not linked - ASE

Symptom

The following error is reported when running checkalloc with no object name reported:

SQL Server message 2540, state 1, severity 16:
Table Corrupt: Page is allocated but not linked; check the following
pages and ids: allocation pg#=282420496 extent id=1548288 logical pg#=1548320
object id on extent=1548323 (object name = Invalid pointer param number 5, pointer value 0x18) indid on extent=822696760

  • Subsquent 2521 error is reported on a sytem table with the same page number

SQL Server message 2521, state 1, severity 16:
Table Corrupt: Page is linked but not allocated. Run DBCC TABLEALLOC
to correct the problem. (alloc page#=282420496, extent id=1548288, logical page#=1548320, object id in extent=1548325, index id in extent=24, object name=sysstatistics)

  • dbcc page on page 1548320 reports the following error

dbcc page (<database>,1548320, 0,0,0)
go

Msg 823, Level 24, State 1:
Server '<server>', Line 1:
I/O error detected during read for BUF=0x535d3800, MASS=0x535d3800, Buf#=0,
page=0x535d3000, dbid=0, Mass vpage=1548320, Buf lpage=0, Mass stat=0x900, Buf
stat=0x0, size=2048, cid=0 ('default data cache'), Pinned xdes=0x00000000,
spid=0.
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.