POPULATE_USAGE_ANALYTICS_JOB failure

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The POPULATE_USAGE_ANALYTICS_JOB is failing since a few days ago.

The bg-ca.log file shows the following error:

Exception while processing the telemetry data :: 
SQL error code: 1400
Error message: ORA-01400: cannot insert NULL into ("NIKU"."CMN_USAGE_ANALYTICS_DATA"."EMPLOYMENT_TYPE")

Cause

Some Clarity resources do have the Employment Type field set to NULL and is expecting a value

Resolution

Check the Resources with the Employment type set to null and update their profile with a value.

• The query below will provide you the list of resources affected:
  • SELECT * FROM SRM_RESOURCES WHERE PERSON_TYPE IS null
• Once you have identified the resources, set their Employment type at Administration > Organization and Access > Resources