Clarity PPM1

Expand all | Collapse all

Creating TimePeriod gives an error via XOG API

Jump to Best Answer
  • 1.  Creating TimePeriod gives an error via XOG API

    Posted 06-24-2019 01:19 AM
    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 06-24-2019 02:04 AM
    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 06-24-2019 04:19 AM
    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


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

    Posted 09-02-2019 05:05 AM
    Hi,
    I set up the oracle parameter as per your suggestion:

    Still the same error while posting via XOG API.



  • 5.  RE: Creating TimePeriod gives an error via XOG API
    Best Answer

    Posted 09-13-2019 08:37 AM
    Edited by Navdeep Joshi 26 days ago
    As asked by Suman as well, "What error you see in app ca log?"