Time Slicing Sync error “SQL error code: 17059” – “Fail to convert to internal representation”

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Persistent Time Slicing Sync error in the logs: SQL error code: 17059  Fail to convert to internal representation: 4.721226602815708E180 on inv_investments odf_nk and odf_fte fields

 

STEPS TO REPRODUCE:

1. Run Time Slicing Sync job on a server with a large project starting in 2007

Expected Results: The Time Slicing Sync to complete

Actual Results: The Time Slicing Sync job throws errors:

ERROR 2025-03-24 03:51:21,923 [pool-310-thread-1] blobcrack.SqlCurveCrack (clarity:none:none:none) () Exception on persist and commit
com.niku.union.persistence.PersistenceException: 
SQL error code: 17059
Error message: Fail to convert to internal representation: 4.721226602815708E180
Executed:
 UPDATE inv_investments
          SET odf_nk_labor_etc_curve = ?, odf_fte_labor_etc_curve = ?, odf_nk_labor_act_curve = ?, odf_fte_labor_act_curve = ?, odf_nk_labor_eac_curve = ?, odf_fte_labor_eac_curve = ?, odf_nk_labor_alloc_curve = ?, odf_fte_labor_alloc_curve = ?, odf_nk_labor_hard_alloc_curve = ?, odf_fte_labor_hard_alloc_curve = ?
          WHERE id = ? 

Environment

Clarity 16.2.3, 16.3.0, 16.3.1

Cause

DE168495

Resolution

Fixed in Clarity 16.3.2