SAP Knowledge Base Article - Preview

2758302 - UPDATE STATISTICS permission denied during phase MAIN_TRANSEXEC/UPDATE_DBSTATS_ACT_TRANS - SAP ASE for BS

Symptom

During SAP application upgrade phase MAIN_TRANSEXEC/UPDATE_DBSTATS_ACT_TRANS, all update statistics fail with error:

ETQ398XSQL: [SAPSR3.TABLE_NAME]' ')
4 ETQ394 "Updating INDEX statistics for table [SAPSR3.TABLE_NAME]"
4 ETQ394 ""
3 ETQ398 SQL: select $EXEC( 'UPDATE INDEX STATISTICS [SAPSR3.TABLE_NAME] ')
4 ETQ010 Date & Time: YYYYMMDDHHmmss
1EETQ008 Error message: DBSL error 99 (db code 10330): 
1EETQ009X[ASE Error SQL10330:42000][SAP][ASE ODBC Driver][Adaptive Server
1EETQ009XEnterprise]UPDATE STATISTICS permission denied on object TABLE_NAME,
1EETQ009Xdatabase XXX, owner SAPSR3


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 and higher

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver Application Server for ABAP 7.52 for SAP S/4HANA

Keywords

UPDATE STATISTICS, MAIN_TRANSEXEC/UPDATE_DBSTATS_ACT_TRANS, granular, permission, upgrade, upgrading , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.