1999717 - Msg 7327 when running optdiag - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1999717 - Msg 7327 when running optdiag - ASE

Symptom

  • While analyzing a performance problem, the following issue is seen in optdiag:
    • Total density” value is negative
    • Example: The weight is > 1 (It is 2.2 ==> 220%)
    • Msg 7327: Length or precision specification 0 is not within the range of 1 to 255.
    • The datatype value is outside the domain of legal values for the datatype.
       

See example below:

Statistics for column:                                                          "value_varchar"
Last update of column statistics:                                               Apr  1 2014  3:40:40:940PM
Range cell density:                                                        0.0923605113835048
Total density:                                                             -0.0903774600987818
Range selectivity:                                                         default used (0.33)
In between selectivity:                                                    default used (0.25)
Unique range values:                                                       0.0000011997168668
Unique total values:                                                       0.0000011997168668
Average column width:                                                      13.2947999620242125
Statistics version:                                                        4
 
Histogram for column:                                                           "value_varchar"

Column datatype:                                                                varchar(512)
Requested step count:                                                           20
Actual step count:                                                              4
Sampling Percent:                                                               0
Tuning Factor:                                                                  20
Out of range Histogram Adjustment is DEFAULT.                                 
High Domain Hashing.                                                          
Sticky hashing.                                                                
 
Server Message: SERVER - Msg 7327, Level 15, State 4:
Length or precision specification 0 is not within the range of 1 to 255.
 
cs_convert() returned CS_FAIL.
Optdiag failed.  Check for error messages above.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 #4.2

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , cr722517 , 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 ONE Support launchpad (Login required).

Search for additional results

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