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 DFA, 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, Failed, Upgraded , 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.