Clarity

Hello,

I need to XOG in a company, I xogged out one, then I tried to xog it in this file without any changes and it failed with following error:

java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string

So I found, that it's caused by attribute type:

<Company companyId="Test" externalId=" " name="Test" status="ACTIVE" type="VENDOR">

In Clarity the atribute is type Lookup - Number so I found the ID for value VENDOR which is 411 and changed the line above to:

<Company companyId="Test" externalId=" " name="Test" status="ACTIVE" type="411">

And tried to XOG it in, but again I get an error:

java.lang.Exception: Company Type 411  Lookup failed

I have never seen this error, please have you got any idea how to solve this?

Regards,

Martin

You shouldn't have to convert lookups between strings and numbers outside XML; the app should take care of that.

Looking at the stock "biz_companies_write.xml", the only example type it gives is type="Other" though.

--

I recollect getting that general "literal does not match format string" error in XOG with date/time values in the XML though.

(sorry, not much help, just guessing a bit)

Thank you for your reply Dave, but I tried to xog in the biz.companies_write.xml (without any changes) and it failed with:

java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string

also I tried to xog out one company and without any changes xog it in and I get the same error. Which is really wierd

Regards,

Martin

Check/change the date formats perhaps then?

The sample XML has dates in "YYYY-DD-MM" format - try "YYYY-MM-DD" or even "YYYY-MM-DDTHH:MI:SS" (with 0s for the time element).

or perhaps try changing the NLS settings for the user that you are using to call the XOG through.

(still GUESSing, but I totally agree that XOGing something out and XOGing it straight back in again should work )

Is the java exception present in the app-ca.log file?  If so, I would like to see it in full (including full stack trace and further details of the sql statement that are present), along with the exact version of Clarity (including patch level) being used as this influences the readability of the stack trace.  I can also find the XOG input/output files useful in conjunction, but if any of this data is information you would prefer not to post publicly, you may send it to me by email instead if you prefer.

I would agree with Dave that with Clarity, typically Oracle presents this error when there is an issue converting dates represented as XML strings into an internal 'date' field.  I think by changing the lookup, you may instead have caused Clarity to fail at an earlier stage in the processing so it simply didn't get as far as the literal format error, rather than it being related to or caused by the vendor field/attribute.

Please check also if your XOG user's locale in Clarity is set to English U.S. or not, and if it isn't there are a couple of cases where problems have occurred due to this and you might want to try changing it for a quick test.

Otherwise, that other detail and data about the error I ask for will really be needed in order to check.

Hello Nick,

thank you for your reply. The exact Clarity version is 13.2.0.472 06 14. I changed locale to English (United States) then xogged out my test company using following read file:

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
  <Header version="13.2" action="read" objectType="company" externalSource="NIKU"/>
  <Query>
   
        <Filter name="name" criteria="EQUALS">Test</Filter>
    <!--    <Filter name="companyStatus" criteria="EQUALS">InActive</Filter>
        <Filter name="companyType" criteria="EQUALS">Customer</Filter>
    -->
  </Query>
</NikuDataBus>

It xogged out me following write file:

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_company.xsd">
  <Header action="write" externalSource="NIKU" objectType="company" version="13.2.0.472"/>
  <Companies>
    <Company companyId="Test" externalId=" " name="Test" status="ACTIVE" type="VENDOR">
      <SupplementalInformation primaryContactEmail="dus.nokoc@acroni.si" primaryContactName="g. Duš Nokoč"/>
      <ContactInformation address1="Cesta 44" city="Jece" country="RS" postalCode="4270" type="main" workPhone="+385 34 425 910"/>
      <CustomInformation>
        <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>
        <ColumnValue name="c_com_part_rel">
          <Value>5001000</Value>
        </ColumnValue>
      </CustomInformation>
      <General addedBy="admin" addedDate="2015-03-27"/>
      <OBSAssocs complete="false"/>
    </Company>
  </Companies>
  <XOGOutput>
    <Object type="company"/>
    <Status state="SUCCESS"/>
    <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
    <Records/>
  </XOGOutput>
</NikuDataBus>

I changed nothing and tried to xog in with following result:

<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="company"/>
  <Status elapsedTime="1.373 seconds" state="FAILURE"/>
  <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
  <Records>
    <Record>
      <KeyInformation>
        <column name="companyid">Test</column>
        <column name="name">Test</column>
        <column name="externalSource">NIKU</column>
        <column name="externalId"/>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>Company Object Insert failed</Description>
        <Exception><![CDATA[
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format string


  at com.ca.clarity.jdbc.oraclebase.ddcg.b(Unknown Source)
  at com.ca.clarity.jdbc.oraclebase.ddcg.a(Unknown Source)
  at com.ca.clarity.jdbc.oraclebase.ddcf.b(Unknown Source)
  at com.ca.clarity.jdbc.oraclebase.ddcf.a(Unknown Source)
  at com.ca.clarity.jdbc.oracle.ddn.s(Unknown Source)
  at com.ca.clarity.jdbc.oraclebase.ddes.v(Unknown Source)
  at com.ca.clarity.jdbc.oraclebase.ddes.x(Unknown Source)
  at com.ca.clarity.jdbc.oraclebase.dddm.executeUpdate(Unknown Source)
  at sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:601)
  at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
  at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$bda41509.executeUpdate(<generated>)
  at com.niku.union.persistence.jdbc.SQLTracePreparedStatement.executeUpdate(SQLTracePreparedStatement.java:237)
  at com.niku.xql2.jdbc.JDBCDataSource.execute(JDBCDataSource.java:293)
  at com.niku.xql2.handlers.ExecuteHandler.postProcess(ExecuteHandler.java:90)
  at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1355)
  at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
  at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)
  at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
  at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)
  at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
  at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
  at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
  at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
  at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:161)
  at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:91)
  at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
  at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
  at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
  at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
  at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:161)
  at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:91)
  at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
  at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
  at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
  at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
  at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:161)
  at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:91)
  at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
  at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
  at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
  at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
  at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
  at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
  at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:248)
  at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:154)
  at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:197)
  at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)
  at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)
  at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:316)
  at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:105)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:56)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
  at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:70)
  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:722)
]]></Exception>
      </ErrorInformation>
    </Record>
  </Records>
</XOGOutput>

Here is what I found in app-trace.xml (there was nothing in app-ca.log):

<INFO date="2015-03-31 21:46:23,527" user="clarity:admin" session="7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610" action="XOG::company::write" thread="http-bio-8099-exec-1958" category="trace.server.user.admin">
  <xogRequest id="XOG::company::write" elapsed="717.000" elapsedAfterLastNode="140.000" start="9:46:22:810" finish="9:46:23:527" memoryDelta="3433k">
  <persistence id="security.getUserRolePerms_set" elapsed="78.000" elapsedSincePriorNode="234.000" elapsedAfterLastNode="0.000" start="9:46:23:044" finish="9:46:23:122" memoryDelta="339k">
  <statementSet id="security.getUserRolePerms_set" location="securityPMD.xml" elapsedSincePriorNode="0.000" start="9:46:23:044"/>
  <statement id="security.getSessionUserId" elapsed="16.000" elapsedSincePriorNode="1,427,831,183,060.000" elapsedAfterLastNode="0.000" start="9:46:23:059" finish="9:46:23:075" memoryDelta="0k">
  securityPMD.xml
  <execute id="STMT@2f780edb" elapsed="0.000" elapsedSincePriorNode="16.000" start="9:46:23:075" finish="9:46:23:075" memoryDelta="0k">
  <![CDATA[SELECT USER_ID FROM CMN_SESSIONS
  WHERE TOKEN = ?
setObject(): 1, 7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610
]]>
  </execute>
  </statement>
  <statement id="security.getUserRolePerms_stmt" elapsed="47.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="31.000" start="9:46:23:075" finish="9:46:23:122" memoryDelta="339k">
  securityPMD.xml
  <execute id="STMT@4b40e9b" elapsed="16.000" elapsedSincePriorNode="0.000" start="9:46:23:075" finish="9:46:23:091" memoryDelta="0k">
  <![CDATA[select object_id, permission_code
  from cmn_sec_chk_user_glb_r_v0 a
  where user_id = ?
setLong(): 1, 1
]]>
  </execute>
  </statement>
  </persistence>
  <JDBCQuery id="external_source_id_vals" elapsed="0.000" elapsedSincePriorNode="140.000" elapsedAfterLastNode="0.000" start="9:46:23:262" finish="9:46:23:262" memoryDelta="0k">

  select id from cmn_external_sources where source_code=UPPER('NIKU')

  <executeQuery id="STMT@acb501e" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:262" finish="9:46:23:262" memoryDelta="0k">
  <![CDATA[select id from cmn_external_sources where source_code=UPPER('NIKU')
]]>
  </executeQuery>
  </JDBCQuery>
  <JDBCQuery id="LOOKUP_USER_ID" elapsed="0.000" elapsedSincePriorNode="78.000" elapsedAfterLastNode="0.000" start="9:46:23:340" finish="9:46:23:340" memoryDelta="0k">

  select ID from CMN_SEC_USERS where USER_NAME = 'admin'

  <executeQuery id="STMT@140cb324" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:340" finish="9:46:23:340" memoryDelta="0k">
  <![CDATA[select ID from CMN_SEC_USERS where USER_NAME = 'admin'
]]>
  </executeQuery>
  </JDBCQuery>
  <JDBCQuery id="COMPANY_TYPE" elapsed="16.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:340" finish="9:46:23:356" memoryDelta="0k">

  select ID from CMN_LOOKUPS where LOOKUP_TYPE = 'CMP_COMPANY_TYPE' AND LOOKUP_CODE = UPPER('VENDOR')

  <executeQuery id="STMT@4345f1bf" elapsed="16.000" elapsedSincePriorNode="0.000" start="9:46:23:340" finish="9:46:23:356" memoryDelta="0k">
  <![CDATA[select ID from CMN_LOOKUPS where LOOKUP_TYPE = 'CMP_COMPANY_TYPE' AND LOOKUP_CODE = UPPER('VENDOR')
]]>
  </executeQuery>
  </JDBCQuery>
  <JDBCQuery id="COMPANY_STATUS" elapsed="0.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:356" finish="9:46:23:356" memoryDelta="0k">

  select ID from CMN_LOOKUPS where LOOKUP_TYPE = 'CMP_COMPANY_STATUS' AND LOOKUP_CODE = UPPER ('ACTIVE')

  <executeQuery id="STMT@3c2130f1" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:356" finish="9:46:23:356" memoryDelta="0k">
  <![CDATA[select ID from CMN_LOOKUPS where LOOKUP_TYPE = 'CMP_COMPANY_STATUS' AND LOOKUP_CODE = UPPER ('ACTIVE')
]]>
  </executeQuery>
  </JDBCQuery>
  <JDBCQuery id="COMPANY_EXISTS" elapsed="0.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:356" finish="9:46:23:356" memoryDelta="338k">

  select ID, STATUS from SRM_COMPANIES where COMPANY_ID = 'Test'

  <executeQuery id="STMT@21b4762d" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:356" finish="9:46:23:356" memoryDelta="0k">
  <![CDATA[select ID, STATUS from SRM_COMPANIES where COMPANY_ID = 'Test'
]]>
  </executeQuery>
  </JDBCQuery>
  <executeUpdate id="STMT@3bb66a5d" elapsed="16.000" elapsedSincePriorNode="15.000" start="9:46:23:371" finish="9:46:23:387" memoryDelta="0k">
  <![CDATA[UPDATE SRM_COMPANIES
  SET COMPANY_NAME = 'Test' ,
  TYPE = 411 , STATUS = 419 ,
  LAST_UPDATED_DATE = '2015-03-27' , LAST_UPDATED_BY = 1 ,
  EXTERNAL_SOURCE_ID = '1', EXTERNAL_ID = ' '
  WHERE COMPANY_ID = 'Test'
]]>
  </executeUpdate>
  </xogRequest>

</INFO><INFO date="2015-03-31 21:46:23,543" user="clarity:admin" session="7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610" action="XOG::company::write" thread="http-bio-8099-exec-1958" category="trace.server.user.admin">
<results>
</results>
</INFO><INFO date="2015-03-31 21:46:23,980" user="clarity:admin" session="7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610" action="none" thread="http-bio-8099-exec-1958" category="trace.server.user.admin">
  <xogRequest elapsed="234.000" elapsedAfterLastNode="0.000" start="9:46:23:746" finish="9:46:23:980" memoryDelta="1022k">
  <persistence id="security.deleteUserSession_set" elapsed="94.000" elapsedSincePriorNode="140.000" elapsedAfterLastNode="0.000" start="9:46:23:886" finish="9:46:23:980" memoryDelta="683k">
  <statementSet id="security.deleteUserSession_set" location="securityPMD.xml" elapsedSincePriorNode="0.000" start="9:46:23:886"/>
  <statement id="union.deleteSessionProps_stmt" elapsed="15.000" elapsedSincePriorNode="1,427,831,183,950.000" elapsedAfterLastNode="0.000" start="9:46:23:949" finish="9:46:23:964" memoryDelta="0k">
  unionPMD.xml
  <executeUpdate id="STMT@42b02409" elapsed="0.000" elapsedSincePriorNode="15.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  <![CDATA[DELETE CMN_SESSION_PROPERTIES
  WHERE SESSION_ID = ( SELECT CMN_SESSIONS.ID
  FROM CMN_SESSIONS
  WHERE CMN_SESSIONS.TOKEN = ? )
setObject(): 1, 7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610
]]>
  </executeUpdate>
  </statement>
  <statement id="security.deleteUserSession_stmt" elapsed="0.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  securityPMD.xml
  <executeUpdate id="STMT@3a0ded13" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  <![CDATA[DELETE CMN_SESSIONS WHERE TOKEN = ?
setObject(): 1, 7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610
]]>
  </executeUpdate>
  </statement>
  <statement id="projmgr.wbsDeleteGanttLoadLocks" elapsed="0.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  tasksPMD.xml
  <executeUpdate id="STMT@6847982b" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  <![CDATA[delete from prlock where prname=? and prtablename=? and prrecordid in (select cacheid
  from temp_wbs_keys
  where NLS_UPPER(sessionid) = NLS_UPPER(?))
setObject(): 1, ~ganttLoad
setObject(): 2, TEMP_WBS
setObject(): 3, 7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610
]]>
  </executeUpdate>
  </statement>
  <statement id="projmgr.wbsDeleteCaches_stmt" elapsed="0.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  tasksPMD.xml
  <executeUpdate id="STMT@34576489" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  <![CDATA[delete from temp_wbs
  where cacheid
  in (select cacheid
  from temp_wbs_keys
  where NLS_UPPER(sessionid) = NLS_UPPER(?))
setObject(): 1, 7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610
]]>
  </executeUpdate>
  </statement>
  <statement id="projmgr.wbsDeleteCachesExt_stmt" elapsed="0.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="339k">
  tasksPMD.xml
  <executeUpdate id="STMT@55897937" elapsed="0.000" elapsedSincePriorNode="0.000" start="9:46:23:964" finish="9:46:23:964" memoryDelta="0k">
  <![CDATA[delete from temp_wbs_ext
  where cacheid
  in (select cacheid
  from temp_wbs_keys
  where NLS_UPPER(sessionid) = NLS_UPPER(?))
setObject(): 1, 7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610
]]>
  </executeUpdate>
  </statement>
  <statement id="projmgr.wbsDeleteCacheKeys_stmt" elapsed="16.000" elapsedSincePriorNode="0.000" elapsedAfterLastNode="0.000" start="9:46:23:964" finish="9:46:23:980" memoryDelta="0k">
  tasksPMD.xml
  <executeUpdate id="STMT@347535c0" elapsed="16.000" elapsedSincePriorNode="0.000" start="9:46:23:964" finish="9:46:23:980" memoryDelta="0k">
  <![CDATA[delete from temp_wbs_keys
  where NLS_UPPER(sessionid) = NLS_UPPER(?)
setObject(): 1, 7065258__287DE2C6-A8A2-434F-B183-F8AA7B1E4610
]]>
  </executeUpdate>
  </statement>
  </persistence>
  </xogRequest>

</INFO>

If you need something more, please let me know.

EDIT: I tried same steps with Clarity version 13.3.0.286 05 11 (it's development environment for another customer) and it works without any problem.

Regards,

Martin

It still looks like date-format bug to me (try removing that date from the XML entirely).

--

This SQL statement in your trace file;

UPDATE SRM_COMPANIES

  SET COMPANY_NAME = 'Test' ,

  TYPE = 411 , STATUS = 419 ,

LAST_UPDATED_DATE = '2015-03-27' , LAST_UPDATED_BY = 1 ,

  EXTERNAL_SOURCE_ID = '1', EXTERNAL_ID = ' '

  WHERE COMPANY_ID = 'Test'

will generate that ORA-01861: literal does not match format string errror message when the NLS settings don't match (and the default Oracle one is 'dd-mon-yy' not 'yyyy-mm-dd' - that piece of code should really be using the date field with a explicit format mask.

Hi,

Pls, check user used to xog local settings and run that queries:

1. Run the following SQL queries against your Databases: 

select 1 as id, parameter, value from nls_database_parameters

where parameter = 'NLS_DATE_FORMAT'

union

select 2 as id, parameter, value from nls_instance_parameters

where parameter = 'NLS_DATE_FORMAT'

union

select 3 as id, parameter, value from nls_session_parameters

where parameter = 'NLS_DATE_FORMAT'

--- Make sure the NLS_DATE_FORMAT is set to "YYYY-MM-DD HH24:MI:SS"

As far as the native Oracle date format goes I had th displeasure of experiencing that, too.

Then I found

For input and output of dates, the standard Oracle date format is DD-MON-YY, as follows:

'13-NOV-92'

in Native Datatypes

and using that format worked just fine for me.

Hello,

this was the problem. Thank you.

Regards,

Martin