Symptom
- To avoid the issue as mentioned in the SAP KBA 2147566, tried to run update index statistics without hashing option but the same signal 8 also happened at stu_sortrange_to_hist().
- The statistics of table in question was updated by update index statistics with hashing and the optdiag output of the table contained "sticky hashing".
Histogram for column: "amount"
Column datatype: money
(omit)
Sticky hashing. - The "no_hasing" option was not helpful to avoid the issue.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR823218, CR#823218, 823218, stu_sortrange_to_hist() , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.
SAP Knowledge Base Article - Preview