On the Clarity Timeslice page the 'Last Run' date is not getting update for certain slices when the Timeslice job runs and completes

Document ID : KB000030123
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

My 'DAILYRESOURCETIMECURVE' slice 'Last Run' date is not getting update when the Timeslice job runs and completes,

the slice_status which are set to 1 in the PrTimeentry table are not getting processed.

 

I have been getting these error messages flooding my log files; 

 

ERROR message: niku.blobcrack (none:none:none) Exception during blobcrack process

com.niku.union.persistence.PersistenceException:

SQL error code: 1

Error message: ORA-00001: unique constraint

(CLARITY.PRJ_BLB_SLICES_M_ALC_U1) violated

 

Solution:

There are some preceding error messages in the log file which gives an indication the source of the issue;

 

ERROR message: niku.blobcrack (none:none:none) Exception during blobcrack process

com.niku.union.persistence.PersistenceException:

SQL error code: 1426

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01426: numeric

overflow

Executed:

UPDATE PRTEAM

SET prAllocSum = ?

WHERE prID = ?

 

Using input:

{value=Infinity, parameters=[int:objectID:5024142:, double:value:Infinity:],

objectID=5024142}

 

 

The input value is set to infinity.

This is an indication that you have a bad allocation segment with a value of <infinity>% in the Team => Staff properties page.

 

Check this for the resource and the project to which the resource is allocated to and correct this.

 

For example on the Project team page, click on the Properties Icon to open the Staff Member Properties page then delete the bad

segment with 1/1/2014 to 1/2/2014 <infinity symbol>%

and add new segment for 1/1/2014 to 1/2/2014 at 0%

 

 

Finally run the Timeslice job again so that all slices pending processing are sliced.