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:
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.
Release: 15.9.3, 16.0.0, 16.0.1, 16.0.2
DE65262 - The error is caused by a missing database procedure (clb_modify_folder_perms_sp).
Targeted Fix in Release 16.0.3