Agile Central Integration Fails on 1 Project - Invalid Lookup Error

Document ID : KB000111167
Last Modified Date : 12/03/2019
Show Technical Document Details
Issue:
When a project has Agile Central integration activated, and an Agile Central user deletes the associated Initiative (i.e., it's moved to the A/C Recycle Bin), the integration fails when it hits that project, and subsequent projects in the queue are not processed by the integration. An error message is thrown.

Steps to reproduce the issue:
1) Set up the integration with Agile Central as Portfolio Item integration type and bi-directional 
2) Create a project in PPM and flag it to synchronize
3) Run the Synchronize Agile Central job
4) Back to AC delete the initiative created by the sync job
5) Run the Synchronize Agile Central job again. 
 
Expected ResultJob completes and the project corresponding to the initiative that was deleted remains in PPM without any update.
Actual Result:
Error message:
There was a problem updating CA PPM project:ACtoPPM_BI
400
validation.lookupValueInvalid
CMN-0009: Attribute 'Agile System' has invalid Lookup Value '{"displayValue":"AC-PPM-BI","_type":"lookup","id":"AC-PPM-BI"}'
There was a problem syncing CA PPM project:ACtoPPM_BI
Error updating Portfolio Item Id: 937fffe4-3837-4199-8701-9d9642838825 , Error Message:Cannot find object to read
Error Occurred java.lang.NumberFormatException: For input string: "validation.lookupValueInvalid"
There was a problem while syncing the project team for project:ACtoPPM_BI
Error updating Portfolio Item Id: 937fffe4-3837-4199-8701-9d9642838825 , Error Message:Cannot find object to read
ERROR 2018-09-19 08:22:07,275 [Dispatch Synchronize Agile Central (PR2016) : bg@bg-1-4hr2b (tenant=clarity)] ppm.agl (clarity:admin:5753809__1EED1E0E-3058-4AA7-9B17-7BF3F88F3701:Synchronize Agile Central
Resolution:
This is due to defect DE43214, fixed in Clarity version 15.5.1.