SAP Knowledge Base Article - Preview

2669081 - CREATE ANY FUNCTION permission is missing after SUM upgrade - SAP ASE for Business Suite

Symptom

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
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 PL04 for Business Suite
  • SUM 2.0 SP01 and above

Product

SAP ERP 6.0

Keywords

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 page

This 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.