Symptom
- Database dbccdb has database option "allow nulls by default" on.
- Got error 614 when running update index statistics on scan workspace (ex. scan_pubs2):
1> update index statistics scan_pubs2
2> go
Msg 614, Level 21, State 7:
Server 'XXXX', Line 1:
Adaptive Server accessed a row that has an illegal length of 0 while in data base 'dbccdb'. Page pointer = 0x0x14d0ef800, pageno = 3376, status = 0x81, ptnid
= 1440005130, indexid = 0, level = 0. The minimum row length is 25. The page size is 2048.
ASE is terminating this process.
-
Got error 2508 when running dbcc checktable on scan workspace (ex. scan_pubs2):
1> dbcc checktable(scan_pubs2)
2> go
Checking table 'scan_pubs2' (object ID 1440005130): Logical page size is 2048 bytes.
Checking partition 'scan_pubs2_1440005130' (partition ID 1440005130) of table 'scan_pubs2'. The logical page size of this table is 2048 bytes.
Msg 2508, Level 16, State 1:
Server 'XXXX', Line 1:
Table Corrupt: Row length is incorrect (page number 3376, partition ID
1440005130; row number 0; minimum row length = 25; row length = 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) on 15.7 and 16.0
Product
Keywords
614, 2508, dbccdb, dbcc checktable, update index statistics, scan workspace, allow nulls by default , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.