search cancel

Time slicing job is failing after upgrade (Oracle Only)

book

Article ID: 257075

calendar_today

Updated On:

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 : [email protected] (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 : [email protected] (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

Resolution

This is DE67660, fixed in 16.1.1

Fix is the same root cause as also for the issue  Time Slicing Rollover is slower on 16.0.2, 16.0.3, 16.1.0 (Oracle)