2244087 - Error 806 when running "update statistics" with hashing | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2244087 - Error 806 when running "update statistics" with hashing

Symptom

  • When running "update statistics" with hashing option
  • ASE errorlog report error 806
  • Followed by a stack trace which can include, amongst others, update_statistics_col_hash , update_statistics , getpage_with_validation
  • ASE errorlog entries include (offsets may vary by platform and version) : 
Error: 806, Severity: 21, State: 1
Could not find virtual page for logical page 123456789 in database 'sapsatempdb'.

Followed by stack trace :
log_to_virt+0x1c1()
virtmap+0x154()
bufgrab+0x378()
getpage_with_validation+0x757()
dol_qualrow+0x19a3()
dol_oamscan_getnext+0x162()
getnext+0x413()
ups_deadlock_getnext+0x45()
stat_ins_worktable+0x18e()
update_statistics_col_hash+0x70d()
update_statistics_colset_driver+0x485()
ups__updstats_column+0x2a3()
update_statistics+0x62a()

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.1

Keywords

update statistics,  hashing, 'error 806' , 'message 806' , 'msg 806'  , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.