Clarity PPM

Expand all | Collapse all

Creating TimePeriod gives an error via XOG API

  • 1.  Creating TimePeriod gives an error via XOG API

    Posted 24 days ago
    Request xml:

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd"><Header action="write" externalSource="NIKU" objectType="timeperiod" version="6.0.11"/>   <TimePeriods>   <TimePeriod start="2017-12-31T00:00:00" finish="2018-01-07T00:00:00" create="true" scale="weekly" openForTimeEntry="false" />    </TimePeriods> </NikuDataBus>


    Response xml:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header/>
    <soapenv:Body>
    <SessionID xmlns="http://www.niku.com/xog">5450586__8CEFC2EF-2E51-42F1-8B8C-EFE96FF8E9E4</SessionID>
    <WriteTimeperiodResponse xmlns="http://www.niku.com/xog/Object">
    <XOGOutput xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
    <Object type="timeperiod"/>
    <Status elapsedTime="0.094 seconds" state="FAILURE"/>
    <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
    <Records>
    <Record>
    <KeyInformation/>
    <ErrorInformation>
    <Severity>FATAL</Severity>
    <Description>Problem In Imported Data: Import cancelled.</Description>
    <Exception>SQL Exception with error code : 1861</Exception>
    </ErrorInformation>
    </Record>
    </Records>
    <DeprecationInformation />
    </XOGOutput>
    </WriteTimeperiodResponse>
    </soapenv:Body>
    </soapenv:Envelope>



    Any solution for this problem?


  • 2.  RE: Creating TimePeriod gives an error via XOG API

    Posted 24 days ago
    HI Joydeep

    What error you see in app ca log and did you cancel the xog.


    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 3.  RE: Creating TimePeriod gives an error via XOG API

    Posted 24 days ago
    Hello Joydeep

    I do not see any problem with your XOG XML request. Based on the ORA error 1861, can you confirm if you have set up the oracle parameters as per the Clarity documentation? Especially this parameter -> *.nls_date_format='YYYY-MM-DD HH24:MI:SS'

    Thanks & Regards
    Balaji Ragothaman