Issue Xogging Custom Investment Instance

book

Article ID: 142926

calendar_today

Updated On:

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

Environment

Release : 15.7.1, 15.8

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

Attachments