AnsweredAssumed Answered

Unable to write company

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

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

Outcomes