Hello Im doing a data exchange, but i got a jdbc error when im using an ODBC connection. ServiceDesk 4.5 SP18 on HPUX
Could some one help me?
The got error is below
Following problems encountered while loading entities: ====================================================== Processing DATACMDB (id = 1) While processing DATACMDB (id = 1): JDBC error 1722: ORA-01722: invalid number , SQL state: 42000 for query: SELECT T1.cit_oid AS C0 ,T1.cit_lockseq AS C1 FROM itsm_configuration_items T1 WHERE (T1.cit_searchcode = ?) AND (T1.cit_name1 = ?) AND (T1.cit_sta_oid = ?) Values: PCJULIOS PCJULIOS Productionjava.sql.SQLException: ORA-01722: invalid number
================================================= Finished loading entities at December 8, 2006 18:49
What I see in the error message is that no parameter is being passed for the value of cit_sta_old. This is the OID for the Status of the CI.
Is it possible that your import mapping is expecting the OID of the status, but in reality the XML file contains the text of the status? You can check this in the "Reference to ..." field for the Status in the import mapping.