Time slicing job fails with Arithmetic overflow error post upgrade

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Time Slicing job is failing after the upgrade to 15.9.1 with this error in the bg-ca.log:

ERROR 2021-04-06 12:37:22,834 [Dispatch Time Slicing : (tenant=clarity)] niku.blobcrack (clarity:admin:....:Time Slicing) Exception during blobcrack process
com.niku.union.persistence.PersistenceException:
SQL error code: 8115
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Arithmetic overflow error converting expression to data type int.
SQL error code: 3621

Environment

Release : 15.9.1

Component : CA PPM TIME SLICING

Cause

This is due to DE59946

Resolution

This issue is fixed in 15.9.1 patch 1 and 15.9.2.

To temporarily disable the new SQL Curve feature until you are able to upgrade to a version where this issue is fixed, see: Enable or disable the SQL Curve feature Toggle

Additional Information

For another symptom you may see due to this defect, see Per Period Metrics TSV Actuals and some ETCs missing