Issue Xogging Custom Investment Instance

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

I get the following error when trying to XOG out an instance of a custom investment:

SQL Exception with error code : 936 message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00936: missing expression

 

Here is the XML code I used to XOG out the instance:

<?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="8.0" action="read" objectType="customObjectInstance" externalSource="NIKU"/>

  <CustomObjectInstanceQuery>

    <Filter name="objectCode" criteria="EQUALS">goc_init</Filter>

    <Filter name="instanceCode" criteria="OR">INIT-000001</Filter>

  </CustomObjectInstanceQuery>

</NikuDataBus>

 

Here are the details of my custom investment:

Another error you may see when trying to XOG includes the following:

<Severity>FATAL</Severity>

<Description>Custom Object Instance Export Failed</Description>

-<Exception>

-<![CDATA[
com.niku.union.persistence.PersistenceApplicationException

In 16.0.1 XOG will run without error but it will not return instance info, so you may see something like below:

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">
 <Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="16.0.1.838"/>
 <customObjectInstances objectCode="ks_cust_inv">
  <instance objectCode="ks_cust_inv">
   <CustomInformation>
    <ColumnValue name="odf_object_code">ks_cust_inv</ColumnValue>
    <ColumnValue name="odf_period_end"/>
    <ColumnValue name="odf_period_start"/>
    <ColumnValue name="obj_work_status">REQUESTED</ColumnValue>
    <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
   </CustomInformation>
   <OBSAssocs complete="false"/>
   <Security>
    <UserSecurity rightCode="odf_cst_ks_cust_inv_edit" userName="admin"/>
   </Security>
  </instance>
 </customObjectInstances>
</NikuDataBus>

Environment

Release : 15.7.1, 15.8, 16.0.1

Component : CA PPM XML OPEN GATEWAY (XOG)

Resolution

• Current design does not allow to XOG out or in custom investment instances, you'll have to use the REST API.
• Note: You will still see XOG Access right, the thought behind was to leave it untouched because we still wanted to allow for configuration of the custom investment object to be able to XOG in and out and it was risky to split them apart so that is why it is still there.

Additional Information

See Using Clarity REST APIs

The custom investment API can be found in URL <hostname>/niku/rest/describe/index.html#/Other32Resources