SAP Knowledge Base Article - Preview

3702961 - Update statistics fails with error 1759 - SAP ASE for Business Suite

Symptom

  • Update statistics job for a table fails in DBA cockpit.

  • From ATM logs:
     
        Server message:
        Command 'UPDATE STATISTICS' number of step values requested '0' must be greater than or equal to '3' values.
        Server 'xxx', Line 1:
        Msg 1759, Level 16, State 1:
        Update statistics of tablename failed

  • DBACOCKPIT > Diagnostics > ATM History (update statistics of failed tablename shows the below:)

             Maintenance Triggering ATM Profile: Monitoring Tables (SAP Default)
             update index statistics tablename using 0 values with partial_hashing

  • So, re-executing the above command also fails:

         update index statistics tablename using 0 values with partial_hashing
         go
         Msg 1759, Level 16, State 1:
         Server 'xxx', Line 1:
         Command 'UPDATE STATISTICS' number of step values requested '0' must be greater than or equal to '3' values. 

  


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) for Business Suite
  • SAP NetWeaver (NW) - All versions - Not version specific
  • SAP Adaptive Server Enterprise

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management 7.0

Keywords

Msg 1759, Level 16, State 1, update statistics fails, atm, dbacockpit, number of steps , 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.