Time Slicing Job Fails with ORA-01426 Error
Article ID: 124015
Updated On:
Products
Clarity PPM SaaS
Clarity PPM On Premise
Issue/Introduction
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.
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.
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.
Feedback
Yes
No
Powered by
