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

Powered by Wolken Software