View Only
  • 1.  XOG SOAP Error Writing Timesheet Entry

    Posted May 08, 2017 11:34 AM



    I am trying to write a timesheet entry using the Object API, following the instructions in the CA PPM integration guide.  Here is the SOAP information:



    Action: WriteTimeperiod


     <soapenv:Envelope xmlns:soapenv="" xmlns:obj="">
    <NikuDataBus xmlns:xsi="" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">
    <Header version="6.0.11" externalSource="NIKU"/>
    <TimePeriod finish="2017-05-12T00:00:00" start="2017-05-05T00:00:00">
    <TimeSheet ID="-1" resourceID="kbleiche" action="add" version="1" status="0">
    <TimeSheetEntry projectID="PR-003028" internalTaskID="5004007">
    <Actual actualDate="2017-05-08" amount="12"/>
    <NoteData noteText="test CA PPM log" createdBy="kbleiche" createdTime="2017-05-08T02:58:00" category="NoteCat"/>


    This specific example involves creating a new timesheet for the given resourceID and time period, but I also have to handle situations where I am adding/editing an existing timesheet too.  The error I get is:


    Problem In Imported Data: Import cancelled.

    com.niku.xql2.InvalidXQLObjectException: Unable to update record
    at com.niku.xql2.jdbc.JDBCRecord.update(
    at com.niku.xql2.handlers.UpdateHandler.postProcess(
    at com.niku.xql2.XQLVisitor.postProcess(
    at com.niku.union.xml.dom.DOMWalker.postProcess(
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(
    at com.niku.union.xml.dom.DOMWalker.traverse(
    at com.niku.xql2.handlers.LoopHandler.processObject(
    at com.niku.xql2.handlers.LoopHandler.processSet(
    at com.niku.xql2.handlers.LoopHandler.preProcess(
    at com.niku.xql2.XQLVisitor.preProcess(



    What is the resolution to this error message?

  • 2.  Re: XOG SOAP Error Writing Timesheet Entry

    Posted May 08, 2017 12:02 PM

    Is the <Header> line missing the object action?


    i.e. should it look like this;

    <Header version="6.0.11" action="write" objectType="timeperiod" externalSource="NIKU"/>

  • 3.  Re: XOG SOAP Error Writing Timesheet Entry

    Posted May 08, 2017 12:21 PM

    Hi David,


    I tried with that header and got the same error.  When I use SOAP on the Object API, I wrap the XOG request in a SOAP envelope that includes the <obj:WriteTimeperiod> tag, which means I don't necessarily have to specify the action or objectType in the Header.


    On a side note, how do you insert a code block in a post?  That would make the request payload a lot easier to read.