SAP Knowledge Base Article - Preview

3586360 - SETUP_CUDFS via saphostctrl fails with message Number 10353, Severity 14, State 6 - SAP ASE for Business Suite

Symptom

Rebuilding CUDFs via saphostctrl fails due to must have any of the following role(s) to execute this command/procedure: 'sa_role'

/usr/sap/hostctrl/work # /usr/sap/hostctrl/exe/saphostctrl -user sapadm <passwd> -dbname SID -dbtype syb -function LiveDatabaseUpdate -updatemethod Execute -updateoption TASK=SETUP_CUDFS
Error: Command execution failed. : Server message: Number 10353, Severity 14, State 6, Line 9, Server SID, Procedure SAPSR3.CUDF_VERSION --- Message string: You must have any of the following role(s) to execute this command/procedure: 'sa_role' . Please contact a user with the appropriate role for help. . (fault code: 127)
Operation ID: 005056BF3A0F1FE081AD6EB90D264F57


----- Log messages ----
Info: saphostcontrol: Executing LiveDatabaseUpdate
Error: sapdbctrl: Server message: Number 10353, Severity 14, State 6, Line 9, Server SID, Procedure SAPSR3.CUDF_VERSION --- Message string: You must have any of the following role(s) to execute this command/procedure: 'sa_role' . Please contact a user with the appropriate role for help. .
Error: saphostcontrol: LiveDatabaseUpdate failed (sapdbctrl exit code = 1) 

In LiveUpdatelog:

 == LiveUpdate started == 
 TASK_NAME=SETUP_CUDFS
  SETUP_CUDFS=Failed to find credentials for sapsso user.

  == LiveUpdate started == 
  TASK_NAME=RECREATE_GTTS
  RECREATE_GTTS=ok

 == LiveUpdate started == 
  TASK_NAME=SETUP_CUDFS
  SETUP_CUDFS=Failed to find credentials for sapsso user.

  == LiveUpdate started == 
  TASK_NAME=SETUP_CUDFS
  SETUP_CUDFS=Server message: Number 10353, Severity 14, State 6, Line 9, Server SID, Procedure SAPSR3.CUDF_VERSION --- Message string: You must have any of the following role(s) to execute this command/procedure: 'sa_role' . Please contact a user with the appropriate role for help. .


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite.
  • SAP Host Agent 7.21 and Higher.

Product

SAP NetWeaver Application Server for ABAP 7.52

Keywords

message: Number 10353, saphostctrl, SETUP_CUDFS, sapsso, password, missing, "Secure Store", "Local Secure Store", "Grants for creating and dropping udfs failed", recreating, cudfs ,sa_role,CUDF_VERSION , 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.