Integrated Content Experience panel is not opening on 16.0.2 due to SRM_RESOURCES.FULLNAME length

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Integrated Content Experience panel is not opening and thats because the hidden Populate Usage Analytics Job fails fails if the data length of FULL_NAME columns of SRM_RESOURCES is more then 64 characters 

Steps to Reproduce: 

1. Xog in a resource and ensure combination of First name and Last Name is more than 70+ characters
2. Update the job definition POPULATE_USAGE_ANALYTICS_JOB & TELEMETRY_JOB and make it visible by running the below update
   • UPDATE CMN_SCH_JOBS
     SET IS_VISIBLE = 1
     WHERE name IN ('POPULATE_USAGE_ANALYTICS_JOB','TELEMETRY_JOB')
   • UPDATE CMN_SCH_JOB_DEFINITIONS
     SET IS_ADMIN_VISIBLE = 1
     WHERE JOB_CODE IN ('POPULATE_USAGE_ANALYTICS_JOB','TELEMETRY_JOB')
3. Log out of clarity and login back
4. Run the select and ensure FULL_NAME columns of SRM_RESOURCES is more then 64  and can be checked by running the query 
   • select max(length(full_name))  from srm_resources
5. Navigate to Clarity Home --> Reports and Jobs and search for Populate Usage Analytics
6. Run the job Populate Usage Analytics 

Expected Results: The Integrated Content Experience panel (ICE) panel should open once the help button is clicked and also the job should complete successfully and insert data into table CMN_USAGE_ANALYTICS_DATA

Actual Results: Once the help button is clicked on modern ux, a new tab is opened and  documentation site techdocs.broadcom.com open and the job actually shows completed with in less than 1 second even though it failed as log shows below error 

Exception while processing the telemetry data :: 
SQL error code: 0
Error message: ERROR: value too long for type character varying(64)
Executed:
insert into cmn_usage_analytics_data ( user_id, license_type, employment_type, primary_role, is_admin )

Environment

Release : 16.0.2

Resolution

This is due to DE65122, DE65105, fixed in 16.0.3 and 16.0.2.1

Workaround: 

• Stop all the Clarity services 
• Alter the table by running the below queries based on database 
  • MS SQL Server   - ALTER TABLE CMN_USAGE_ANALYTICS_DATA  ALTER COLUMN PRIMARY_ROLE VARCHAR2(300)
  • Oracle -  ALTER TABLE CMN_USAGE_ANALYTICS_DATA  MODIFY PRIMARY_ROLE VARCHAR2(300)
  • PostgreSQL - ALTER TABLE CMN_USAGE_ANALYTICS_DATA ALTER COLUMN PRIMARY_ROLE TYPE VARCHAR(300) using primary_role::varchar(300) 

Additional Information

• Reference 16.0.2 Clarity and Jaspersoft Cumulative Patch README Files