SAP Knowledge Base Article - Preview

3593169 - Huge Weight value of column statistics causes ST22 dump in DBA Cockpit - Business Suite on SAP ASE

Symptom

When performing a "Single Table Analysis" in DBA Cockpit for a specific table, an Internal Server Error 500 occurs stating "******* not being interpreted as a number".

  • The issue is accompanied by a stack trace (dump) starting with:

    Category: ABAP programming error
    Runtime Errors: CONVT_NO_NUMBER
    ABAP Program: CL_IXML=======================CP
    Application Component: BC-ABA-XML

  • Optdiag for the target table shows huge Weight on a column statistics:

    Histogram for column:                                                           "col1"
    Column datatype:                                                                varbinary(16)
    Requested step count:                                                           800
    Actual step count:                                                              40000
    Sampling Percent:                                                               0
    Tuning Factor:                                                                  50
    Out of range Histogram Adjustment is DEFAULT.
    Low Domain Hashing.

         Step     Weight                    Value
            1     6955618650492923300000000000000000.00000000       <=       0x000b8e5238195575e1000000041c1234
            2     0.00000387        <       0x00278a48758f0a62e1000000041c0666

            3     0.00005130        =       0x00278a48758f0a62e1000000041c0666

  • In another case, a query accessing a column with an invalid histogram weight value reported a 318 error.

    Msg 318, Level 18, State 12:
    Server 'SYB', Line 1:
    sysstatistics catalog was read and an inconsistency was found, please run update statistics and contact Sybase Technical Support

    SQL Message: [ASE Error SQL318][SAP][ASE ODBC Driver][Adaptive Server Enterprise]sysstatistics catalog was read and an inconsistency was found, please run update statistics and contact Sybase Technical Support


Read more...

Environment

Business Suite on Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Single Table Analysis, Internal Server Error 500, CONVT_NO_NUMBER, ABAP programming error, Weight, column statistics , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.