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

• 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.

SAP Adaptive Server Enterprise (ASE) on 15.7 and 16.0

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