Creating a new API token returns "An error occurred while creating API token" instead of displaying API key popup

Products

• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce:

1- Modern UX, click on Profile icon and then  API Keys

2- Create a new API key 

Expected Results:  User is presented with a API key popup

Actual Results: User receives an error:  An error occurred while retrieving API token

The app-ca.log file will have the following error:

ERROR 2023-06-20 09:22:25,442 [http-nio-8080-exec-57] ppm.rest (clarity:[email protected]:x__x-x-x-x-x:PPM_REST_API) Salt is not configured

Environment

Release : 16.1.2

Cause

An option is missing in the CMN_OPTIONS and CMN_OPTION_VALUES tables for ACCESS_TOKEN_SALT

Resolution

Validate whether the option is missing with this query (Postgres):

select * from cmn_option_values where option_id in (select id from cmn_options where option_code='ACCESS_TOKEN_SALT');

If this returns no rows, then run the following SQL statements:

create table cmn_options_backup as select * from cmn_options co ;

create table cmn_option_values_backup as select * from cmn_option_values;

call cmn_options_ins_sp('ACCESS_TOKEN_SALT','ACCESS_TOKEN_SALT','',1,1,1);

call cmn_option_values_ins_sp ('ACCESS_TOKEN_SALT','','','1',1);

Go to System Options and add a new minimum 32 character string for the SALT