Object instance XOG read for 3 layer objects involved with virtual attribute with Referenced Item Master Object


Article ID: 38920


Updated On:


Clarity PPM On Premise



Grandchild Object has a virtual attribute from the grandparent (master) object causing a XOG error :

<Description>Custom Object Instance Export Failed</Description>
<![CDATA[ java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Ambiguous column name 'code'. 

Steps to Reproduce:

1. Create custom (child) sub object: 
   Master Object = Investment 
2. Create custom (grandchild) sub object:
   Master Object =nt_sub1
3. Open a Project and create an instance of sub object nt_sub1:
4. Open instance ntsub1 Create an instance of sub object nt_sub2:
5. XOG out sub object instance id=ntsub2
   Actual Result= Expected Result: Able to XOG out the instance. Output xml is generated fine
6. Add a virtual attribute in sub object id=nt_sub2:
   Referenced Item =Master Object
   Referenced Item's Object Type =nt_sub1
   Referenced Attribute =ID
   Attribute Name=nt_sub1_id
   Attribute ID=nt_sub1_id
7. Try to XOG out the same instance

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

Actual Result: An error is generated in the XOG output file: column ambiguously defined.


Caused by CLRT-79497

This issue occurs when 2 levels of subobjects are created under a investment object and when the 2nd level subobject instance (grandchild instance) is xogged out.

The query has the an ambiguous column id (code) and hence the query execution fails.  


Resolved in CA PPM 14.3 Generic Patch #5   

Additional Information: 

Reference TEC1696455 : PPM 14.3 Generic Patch available to resolve reported issues


Release: ESPCLA99000-14.3-Clarity-Extended Support Plus