Unable to add a team member to a project if the resource id contains an apostrophe via XOG

Document ID : KB000008435
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

STEPS TO REPRODUCE: 
1. Go to Home > Resource Management > Resources 
2. Create a new resource called James. Ensure the resource id contains an apostrophe: J_O'Hara
3. Create a project called James Project and add the resource created as a team member 
4. XOG the project out by using the prj_projects_read.xml file 
5. Delete the team member from the project 
6. XOG the output file to add James as a team member

Expected result: Team member is added 
Actual result: The XOG write throws an error and the team member is not added 

Environment:
CA PPM 14.X and 15.X
Cause:

This is caused by DE36633 and is currently being analysed by Engineering

Resolution:

Remove apostrophes from resource ids. 
But, if the resource is financially enabled, you can not modify the resource id.

Additional Information:

You might get a similar error on the output file:

 

<ErrorInformation>

<Severity>FATAL</Severity>

<Description>Project Object update failed</Description>

<Exception><![CDATA[

java.lang.Exception: 101 : java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'o'.

at com.niku.schedulers.api.XOGProjectAPI.returnErrorMessage(XOGProjectAPI.java:472)