SAP Knowledge Base Article - Preview

3079814 - SUM Error SQL10330 UPDATE STATISTICS permission denied on ASE system tables - SAP ASE for Business Suite

Symptom

  • SUM upgrade fails while updating statistics on database system tables:
    EXECUTING /usr/sap/SID/SUM/abap/bin/SAPuptool execdb ../var/SYBUPDCATSTATS.TSQL
    Logging to '/usr/sap/SID/SUM/abap/log/SYBUPDCATSTATS.LOG' 
    1EETQ008 Error message: DBSL error 99 (db code 10330): 
    1EETQ009X[ASE Error SQL10330:42000]UPDATE STATISTICS permission denied on 
    1EETQ009Xobject sysobjects, database SID, owner dbo 
    1EETQ003 exit code: "20" 
    SAPup> Process with PID 26032 terminated with status 20 at 20210721205354!  
 
  • Content of /usr/sap/SID/SUM/abap//var/SYBUPDCATSTATS.TSQL

    <?xml version="1.0"?>
    <sqlexec outfile="/usr/sap/DFA/SUM/abap/log/SYBUPDCATSTATS.LOG" crcvalue="c0bd6768">
    <stmt>select $EXEC( &apos;use DFA &apos;)</stmt>
    <stmt>select $EXEC( &apos;update INDEX statistics sysobjects &apos;)</stmt>
    <stmt>select $EXEC( &apos;update INDEX statistics sysindexes &apos;)</stmt>
    <stmt>select $EXEC( &apos;update INDEX statistics syscolumns &apos;)</stmt>
    <stmt>select $EXEC( &apos;update INDEX statistics syspartitions &apos;)</stmt>
    <stmt>select $EXEC( &apos;update INDEX statistics systabstats &apos;)</stmt>
    <stmt>select $EXEC( &apos;update INDEX statistics sysstatistics &apos;)</stmt>
    <stmt>select $EXEC( &apos;update INDEX statistics syscomments &apos;)</stmt>
    </sqlexec>

  • Granular permissions are set correctly on the ASE database - CONFIG_GP task completes successfully when executed via saphostctrl


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and higher for Business Suite
  • SAP NetWeaver (NW) - All versions
  • SUM 1.0 and 2.0

Product

SAP Adaptive Server Enterprise all versions ; SAP NetWeaver all versions ; software logistics toolset all versions

Keywords

Declined, refused, authorization, upgraded, update INDEX statistics, sysobjects , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.