Clarity

 View Only
  • 1.  Creating TimePeriod gives an error via XOG API

    Posted Jun 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

    Broadcom Employee
    Posted Jun 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 Jun 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 Sep 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 Sep 13, 2019 08:37 AM
    Edited by Christopher Hackett Sep 24, 2019 04:36 PM
    As asked by Suman as well, "What error you see in app ca log?"