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.
SAP Knowledge Base Article - Preview