Time Slicing Job Fails with ORA-01426 Error

Document ID : KB000124015
Last Modified Date : 28/12/2018
Show Technical Document Details
Issue:
The time slicing job fails with an error similar to the following in the bg-ca logs: 

ERROR 2018-12-28 15:28:17,216 [Dispatch Time Slicing :(tenant=clarity)] niku.blobcrack (clarity:Time Slicing) Exception during blobcrack process 
com.niku.union.persistence.PersistenceException: 
SQL error code: 1426 
Error message: ORA-01426: numeric overflow 

Executed: 
UPDATE PRTEAM 
SET prAllocSum = ?, odf_pralloccurve = ? 
WHERE prID = ? ..... 

...value=Infinity, objectID=5037023}...

Where the objectID value is the internal id of a team record with an invalid allocation segment. This allocation segment will have a percentage of ∞% in the UI.

 
Resolution:
The invalid allocation segment will need to be updated on the team properties page to a valid percentage. 

This query can be used to find the details of the team record that needs updating: 

SELECT 
prteam.prid team_prid, 
inv_investments.id project_internal_id, 
inv_investments.code project_id, 
inv_investments.name project_name, 
srm_resources.last_name, 
srm_resources.first_name 
FROM 
prteam 
INNER JOIN srm_resources ON prteam.prresourceid = srm_resources.id 
INNER JOIN inv_investments ON prteam.prprojectid = inv_investments.id WHERE 
prteam.prid = xxxxxxx 

The xxxxxxx at the end of the query needs to be replaced with the objectID referenced in the error message.