SAP Knowledge Base Article - Preview

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

Symptom

  • 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

Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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

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.