System error when assigning resources to a task

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

While trying to assign a resource to a task, a "System error. Contact system administrator." message is displayed.

When checking the logs, a message similar to this one can be observed:

Arithmetic overflow error for data type smallint, value = xxxxx.

SQL error code: 3621

Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.

Executed:

update odf_ca_assignment set id = id  , odf_nk_uni_all =  xxxx.NK_PARSE_CURVE_FCT(uni_all)  , odf_nk_uni_est_act_bck =  xxxx.NK_PARSE_CURVE_FCT(uni_est_act_bck)  , odf_nk_uni_har_all =  xxxx.NK_PARSE_CURVE_FCT(uni_har_all)  where id = ?

Environment

Microsoft SQL Server Clarity environments only.

Resolution

Remove and add the resource to the Team (Staff).