CDS object/view recreation via saphostctrl fails due to below error (Msg 10331) on a newly-installed SAP system running on SAP ASE.
The system was installed via SWPM and updated soonafter via SUM.
SAP KBA 2195659 is being followed to (re)build CDS views explicitly via saphostctrl because the underlying functions were not built correctly during the installation and upgrade.
# /usr/sap/hostctrl/exe/saphostctrl -user sapadm - -dbname XYZ -dbtype syb -function LiveDatabaseUpdate -updatemethod Execute -updateoption TASK=RECREATE_CDS_OBJECTS
[PID 27158] SigISetDefaultAction : default handling for signal SIGCHLD
[PID 27158] DBConfigPath is /sybase/XYZ/sapdbctrl-config
[PID 27158] LiveUpdateOption RECREATE_CDS_OBJECTS
[PID 27158] recreating cds objects.
[PID 27158] cudf create script was found and will be used: /sybase/XYZ/ASE-16_0/scripts/create_cudf.sql
Thu Jul 5 17:20:14 2018
failed. Error: Msg 10331, Level 14, State 2:
Server 'HCM', Procedure 'SAPSR3.CUDF_VERSION', Line 9:
Permission denied, database XYZ, owner dbo. You need the following permission(s) to run this command: CREATE ANY FUNCTION.
[PID 27158] *** ERROR => 'Database live update' failed: execution of statement
SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL04 for Business Suite
- SUM 2.0 SP01 and above
CREATE ANY FUNCTION, RECREATE_CDS_OBJECTS, SWPM , SUM, permission, saphostctrl, missing, functions, CDS, views, exit code: "20" , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.