ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Time slicing job fails with Arithmetic overflow error post upgrade

book

Article ID: 212922

calendar_today

Updated On:

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

Cause

This is due to DE59946

Environment

Release : 15.9.1

Component : CA PPM TIME SLICING

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