Time Slicing job is failing few times per day the error - ORA-00001: unique constraint (NIKU.ODF_SSL_5000000_U1) violated, full error message from bg-ca.log:
ERROR 2021-05-18 07:07:43,848 [Dispatch Time Slicing : <server> (tenant=clarity)] niku.blobcrack (EBB60D0F-FAF6-4451-9751-A20E9941DD5D:Time Slicing) Error while inserting slices.
SQL error code: 1
Error message: ORA-00001: unique constraint (NIKU.ODF_SSL_5000000_U1) violated
INSERT INTO ODF_SSL_5000000
( SLICE_REQUEST_ID, PRJ_OBJECT_ID, START_DATE, FINISH_DATE, SLICE, CREATED_DATE
VALUES (?, ?, ?, ?, ?, ? )
Note the time slice request table ODF_SSL_5000000 may vary.
Release : Any
Component : CA PPM TIME SLICING
This can be caused by a bad data in one of the time slice records. At this time we do not have information on how the corruption happens.
select * from ODF_SSL_5000000
Note that the impact of this issue will be low, as the Timeslicing job will process correctly all the other records but the corrupted one