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.
SAP Knowledge Base Article - Preview