SAP Knowledge Base Article - Preview

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

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

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