Time slicing job is failing after upgrade with underflow error

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Time slicing job is failing after Clarity upgrade - on Oracle: 

ERROR 2022-11-25 16:52:34,583 [Dispatch Time Slicing with logs R1 25 Nov 2022 : bg@XXXXX (tenant=clarity)] niku.blobcrack (clarity::566295842__F8D7628B-0440-401A-9E14-75668241C087:Time Slicing ) Error while inserting slices.
java.lang.IllegalArgumentException: Underflow
 at oracle.jdbc.driver.OraclePreparedStatement.setDoubleInternal(OraclePreparedStatement.java:4809)
 at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:7918)
 at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7619)
 at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8374)
 at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8349)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:221)
 at com.niku.union.persistence.PersistenceController.bindObjectParam(PersistenceController.java:1724)
 at com.niku.union.persistence.PersistenceController.bindValue(PersistenceController.java:1684)
 at com.niku.union.persistence.PersistenceController.processParameter(PersistenceController.java:1815)
 at com.niku.union.persistence.PersistenceController.buildParams(PersistenceController.java:3496)
 at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:3261)
 at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:928)
 at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:826)
 at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:628)

ERROR 2022-11-25 16:52:34,588 [Dispatch Time Slicing with logs R1 25 Nov 2022 : bg@XXXXX (tenant=clarity)] niku.blobcrack (clarity:43728203:566295842__F8D7628B-0440-401A-9E14-75668241C087:Time Slicing) Error processing slices 
java.lang.IllegalArgumentException: Underflow
 at oracle.jdbc.driver.OraclePreparedStatement.setDoubleInternal(OraclePreparedStatement.java:4809)
 at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:7918)
 at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:7619)
 at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8374)
 at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8349)
 at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:221)
 at com.niku.union.persistence.PersistenceController.bindObjectParam(PersistenceController.java:1724)
 at com.niku.union.persistence.PersistenceController.bindValue(PersistenceController.java:1684)
 at com.niku.union.persistence.PersistenceController.processParameter(PersistenceController.java:1815)
 at com.niku.union.persistence.PersistenceController.buildParams(PersistenceController.java:3496)

Environment

Release : 16.0.2, 16.0.3, 16.1.0

Environment: Oracle Only

Cause

Due to switch to native drivers and underflow occurs because some curves contain a very small value: -1.109995897665602E-302

Resolution

• Enable com.niku.blobcrack.slicer to identify which data is causing it to fail and this logger is available from16.0.3 patch 3 and 16.1.1 onwards only 
• DE67660 fixed in 16.1.1 and backported to 16.0.3 patch 3 
• Additionally it also fixes another defect pertaining to roll over Time Slicing Rollover is slower on 16.0.2, 16.0.3, 16.1.0 (Oracle)