SAP Knowledge Base Article - Preview

3212411 - SUM Error SQL567 returned for missing sa_role - SAP ASE for Business Suite

Symptom

SAP Netweaver SUM upgrade fails with Error SQL567 during MAIN_SHDCRE/SUBMOD_SHDDBCLONE/SYB_DBCLONE_UPDSTATS phase, like in this sample:

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.


Granting sa_role to user SAPSR3 is not an option. In case you try to do it, the SUM phase will continue to fail with errors, ie like this one:

1EETQ008 Error message: DBSL error 103 (db code 208):
1EETQ009X[ASE Error SQL208:42000]PUTTB_SHD not found. Specify owner.objectname
1EETQ009Xor use sp_help to check whether the object exists (sp_help may produce
1EETQ009Xlots of output).
1EETQ003 exit code: "20"


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SUM 2.0 SP14 PL03 or lower

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.5

Keywords

SQL567, SQL208, SAPSR3,  "granular permissions", CONFIG_GP, sa_role, MAIN_SHDCRE/SUBMOD_SHDDBCLONE/SYB_DBCLONE_UPDSTATS , 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.