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
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.
SAP Knowledge Base Article - Preview