Per Period Metrics TSV Actuals and some ETCs missing

book

Article ID: 209532

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Data is blank on the Staff Per Period Metrics TSV for some ETCs and also actuals, but totals display. 

Error seen in the bg-ca.logs:

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 
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated. 

Cause

This issue is caused by: DE59946 and related to the new SQLCurve functionality introduced in 15.9.1

Environment

Release : 15.9.1

Component : CA PPM PROJECT MANAGEMENT

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 an additional symptom you may see due to this issue, see: Time slicing job fails with Arithmetic overflow error post upgrade