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( 'use DFA ')</stmt>
<stmt>select $EXEC( 'update INDEX statistics sysobjects ')</stmt>
<stmt>select $EXEC( 'update INDEX statistics sysindexes ')</stmt>
<stmt>select $EXEC( 'update INDEX statistics syscolumns ')</stmt>
<stmt>select $EXEC( 'update INDEX statistics syspartitions ')</stmt>
<stmt>select $EXEC( 'update INDEX statistics systabstats ')</stmt>
<stmt>select $EXEC( 'update INDEX statistics sysstatistics ')</stmt>
<stmt>select $EXEC( 'update INDEX statistics syscomments ')</stmt>
</sqlexec>

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

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.