Service Desk Practitioners Forum
cancel

JDBC error 8114 while executing sd_event.exe

Highlighted
Raghunathan Tik
Outstanding Contributor.

JDBC error 8114 while executing sd_event.exe

Hi folks,
I am getting the following error when i am trying to log a change ticket using sd_event.exe file.

SERVER_RESPONSE=WARNING: JDBC error 8114: [SGX-OVSD1\SERVICEDESK]Error converting data type nvarchar to numeric., SQL state: 01000 for query: SELECT T1.cha_oid AS C0 ,T1.cha_lockseq AS C1 FROM itsm_changes T1 WHERE (T1.cha_sta_oid = ?) Values: Registeredjava.sql.SQLException: [SGX-OVSD1\SERVICEDESK]Error converting data type nvarchar to numeric.

the Command that i am trying is

sd_event.exe -f sd_event.ini -v Description="test" Status="Registered"

the sd_event.ini file content is:

[SD_EVENT]
LOGFILE=sd_event.log
ERROR_LOGFILE=sd_event_error.log
ACCOUNT=lotus/lotus1234
SERVER=sgx-ovsd1.sgxdo.sgx.com
PORT=30980
MAPPING=lotus
CLASSNAME=lotus
MODUS=insert
LANGUAGE=GB

Also attached is the snapshot of the mapping.

I am sure that I am wrong somewhere. Request one of you please specify as to what went wrong here.

thanks in advance.
// raman //
3 REPLIES
JaS_4
Acclaimed Contributor.

Re: JDBC error 8114 while executing sd_event.exe

Hi Raman,

Check your lotus mapping. Sounds like you have mapped a character field to a numeric field.
Raghunathan Tik
Outstanding Contributor.

Re: JDBC error 8114 while executing sd_event.exe

Hi,
Thanks for your reply.
i got it resolved by myself. I used the Source ID as the Unique Key and found all working as expected.

raman
Raghunathan Tik
Outstanding Contributor.

Re: JDBC error 8114 while executing sd_event.exe

the issue got resolved by exporting the tables from one table to another