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 - SAP ASE 15.7

Symptom

  • After switching "update statistics hashing" on
  • Running an update index statistics command "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 - SAP ASE 15.7"> 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.