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
XML code 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>
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>
The XOG output file might also include the following FATAL error:
XOG: Insufficient rights to perform XOG read of custom object instance
CDATA[XOG: The instances of custom extended objects are not enabled for XOG]
Release : 15.7.1, 15.8, 16.0.1
Component : CA PPM XML OPEN GATEWAY (XOG)
See Using Clarity REST APIs
The custom investment API can be found in URL <hostname>/niku/rest/describe/index.html#/Other32Resources