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)
Release : All Supported Releases
Component : CA PPM SAAS PROJECT MANAGEMENT
Effective Allocation Start and Finish out of sequence
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