Symptom
- During SAP application upgrade phases MAIN_TRANSEXEC/UPDATE_DBSTATS_ACT_TRANS or MAIN_SWITCH / XCNV_LOAD 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
- This can also happen after the upgrade. Update statistics is not executed via ATM, no information in ATM queue and from ATM log you can see the error:
UPDATE STATISTICS permission denied on object TABLE_NAME, database DB_NAME, owner SAPSR3
Msg 10330, Level 14, State 1:
Server message:
Update statistics of DB_NAME.SAPSR3.TABLE_NAME
(return status= -4)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 or higher for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
UPDATE STATISTICS, MAIN_TRANSEXEC/UPDATE_DBSTATS_ACT_TRANS, granular, permission, upgrade, upgrading, MAIN_SWITCH / XCNV_LOAD , 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.