2486152 - Got error 614 / 2508 on scan workspace of dbccdb - SAP ASE | SAP Knowledge Base Article

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 'sp138', 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 'sp138', 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 ONE Support launchpad (Login required).

Search for additional results

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