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

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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 

Environment

Release: ESPCLA99000-13.3-Clarity-Extended Support Plus
Component: