Service Desk Practitioners Forum
cancel

Data exchange error JDBC error 1722

Highlighted
Julio Flores
Regular Contributor.

Data exchange error JDBC error 1722

Hello
Im doing a data exchange, but i got a jdbc error when im using an ODBC connection. 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

Thks
3 REPLIES
JaS_4
Acclaimed Contributor.

Re: Data exchange error JDBC error 1722

Hi Julio,

The error message says it all. You are passing an alphabetic value when it is expecting a number.
Looks like you are passing PCJULIOS for searchcode, PCJULIOS for cit_name1 and Production for cit_sta_oid. Looks like the last argument is wrong. oid is always a number.
Julio Flores
Regular Contributor.

Re: Data exchange error JDBC error 1722

Hi
Thks a lot, the issue has been solved. The field Status was a wrong vale, now is mapped correctly in the import-mapping
JaS_4
Acclaimed Contributor.

Re: Data exchange error JDBC error 1722

Ahhh.. The cit_sta_oid must be the unique identifier to the field of status with each number representing a different status.
Glad to hear it's resolved. ;)