System Error is Thrown when attempting to Update the Team

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Users are unable to update team member properties when partitions are being used and an active process exists referencing a project aggregate attribute. 

 

STEPS TO REPRODUCE:

1. Create a Partition Model (ex: Partition Model A), with at least one Partition under it (ex: PPM PartitionA)

2. Add the user to the PPM PartitionA

3. Go to Administration > Objects > Project, and associate the Partition Model A with the Project object, Save and Return

4. Create a new custom subobject of the Project object, Custom Sub ( ID: custom_sub), check the boxes for 'Event Enabled' and 'Copy Enabled'

5. In the custom object created in Step4, create a Number attribute:

   Attribute Name: Actual Cost 

   Attribute ID: actual_cost 

   Partition: PPM PartitionA or System

6. Back on the Project object, create a new Aggregated attribute: 

Name: Total Expense 

ID: total_ex 

Partition: PPM PartitionA or System 

Expression: AGG_Sum(custom_sub.actual_cost)

7. Create a Process 

Name: Test Process 

Objects: Project (in either the System or PPM PartitionA) 

Start Options > Auto- Start 

Start Event: Update 

Start Condition: (project.total_ex != project.total_ex__oldValue) 

Start step directly to Finish (no need to add any actions)

8. Validate and Activate the process

9. Create a new project (or open an existing one)

10. Go to the project team, and add a resource

11. Attempt to make any update to the team member

12. Click on Save 

 

Expected Result: The change on the Team to be saved. 

Actual Result: The change on teh Team is not saved, and a System Error is thrown. The app-ca log shows an error message similar to the following:

 

ERROR 2016-12-12 18:17:33,567 [http-nio-80-exec-702] niku.xql2 (clarity:admin:5663040__177FB831-4EE1-4BD6-AABB-F74826F33ECE:npt.gridUpdate) Database Error thrown 

com.niku.union.odf.exception.ODFException: com.niku.union.omp.persistence.jdbc.exception.NestedSQLException: 

--- The error occurred while applying a parameter map. 

--- Check the omp.dynamic.select-object.map::project:NIKU.ALL:0:stage_code, total_ex-DynamicParameterMap. 

--- Check the statement (query failed). 

--- Cause: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "S0"."ID": invalid identifier 

 

Environment

CA PPM 14.3, 14.4, 15.1

Cause

Caused by CLRT-81636/DE31267

Resolution

The issue is currently under review as CLRT-81636 and DE31267.