OBS Read using XOG fails when OBS is used for Access Rights and if there is an Investment Extension Custom Object

Article Id: 140596
Status: Published
Updated On: 13-10-2020 23:33
Products:
Clarity PPM SaaS , Clarity PPM SaaS , Clarity PPM SaaS
Issue/Introduction:

1. Login to Clarity PPM as an Admin User.
2. Navigate to Administration -> Organization and Access -> OBS.
3. Create a New OBS and associate it with any Object. Ex :- Resource Object.
4. Navigate to Administration -> Organization and Access -> OBS, Check the newly created OBS and Click "Use for Access Rights".
5. Navigate to Administration -> Studio -> Objects.
6. Create a New Object and Set "Object Extension" as "Investment Extension".
7. On a CLient machine open XOG client. Edit the OBS_READ.xml file and enter the name of the newly created OBS. Below is an Example.
 <?xml version="1.0" encoding="UTF-8"?>
 <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
   <Header version="7.5.1" action="read" objectType="obs" externalSource="NIKU"/>
   <Query>
      <Filter name="name" criteria="EQUALS">Resource Pool</Filter>
      </Query>
    </NikuDataBus>

8. Run this using XOG client.


Expected Results: OBS structure and associations are exported.

Actual Results: OBS Read fails with the below error.

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_obs.xsd">
 <Header action="write" externalSource="NIKU" objectType="obs" version="15.6.1.265"/>
 <obsTypes/>
 <XOGOutput>
  <Object type="obsTypes"/>
  <Status state="SUCCESS"/>
  <Statistics insertedRecords="0" failureRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
  <Records>
   <Record>
    <KeyInformation>
     <column name="obsType">resourcePool</column>
    </KeyInformation>
    <ErrorInformation>
     <Severity>FATAL</Severity>
     <Description>XOG-2620: OBS export failed Invalid expression customObjectinstanceRights: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "O"."CODE": invalid identifier
     </Description>
     <Exception>
      <![CDATA[SQL Exception with error code : 904]]>
     </Exception>
    </ErrorInformation>
   </Record>
  </Records>
 </XOGOutput>
</NikuDataBus>

Cause:

Primary cause of this issue is the presence of Investment Extension based Custom Objects. It's being tracked as Defect DE51954 

Environment:

Release : 15.5.1, 15.6, 15.6.1, 15.7

Component : CA PPM SAAS USERS, GROUPS, OBS ADMINISTRATION

Resolution:

This is now fixed in Clarity PPM 15.8