SAP Knowledge Base Article - Preview

1887222 - Error 9840 "Internal hash based statistics collection error on column < column_name>. " when running "update index statistics" with hashing. - ASE

Symptom

  • After the "update statistics hashing" configuration is activated,  running "update index statistics ... with hashing" raises Error 9840:

Msg 9840, Level 20, State 10:
Internal hash based statistics collection error on column (< column_name> ). Contact sybase technical support for help.

  • Stack elements extracted under traceflag 3601 when hitting error 9840:

stu_sparse_hist_to_range()
stu_collapse_range()
st_reduce_frequency_cell_range1()
stu_nosort_merge_hist()
stu_nosort_range()
ups_nosort_insert()
statgather()
ups_build_gather_stats()


. " when running "update index statistics" with hashing. - ASE"> Read more...

Environment

SAP Adaptive Server enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

optdiag, statistics, hashing, create index, statement, aborted , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.