Issue while replacing role with resource in teams tab and deleting the resource from team

Article Id: 195507

Status: Published

Updated On: 20-07-2020 19:04

Products:

Clarity PPM SaaS

Issue/Introduction:

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 = ?

Cause:

Team had a Time Varying attribute which was not present in the slice tables.

Environment:

Release : 15.7.1

Component : CA PPM SAAS APPLICATION

Resolution:

The time varying attribute had to be deleted and recreated.