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

Document ID : KB000107942
Last Modified Date : 18/04/2019
Show Technical Document Details
When running the agile central sync job in CA PPM, it fails with an error creating a milestone.
CA PPM - Integrated with CA Agile Central
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.
This is a known defect - DE42649, fixed in 15.5.1

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.