AnsweredAssumed Answered

Unable to write company

Question asked by msnizek on Mar 31, 2015
Latest reply on Apr 8, 2015 by msnizek



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?