search cancel

DMS-02102 error when changing permissions of folder in the Knowledge Store

book

Article ID: 242864

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Classic PPM, PostgreSQL - When trying to change the permissions of a folder in the Knowledge Store and error DMS-02102 error is seen.  

Steps to Reproduce: 

  1. In Clarity go to Home-> Organization-> Knowledge Store 
  2. Create a new folder if none exists already 
  3. On a folder click the Actions dropdown and select Permissions 
  4. Click Save and Return (no update is required) 

Expected Results: The folder permissions are updated successfully. 

Actual Results: The error 'ERROR DMS-02102: A database error occurred while processing your request. Contact your system administrator.' is displayed. 

The following error is seen in the app-ca.log:

ERROR 2022-05-31 09:58:21,457 [http-nio-8080-exec-3483] niku.dms (clarity:[email protected]:21304207__D3DE65E9-FD0A-43B0-A2C0-65DF1EC60B4F:dms.KSmodifyFolderPermissions) error !!!
com.niku.ore.database.DatabaseException: An exception caused by: ERROR: procedure clb_modify_folder_perms_sp(bigint, bigint, bigint, character varying, character varying, character varying, character varying) does not exist
  Hint: No procedure matches the given name and argument types. You might need to add explicit type casts.

Cause

DE65262 - The error is caused by a missing database procedure (clb_modify_folder_perms_sp). 

Environment

Release: 15.9.3, 16.0.0, 16.0.1, 16.0.2

Postgres Database 

Resolution

Targeted Fix in Release 16.0.3