SAP Knowledge Base Article - Preview

3212411 - ERROR in SUM SQL567 You must have the following roles - SAP ASE BS

Symptom

Netweaver upgrade getting error during MAIN_SHDCRE/SUBMOD_SHDDBCLONE/SYB_DBCLONE_UPDSTATS phase:

3 ETQ398XSQL: HISTOGRAM_TUNING_FACTOR=20'
3 ETQ398XUPDATE INDEX STATISTICS [SAPSR3./1BS/TEST_T_FK] USING 20 VALUES WITH
HISTOGRAM_TUNING_FACTOR=20
3 ETQ398XSQL: EXEC sp_flushstats [SAPSR3./1BS/TEST_T_FK]
3 ETQ398XSQL: END ')
4 ETQ010 Date & Time: 20220609152101
1EETQ008 Error message: DBSL error 99 (db code 567):
1EETQ009X[ASE Error SQL567]You must have the following role(s) to execute this
1EETQ009Xcommand/procedure: 'sa_role'. Please contact a user with the
1EETQ009Xappropriate role for help.



Read more...

Environment

  • SAP Adaptive Server Enterprise ASE 16.0
  • SUM 2.0

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5

Keywords

granular permissions, CONFIG_GP, sa_role , 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.