Failure During Upgrade to Clarity 16.4.1 or Later Versions

Products

• Clarity PPM On Premise
• Clarity FedRAMP
• Clarity PPM SaaS

Issue/Introduction

While upgrade to 16.4.1 or above fails with below error

5/21/26 12:48 AM (ExecTask) 
5/21/26 12:48 AM (ExecTask) ALTER TABLE CMN_SCH_JOBS ALTER COLUMN NAME nvarchar ( 4000 ) NOT NULL
5/21/26 12:48 AM (ExecTask) 
5/21/26 12:48 AM (ExecTask) com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'NAME', table 'niku.CMN_SCH_JOBS'; column does not allow nulls. UPDATE fails.
5/21/26 12:48 AM (ExecTask) 	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)
5/21/26 12:48 AM (ExecTask) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1676)
5/21/26 12:48 AM (ExecTask) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:907)
5/21/26 12:48 AM (ExecTask) 	at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:802)

 

Environment

Clarity 16.4.1 and above

Cause

This issue occurs because the NAME column in the CMN_SCH_JOBS table has been updated to a NOT NULL constraint. If a customer has any job definitions where the NAME value is NULL (which constitutes a data integrity issue), the upgrade may fail.

Therefore, prior to running the upgrade, it is recommended to execute the SQL query below to verify whether any NULL values exist in the NAME column and correct the data accordingly.

select name,job_definition_id,count(*)
from
	CMN_SCH_JOBS
where
	name is NULL
group by
	name,
	job_definition_id

 

Resolution

The fix is to ensure name columns is not null by following below steps 

• Ensure clarity services are stopped 
• Back up the table CMN_SCH_JOBS
• Perform an update 

  UPDATE CMN_SCH_JOBS
  SET name = 'NEW_JOB_NAME'
  WHERE name IS NULL
    AND job_definition_id = 'PASS THE JOB DEFINATION ID';
  --pass the job_definition_id 
  -- If rows affected matches your select count:
  COMMIT;

• Start the Clarity Services and perform sanity
• Start preforming upgrade