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>
Primary cause of this issue is the presence of Investment Extension based Custom Objects. It's being tracked as Defect DE51954
Release : 15.5.1, 15.6, 15.6.1, 15.7
Component : CA PPM SAAS USERS, GROUPS, OBS ADMINISTRATION
This is now fixed in Clarity PPM 15.8