AnsweredAssumed Answered

Obtaining NSQL Query Output via XOG

Question asked by FHN on Apr 8, 2011
Latest reply on Apr 8, 2014 by Dave
I’m trying to devise how to XOG out the results of a custom NSQL query from Clarity. I started with a simple SQL query:

SELECT DEPARTCODE AS DEPARTMENT, LOCATIONID AS LOCATION
FROM CLARADM.LOCATIONDEPT

Then turned that into NSQL easily enough:

SELECT @SELECT:DIM:USER_DEF:IMPLIED:CC:DEPARTCODE:DEPARTMENT@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:CC:LOCATIONID:LOCATION@
FROM LOCATIONDEPT
WHERE @FILTER@

Now, I wish to be able to extract the results of this NSQL query through Clarity’s XOG capability. Browsing through the various posts on the Clarity XOG/GEL/WSDL message board, I came up with the following XOG input file:

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd">
<Header version="12.0.5.5350" object="query" action="read" externalSource="NIKU"/>
<Query xmlns:quer="http://www.niku.com/xog/Query">
<quer:Code>locationdept</quer:Code>
</Query>
</NikuDataBus>

When I run this using Clarity’s XOG client for Windows (which I use regularly to XOG various objects from our DEV copy of Clarity over to our Production copy), I get the following error output:

<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Status state="FAILURE"/>
<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
<ErrorInformation>
<Severity>FATAL</Severity>
<Description>Exception while processing client request</Description>
<Exception type="com.niku.xog.XOGException"><![CDATA[com.niku.xog.XOGException: Missing action and/or objectType in NikuDataBus request

Can anyone help me correct what I’m doing wrong here?

Thanks in advance for any assistance.

Outcomes