CA PPM: Error when trying to run query from XOG

Document ID : KB000029843
Last Modified Date : 10/08/2018
Show Technical Document Details
Introduction:

Steps to Reproduce:

1. Create a simple NSQL query in Clarity:
name=my_resources
id=my_resources

NSQL:

SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:R.FULL_NAME:RSRC@,
         @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:MR.FULL_NAME:MANAGER@
FROM SRM_RESOURCES R,
         SRM_RESOURCES MR,
         CMN_SEC_USERS U
WHERE U.ID = R.USER_ID
AND R.MANAGER_ID = MR.USER_ID
AND @FILTER@
GROUP BY R.FULL_NAME,
         MR.FULL_NAME
HAVING @HAVING_FILTER@


2. Input xml file - "resources.xml":

<Query xmlns="http://www.niku.com/xog/Query">
    <Code>my_resources</Code>
</Query>


3. properties file:

# server host name you want to test against
servername=***.***.***.***
portnumber=yyyy

#set to true if running against a SSL enabled server
sslenabled=false

username=AAAAAA
password=BBBBBB

input=../xml/resources.xml
output=outputresources.xml

4. from command line execute the xog:
xog -propertyfile test.properties



EXPECTED RESULT:
XOG executes the query

ACTUAL RESULT:
XOG fail with error


C:\XOG133\bin>xog -propertyfile test.properties
-----------------------------------------------------------
Clarity XML Open Gateway ( version: 13.3.0.270 )
-----------------------------------------------------------
Login Succeeded
Request Document: resources.xml
Writing output to outputresources.xml
Failed to retrieve response document
java.lang.NumberFormatException: For input string: ""
        at java.lang.NumberFormatException.forInputString(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at com.niku.xog.client.XOGClient.mergeResponseToStream(XOGClient.java:824)
        at com.niku.xog.client.XOGClient.processRequestAsStream(XOGClient.java:896)
        at com.niku.xog.client.XOGClient.processRequest(XOGClient.java:585)
        at com.niku.xog.client.XOGClient.processRequests(XOGClient.java:1444)
        at com.niku.xog.client.XOGClient.invokeCommand(XOGClient.java:1237)
        at com.niku.xog.client.XOGClient.main(XOGClient.java:142)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at com.werken.forehead.Forehead.run(Forehead.java:551)
        at com.werken.forehead.Forehead.main(Forehead.java:581)
Logout Succeeded
C:\XOG133\bin>


Workaround :  

Other SOAP clients are unaffected by this as it is a client-side issue with XOG.  You may be able to use an alternative tool until this is fixed like SoapUI or similar.


Status / Resolution:

This has been documented as CLRT-77088 and it is targeted for resolution in future release.

Instructions:
Please Update This Required Field