System throws the below error while trying to remove the resource from the Team. The resource has no actuals or requisitions.
ERRORPRJ-07580: One or more staff members cannot be removed. This may be due to security, committed actuals or booked requisition.
From the app-ca logs
ERROR 2020-07-21 11:15:13,455 [http-nio-14001-exec-9] xql2.rule (clarity:[email protected]:110346493__D0F32DB3-7589-42D9-B079-D769103C9AA5:projmgr.teamDeleteAndClose) Exception occurred while purging slice: [objectId:6549756], [sliceRequestId:5022017], [tableName:ODF_SL_5226060] com.niku.union.persistence.PersistenceException: SQL error code: 942 Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist Executed: DELETE FROM ODF_SL_5226060 WHERE PRJ_OBJECT_ID = ? AND SLICE_REQUEST_ID = ? Derived from statement: <?xml version="1.0" encoding="UTF-8"?> <statement id="blobcrack.purgeSlice_stmt" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd"> <sql dbVendor="all"> <text> DELETE FROM @[email protected] WHERE PRJ_OBJECT_ID = ? AND SLICE_REQUEST_ID = ?
Team had a Time Varying attribute which was not present in the slice tables.
Release : 15.7.1
Component : CA PPM SAAS APPLICATION
The time varying attribute had to be deleted and recreated.