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
  • SUM 1.0 and 2.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.