Modern UX API-1019 error while adding task in 15.8.1

Products

• Clarity PPM On Premise

Issue/Introduction

We are getting below error while adding task in modern UX in 15.8.1

API-1019: could not process the request due to internal error

Error in app-ca.log

ERROR 2020-08-19 09:12:02,955 [http-nio-80-exec-4] ppm.rest (clarity:USER52:SESSION_NUMBER:PPM_REST_API) Exception processing request for resource [timeEntries], query string [/timesheets/19846002/timeEntries]
java.lang.NullPointerException

We have checked and this error is not related with wbs sequence issue.

User is able to add the task in classic.

Environment

Release : 15.8.1

Component : PPM INVESTMENTS, PROJECTS, RESOURCES & NPIO MANAGEMENT

Resolution

Issue was caused by duplicate entries in the PRCALENDAR table, to resolve it we had to delete duplicates from PRCALENDAR table retaining MAX PRID record.

Cause of the duplicate entries is not clear. The following query can be used for checking and deleting possible duplicate entries for the affected resource (prid) in PRCALENDAR table:

select PRRESOURCEID from prcalendar group by PRRESOURCEID having
count(PRRESOURCEID) > 1