Negative Number Is Generated by Sequence in the PRTIMEENTRY Table for 'PRID' Column

Article Id: 141898
Status: Published
Updated On: 17-12-2019 10:17
Products:
Clarity PPM On Premise , Clarity PPM SaaS
Issue/Introduction:

The PRID column of table PRTIMEENTY has negative value due to sequence overflow. As a result, the time entry module in Clarity PPM New UX breaks.

Steps to Reproduce

  1. Use a dataset with several timesheets.
  2. Open the PRTIMEENTRY table and note the value of PRID.
  3. Open any of the timesheets with negative PRID in Clarity PPM New User Experience.

Expected Result: The value of PRID column in PRTIMEENTRY table must be positive. 

Actual Result: The value of PRID column in PRTIMEENTRY table is negative. For example, -35044054.

Cause:

This has been reported to Engineering as DE49036.

Environment:

This issue has been reported in Clarity PPM 15.3.

Resolution:

This issue has been reviewed and fixed by Engineering. The fix is available in Clarity PPM 15.6.1.3, 15.7.1.1 and higher releases.

The fix does not correct existing data, but will prevent negative IDs from being generated.

Workaround: Classic UX Timesheets can use the old IDs.