2016412 - Batches fail with errors 806 and 614 on temp tables - SAP ASE

• Batches fail with errors 806 and 614 on temp tables or error while running UPDATE STATISTICS WITH SAMPLING.
• All Dbccs comes out clean
• No OS/Hardware errors
• Stack trace reported for the 614 error
• Below errors can be reported

server  Error: 806, Severity: 21, State: 1
server  Could not find virtual page for logical page 1831691109 in database 'tempdb'.

Error: 614, Severity: 21, State: 12
server Adaptive Server accessed a row that has an illegal length of -23471 while in data base xxx. Page pointer = 0x10d79048000, pageno = 2943, status = 0x801, ptnid = 2071642903, indexid = 0, level = 0. The minimum row length is 22. The page size is 16384.
kernel ************************************
kernel SQL causing error : sion_id), -1))))

• The stack reports below function calls
  
  Stack for 614 Error
  kernel curdb = 7 tempdb = 2 pstat = 0x10000 p2stat = 0x901000
  kernel p3stat = 0x800 p4stat = 0x80 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
  kernel lasterror = 614 preverror = 0 transtate = 1
  kernel curcmd = 290 program = xxx
  kernel extended error information: hostname: <hostname> login: xxx
  kernel pc: 0x0000000081406b64 pcstkwalk+0x18
  kernel pc: 0x00000000814069ac ucstkgentrace+0x23c
  kernel pc: 0x0000000081402d64 ucbacktrace+0xd0
  kernel pc: 0x00000000807cdbb8 terminate_process+0x157c
  kernel pc: 0x0000000081096e40 hdl_default+0x50
  kernel pc: 0x0000000081095978 exc__raise+0x22c
  kernel pc: 0x0000000081095708 exc_raise+0x134
  kernel pc: 0x00000000804da414 _$o1cexmM0.dol_rowsize+0x8c
  kernel pc: 0x00000000803f219c dol_rowsize_plus_holepad+0x1c
  kernel pc: 0x00000000813364c0 sam__bld_ins_wktab_row+0xf4c
  kernel pc: 0x0000000081336adc sam__get_dol_pages+0x2a0
  kernel pc: 0x0000000081335564 stat_sam_ins_worktable+0x37c
  kernel pc: 0x0000000081333ee0 update_statistics_col+0xc24
  kernel pc: 0x0000000081334bb0 update_statistics_colset_driver+0x28c
  kernel pc: 0x000000008132d560 ups__updstats_column+0x1cc
  kernel pc: 0x000000008132c854 update_statistics+0x7d4
  
  Stack for the 806 error:
  server  Error: 806, Severity: 21, State: 1
  server  Could not find virtual page for logical page 1831691109 in database 'tempdb'.
  kernel  ************************************
  kernel  curdb = 12 tempdb = 2 pstat = 0x10000 p2stat = 0x901000
  kernel  p3stat = 0x1800 p4stat = 0xa0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
  kernel  lasterror = 806 preverror = 0 transtate = 0
  kernel  curcmd = 302 program = xxx
  kernel  extended error information: hostname:xxx login: xxxx
  kernel  pc: 0x0000000081406b64 pcstkwalk+0x18
  kernel  pc: 0x00000000814069ac ucstkgentrace+0x23c
  kernel  pc: 0x0000000081402d64 ucbacktrace+0xd0
  kernel  pc: 0x00000000807cdbb8 terminate_process+0x157c
  kernel  pc: 0x0000000081096e40 hdl_default+0x50
  kernel pc: 0x0000000081095978 exc__raise+0x22c
  kernel pc: 0x0000000081095708 exc_raise+0x134
  kernel  pc: 0x000000008060bc20 _$o1ceyjA0.log_to_virt+0xd8
  kernel  pc: 0x000000008050d7cc virtmap+0x10c
  kernel  pc: 0x000000008050ed54 bufgrab+0x2d4
  kernel  pc: 0x00000000803d3828 getpage_with_validation+0x6c8
  kernel  pc: 0x00000000813365b4 sam__bld_ins_wktab_row+0x1040
  kernel  pc: 0x0000000081336adc sam__get_dol_pages+0x2a0
  kernel  pc: 0x0000000081335564 stat_sam_ins_worktable+0x37c
  kernel  pc: 0x0000000081333ee0 update_statistics_col+0xc24
  kernel  pc: 0x0000000081334bb0 update_statistics_colset_driver+0x28c
  kernel  pc: 0x000000008132d560 ups__updstats_column+0x1cc
  kernel  pc: 0x000000008132c854 update_statistics+0x7d4
  kernel  pc: 0x000000008132d1e4 update_statistics_implicit+0x7a0
  kernel  pc: 0x0000000080ef5a60 stio_mem_upd_stats+0x328
  kernel  pc: 0x0000000080ef24a8 st_readstatistics+0x500
  kernel  pc: 0x00000000806d35d8 st_getstats+0x1dc
  kernel  pc: 0x0000000080eb1e78 qry_init_stats+0xcc
  kernel  pc: 0x0000000080efa50c st_readallstats+0xb0
  kernel  pc: 0x0000000080694938 void StCtlgAPIMgr::StCtlgCopyStats(OptBlock*,GttTable*,sdes*)+0x9c
  kernel  pc: 0x0000000080692c54 void GttTable::GttUsefulIndex(OptBlock*,int*)+0xd4

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

corruption, error 806, 614, illegal length, virtual page, logical page, auto_temptable_stats, login trigger, update statistics , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed