Integrated Content Experience panel is not opening

book

Article ID: 242063

calendar_today

Updated On:

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 )

Cause

DE65122, DE65105    

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) 

Environment

Release : 16.0.2

Component : Clarity Studio

Resolution

  • Targeted Fix in Release 16.0.3 
  • Targeted Fix in Release 16.0.2 Patch #1 (16.0.2.1) 
  • GCP SaaS will have this fix implemented to all the customers in Release 16.0.2 Pre-Patch #1 

Additional Information