Symptom
CDS views and related objects, functions are missing during/after a SUM upgrade on SAP systems running on SAP ASE database.
Object rebuild via saphostctrl fails as shown below:
# /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
Password:
[PID 27158]
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
Read more...
Environment
-
SAP Adaptive Server Enterprise (ASE) 16.0 SP03 for Business Suite
- SUM 2.0
Product
Keywords
CREATE ANY FUNCTION, RECREATE_CDS_OBJECTS, SWPM , SUM, permission, saphostctrl, missing, functions, CDS, views, exit code: "20" , 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