time slice failure: odf-pmd.project.reset-TSV-status-c

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

A custom slice causes the time slicing job to fail.
After we create a Time Varying attribute and new time slice for the same, the Time Slicing job starts failing and bg-ca.log contains following error:

ERROR 2022-11-25 17:19:39,680 [Dispatch 11a Time Slicing : bg@host (tenant=clarity)] niku.blobcrack (clarity:admin:12095048__C6D777AE-589B-45F9-AC6C-417EBB6639B0:Time Slicing) Exception during blobcrack process

com.niku.union.persistence.PersistenceException: An error occurred getting statement set: odf-pmd.project.reset-TSV-status-c_1test.map from resolver

at com.niku.union.persistence.PersistenceCache._getStatementSet(PersistenceCache.java:400)

at com.niku.union.persistence.PersistenceCache.getStatementSet(PersistenceCache.java:322)

at com.niku.union.persistence.PersistenceController.<init>(PersistenceController.java:372)

at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:336)

at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:214)

at com.niku.blobcrack.BlobCrackDB.doReset(BlobCrackDB.java:537)

at com.niku.blobcrack.BlobCrackDB.resetRequest(BlobCrackDB.java:502)

at com.niku.blobcrack.BlobCrackDB.resetRequests(BlobCrackDB.java:641)

at com.niku.blobcrack.BlobCrackDB.prepareSliceStatus(BlobCrackDB.java:1461)

at com.niku.blobcrack.BlobCrackDB.sliceCurves(BlobCrackDB.java:1150)

at com.niku.blobcrack.BlobCrackDB.createSlices(BlobCrackDB.java:686)

at com.niku.blobcrack.xql2.handlers.BlobCracker.processNewRequests(BlobCracker.java:158)

at com.niku.blobcrack.xql2.handlers.BlobCracker.postProcess(BlobCracker.java:44)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1423)

at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)

at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)

at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1389)

at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)

at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)

at com.niku.njs.xbl.XBLService.process(XBLService.java:127)

at com.niku.njs.xbl.XBLService.process(XBLService.java:75)

at com.niku.njs.listeners.XBLJob.scheduledEventFired(XBLJob.java:44)

at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:749)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at java.base/java.lang.Thread.run(Thread.java:829)

Caused by: java.lang.NullPointerException

Cause

Inconsistencies between objects/attributes included in DWH and slices included in DWH.

Resolution

Checked for inconsistencies between objects/attributes included in DWH and slices included in DWH.

Found out that there was one custom object with a custom TSV attribute and two time-slices.

The object was not included for DWH, but had been on the past

Included the object for DWH

Ensure the following:

1. There are no leftover slices for attributes/objects, which have since been deleted,

2. There are no slices for attributes/objects, which were included in DWH at some point and then excluded.

As a rule of thumb, you can simply include all the object with time-sliced attributes into DWH