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

book

Article ID: 18428

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application 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: