Symptom
SUM upgrade fails while updating statistics on database system tables -
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
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
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.