PRJ-10012  error when adding tasks
search cancel

PRJ-10012  error when adding tasks

book

Article ID: 143061

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

When using the 'Copy Tasks from Template' function, an error is being generated and no copying takes place.  The error is:

ALERT: Invalid or no object data found 
Error ERROR PRJ-10012: Attempt to add/update record failed.
System error. Contact system administrator.

ERROR 2022-02-17 12:15:18,349 [http-nio2-8080-exec-1710] xql2.rule (clarity: User:Session:projmgr.copyTaskWBS) Effective Allocation Start and Finish out of sequence. start=Tue Mar 08 08:00:00 CST 2022 finish=Sun Feb 13 17:00:00 CST 2022
ERROR 2022-02-17 12:15:18,349 [http-nio2-8080-exec-1710] niku.xql2 (clarity: User:Session:projmgr.copyTaskWBS) Invalid record for update.
ERROR 2022-02-17 12:15:18,349 [http-nio2-8080-exec-1710] niku.xql2 (clarity: User:Session:projmgr.copyTaskWBS) Exception CopyProjectTasks.beginCopy()
com.niku.union.utility.MessageKeyException: PRJ-10012: Attempt to add/update record failed.
 at com.niku.projmgr.api.CopyProjectTasks.addTeamMemberToProject(CopyProjectTasks.java:1602)
 at com.niku.projmgr.api.CopyProjectTasks.copyResources(CopyProjectTasks.java:1303)
 at com.niku.projmgr.api.CopyProjectTasks.doCopy(CopyProjectTasks.java:783)
 at com.niku.projmgr.api.CopyProjectTasks.beginCopy(CopyProjectTasks.java:693)
 at com.niku.projmgr.xql2.handlers.CopyTasksHandler.preProcess(CopyTasksHandler.java:49)
 at com.niku.xql2.handlers.BaseHandler.preProcess(BaseHandler.java:39)

Environment

Release : All Supported Releases

Component : CA PPM SAAS PROJECT MANAGEMENT

Cause

Effective Allocation Start and Finish out of sequence

Resolution

Review Team allocation Start and Finish dates with the following queries.

1) Shows all the allocations. If there is no start and finish on the team it is looking at slices. 

SELECT PRJ.UNIQUE_NAME "Project ID", PRJ.NAME "Project Name", SRM.UNIQUE_NAME "Resource ID",
SRM.FULL_NAME "Resource Name", ALLOC_START_DATE "Allocation Start Date", ALLOC_END_DATE "Allocation End Date",
SLICE "Allocated Hrs", RES_AVAIL "Available Hrs", CASE WHEN RES_AVAIL = 0 THEN (SLICE/RES_AVAIL) * 100 END "% Allocation"
FROM PRTEAM TEAM, SRM_PROJECTS PRJ, SRM_RESOURCES SRM,(SELECT PRJ_OBJECT_ID, MIN(SLICE_DATE) ALLOC_START_DATE,
MAX(SLICE_DATE) ALLOC_END_DATE, MAX(SLICE) SLICE FROM PRJ_BLB_SLICES_D_ALC GROUP BY PRJ_OBJECT_ID, SLICE HAVING SLICE = 0)  ALLOCATION,
  (SELECT PRJ_OBJECT_ID, MAX(SLICE) RES_AVAIL FROM PRJ_BLB_SLICES_D_AVL GROUP BY PRJ_OBJECT_ID) AVAIL
WHERE TEAM.PRPROJECTID = PRJ.ID AND TEAM.PRRESOURCEID = SRM.ID AND TEAM.PRID = ALLOCATION.PRJ_OBJECT_ID
AND SRM.ID = AVAIL.PRJ_OBJECT_ID
--AND SRM.UNIQUE_NAME = '1246713'
ORDER BY PRJ.ID, SRM.ID, ALLOC_END_DATE desc

Review the start and finish dates and update them accordingly.

2) This one is just for the team where the finish has an explicit date

SELECT t.PRAVAILSTART,
  t.PRAVAILFINISH,
  r.UNIQUE_NAME,
  r.FULL_NAME,
  i.CODE,
  i.NAME,
  t.PRAVAILSTART,
  t.PRAVAILFINISH
FROM prteam t
INNER JOIN INV_INVESTMENTS i
ON t.PRPROJECTID = i.ID
INNER JOIN SRM_RESOURCES r
ON t.PRRESOURCEID      = r.ID
WHERE t.PRAVAILFINISH IS NOT NULL
order by t.pravailfinish desc