Clarity upgrade fails on BRM_RULE_ACTION_TYPES (MSSQL)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Clarity upgrade to 16.1.1 on SQL Server fails with error: 

2/21/23 10:54 AM (ExecTask) com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'CATEGORY', table 'Clarity.niku.BRM_RULE_ACTION_TYPES'; column does not allow nulls. INSERT fails.
2/21/23 10:54 AM (ExecTask)

Environment

Release : 16.1.1 with MSSQL

Resolution

• The default on this table is not set.
• In OOTB vanilla systems the table BRM_RULE_ACTION_TYPES has a default for field CATEGORY called 'UI'
• This is why the insert does not fail as there is a column default
• Check the table DDL and update the table definition as needed: ALTER TABLE [niku].[BRM_RULE_ACTION_TYPES] ADD  DEFAULT ('UI') FOR [CATEGORY]