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
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.