SAP Knowledge Base Article - Preview

2486152 - Got error 614 / 2508 on scan workspace of dbccdb - SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.