1961125 - How to fix a table with 605 errors - SAP ASE

• On SAP ASE systems running custom (non-SAP) applications, a read failure error was reported in the ASE errorlog. 
  
  NOTE: For systems running SAP applications see SAP KBA 2243660 - How to fix repair and rebuild a corrupt table - SAP ASE for Business Suite

server  Starting diagnostics for read failure:
server  Device Information:
     Device number = 7
     Phyname = /dev/datadev_02
server  Buffer Information:
     Buf addr = 0x10054d16778, Mass addr = 0x10054d16778
     Buf pageno = 1994188, Mass pageno = 1994188, dbid = 4
server 
     Buf virtpg = 1994188, Mass virtpg = 945612
     Buf stat = 0x1, Mass stat = 0x1008
     Mass keep = 1, Mass awaited = 0
server  Page Information from first read attempt: Page read from disk ppageno = 1994188, pptnid = 245572882, pindid = 0 pnextpg = 1994175, pprevpg = 1994055 plevel = 0, pstat = 0x11 pts_hi = 1, pts_lo = 488777306
server  Page Information from second read attempt: Page read from disk ppageno = 1994188, pptnid = 245572882, pindid = 0 pnextpg = 1994175, pprevpg = 1994055 plevel = 0, pstat = 0x11 pts_hi = 1, pts_lo = 488777306
server  SDES Information:
     dbid = 4, objid = 1008003591, sptnid = 1008003591 scur.pageid = 1994188
     sstat = 0x0, sstat2 = 0x20
     suid = 1, cacheid = 0
server  PSS Information:
     pstat = 0x10100, pcurdb = 4, pspid = 21
     p2stat = 0x1000, p3stat = 0x800
     plasterror = 0, preverror = 0, pattention = 0
server  End diagnostics for read failure:

• It was followed by a stacktrace that inluded functions:

wrongpage__print_diagnostic
wrongpage
_$o1cexoH0.getpage_with_validation
ncinsert
_$o1cexzK0.ins_insert

• And resulted in Error 605:

server  Run the DBCC command 'dbcc tablealloc' for both the objects, object id = 1008003591, partition id = 245572882.server 
Error: 605, Severity: 21, State: 1
server  An attempt was made to fetch logical page '1994188' from cache 'default data cache'. Page belongs to database 'xxxxx' (4), object 'xxxxx' (245572882), index '<Unknown>' (0), partition 'xxxxx_245572882' (245572882) and not to database 'xxxxx' (4), object 'xxxxx' (1008003591), index 'xxxxx' (0), partition 'xxxxx_1008003591' (1008003591).

SAP Adaptive Server Enterprise (ASE). Not version specific.

corruption, syspartitions, object_name, checktable, checkdb, checkalloc, tablealloc, transient, hardware, severe error, different sort order, system error, restore, crash, object, full extent, configuration block, sort order , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To