Symptom
On ASE 160 SP03 PL0x, rebuilding CUDFs via saphostctrl fails due to missing password for "sapsso" user in the LocaL Secure Store of the SAP Host Agent.
C:\Program Files\SAP\hostctrl\exe>saphostctrl -user sapadm <password> -dbname ABC -dbtype syb -function LiveDatabaseUpdate -updatemethod Execute -updateoption TASK=SETUP_CUDFS
Error: Command execution failed. : Grants for creating and dropping udfs failed.
(fault code: 127)
Operation ID: 005056AF598D1ED988E9CD6EFFB860CE
----- Log messages ----
Info: saphostcontrol: Executing LiveDatabaseUpdate
Error: sapdbctrl: Grants for creating and dropping udfs failed.
Error: saphostcontrol: LiveDatabaseUpdate failed (sapdbctrl exit code = 1)
Executing saphostctrl with traceflag=3, the dev_sapdbctrl log shows --
LAST OS-ERROR: (0) : The operation completed successfully.
[PID 1312] [PID 1312] LAST OS-ERROR: (0) : The operation completed successfully.
[PID 1312] DBConfigPath is E:\sybase\ABC\sapdbctrl-config
[PID 1312] LiveUpdateOption SETUP_CUDFS
[PID 1312] error: password for sapsso user not found in SecStore.
[PID 1312] Grants for creating and dropping udfs failed.
[PID 1312] *** ERROR => 'Database live update' failed: Grants for creating and dropping udfs failed.
error: password for sapsso user not found in SecStore.
[sapdbctrl.cp 3850]
sapparam: sapargv(argc, argv) has not been called!
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 for Business Suite
- SAP Host Agent 7.21 (latest SP)
Product
Keywords
saphostctrl, SETUP_CUDFS, sapsso, password, missing, "Secure Store", "Local Secure Store", "Grants for creating and dropping udfs failed", recreating, cudfs , 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