Object instance XOG read in 13.3 when there are 3 layer objects involved

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

Description:

When reading an object instance via XML Open Gateway (XOG) for a configuration structured as described below, you get an error message.
Project Object = master
Object 1 = child of Project object
Object 2 = child of Object 1

Steps to Reproduce:

  1. In the UI create a custom object (Object 1) as a sub-object of project object
  2. In the UI create a custom object (Object 2) as a sub-object of Object 1
  3. Create project instance
  4. Create sub-object 'Object 1' instance
  5. Create sub-object 'Object 2' instance
  6. Read project or any of Object 1 or Object 2 instances using XOG

Expected Result: XOG Read action should generate valid XML output file.

Actual Result: An error is generated in the XOG output file [ java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00918: column ambiguously defined]

  

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

CLRT-74459
Resolved in Clarity 13.3 Generic Patch. Reference TEC605767
Resolved in CA PPM 14.1