CA SAM: ERROR:utf8_bytelength is not executable

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

After performing of the CA SAM application this error is generated in the Check Installtion afterwards.

---db stored routines:  failed  Error:utf8_bytelegnth is not executable

Environment

Release: UAPMAC990JPP-14.1-Asset Portfolio Management-Asset Configuration
Component:

Cause

Permissions of user handling the upgrade are not sufficient.

The CA SAM user is missing the execute permission for the user defined function 'utf8_bytelength'.

 

 

Resolution

You can run the EXECUTE permission check yourself on the server:

SELECT  *
FROM    fn_my_permissions(N'utf8_bytelength', 'OBJECT')
WHERE   permission_name = N'EXECUTE';

When connected with the CA SAM user you will not get a result for this query.

You can also check the permission in the SQL Server Management Studio:

Server
-> Databases
--> CA SAM db
---> Programmability
----> Functions
-----> Scalar-valued Functions
------> dbo.utf8_bytelength

-> Right click
-> Properties
-> Permissions (on the left)
-> click 'Search' (on the right)
-> Enter/Browse CA SAM db user

-> Check Explicit or Effective permissions for the EXECUTE permission

It *should* be an Effective permission. That's what it is after initially creating a CA
SAM instance.