CA PPM: Time Slicing job fails due to duplicate records being inserted

Document ID : KB000023178
Last Modified Date : 01/06/2018
Show Technical Document Details
Issue:
There is a repeated error in the BG-CA.LOG:


MSSQL ERROR:

    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'dbo.PRJ_BLB_SLICES' with unique index 'PRJ_BLB_SLICES_U2'.
    SQL error code: 3621
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
    ....
    Using input:
    {sliceDate=2015-02-01T00:00:00, sliceID=11438446, role_id=5005473, startDate=2015-02-01T00:00:00, objectID=5003935, resource_id=5005473, unit=0, finishDate=2015-03-01T00:00:00, requestID=6, slice=159.6, investment_id=5006074}

ORACLE ERROR:

    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_U2) violated
    ....
    Using input:
    {sliceDate=2015-02-01T00:00:00, sliceID=11438446, role_id=5005473, startDate=2015-02-01T00:00:00, objectID=5003935, resource_id=5005473, unit=0, finishDate=2015-03-01T00:00:00, requestID=6, slice=159.6, investment_id=5006074}

 
Cause:
The constraint error occurs because the Time Slicing job is try ng to add a record that is already there.
 
Resolution:
Stabilize the job scheduler:
a. Set all jobs that are WAITING to PAUSED;
b. Set all jobs that are SCHEDULED to PAUSED;
c. Set all jobs that are in PROCESSING to CANCELLED
d. Make note of the scheduled jobs and scheduled times as they will need to be re-entered later.
e. Delete all CANCELLED job instances
f. Restart all BG services.
g. Run an immediate instance of the Time Slicing job to check if the same error occurs.

If the same error occurs, please contact CA Technologies Support for a resolution.

The BG logs will be reviewed to obtain the data table and corresponding records necessary to construct a SQL delete statement to resolve the issue.