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

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

Symptoms:

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

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

Steps to Reproduce:

1. Create custom (child) sub object: 
   id=nt_sub1
   Master Object = Investment 
2. Create custom (grandchild) sub object:
   id=nt_sub2
   Master Object =nt_sub1
3. Open a Project and create an instance of sub object nt_sub1:
   id=ntsub1
   name=ntsub1
4. Open instance ntsub1 Create an instance of sub object nt_sub2:
   id=ntsub2
   name=ntsub2
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.

Cause:

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.  

Resolution: 

Resolved in CA PPM 14.3 Generic Patch #5   

Additional Information: 

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