XOG fails when migrating Custom Objects from one environment into another environment

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

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:

  1. Create a custom object
  2. Create a lookup type custom attribute on above object
  3. Add the above custom attribute into create and edit views
  4. Create an instance for above custom object
  5. Give the custom attribute value as "test'test", add a single quote in the string
  6. XOG out the custom object instance
  7. 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 

 

Additional Information:

Reference TEC1398937  : PPM 14.2 Generic Patch available to resolve reported issues

Reference CA PPM Resolved Defects Index for CA PPM 14.3