Can you check if this is the cause?
XOG fails when migrating Custom Objects from one environment into another environment
https://support.ca.com/us/knowledge-base-articles.tec1459218.html
Document ID: TEC1459218
Last Modified Date: 10/02/2015
Problem:
When migrating custom object instances from one environment to another, XML Open Gateway (XOG) updates some parts of the Sql query and adds single quotes which caused XOG to fail.
Steps to Reproduce:
- Create a custom object
- Create a lookup type custom attribute on above object
- Add the above custom attribute into create and edit views
- Create an instance for above custom object
- Give the custom attribute value as "test'test", add a single quote in the string
- XOG out the custom object instance
- XOG in same custom object instance without any change in the XOG file
Expected Result: Custom attribute value should be "test'test"
Actual Result: Custom attribute value is "test''test", getting extra single quote for the attribute
Environment:
Applies to all supported PAS environments for the specified releases.
Cause:
Caused by CLRT-78427
Resolution:
Resolved in CA PPM 14.2 Generic Patch #5
Resolved in CA PPM 14.3
NJ