Synchronize Agile Central job fails when the Milestone Name is more than 32 characters

Document ID : KB000107942
Last Modified Date : 27/07/2018
Show Technical Document Details
Issue:
When running the agile central sync job in CA PPM, it fails with an error creating a milestone.
Environment:
CA PPM - Integrated with CA Agile Central
Cause:
The logs show the following error:

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "SCHEMA"."INT_AGL_MILESTONES"."MILESTONE_NAME" (actual: 35, maximum: 32)

Further in the logs we can see the input with the ID and name of the milestone:

{milestoneName=THIS_IS_A_VERY_LONG_MILESTONE_NAME_IN_CA_AGILE_CENTRAL, milestoneCode=MI12345, milestoneID=240628258060, id=240628258060}

This shows us that there is a milestone which the name is longer than 32 characters, causing the failure.
 
Resolution:
This is a known defect - DE42649, which will be fixed in an upcoming release.

Workaround: 
To workaround this issue, edit the milestone in the CA Agile Central side to change the name to be less than 32 characters.  Once this is done, re-run the sync job and it should no longer fail.