Service Desk Practitioners Forum
cancel

JDBC error 1934: creating Service Call

Highlighted
Tomas Votruba
Valued Contributor.

JDBC error 1934: creating Service Call

Hello Everyone,
At once there is an error by creating Service Call via SD client, emial or service pages. We haven't changed anything and I have found this returning code:

Fri, 04/04/2008 15:40:19 JDBC error 1934: [CZPLS107]INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'., SQL state: 01000 for query: INSERT INTO itsm_servicecalls
( ser_imp_oid
,ser_sta_oid
,ser_sel_oid
,ser_med_oid
,ser_attachment_exists
,ser_maximumduration
,ser_srv_oid
,ser_pri_oid
,slc_ser_per_oid
,ser_tem_oid
,ser_deadline_srv_oid
,ser_planduration
,ser_frequentlyaskedquestion
,ser_oid
,reg_created_by_oid
,reg_created
,ser_caller_org
,ser_caller_per
,ser_planfinish
,ser_deadline
,ser_planstart
,ser_description
,ser_id
,ser_ass_wog_from_oid
,ser_assignstatus
,ser_ass_per_from_oid
,ser_ass_wog_oid
,ser_cit_oid
,ser_waitforwo
,ser_lockseq
) VALUES ( ?
,?
,?
,?
,1
,?
,NULL
,?
,?
,?
,NULL
,?
,0
,?
,?
, CONVERT(DATETIME,? ,120)
,?
,?
, CONVERT(DATETIME,? ,120)
, CONVERT(DATETIME,? ,120)
, CONVERT(DATETIME,? ,120)
,?
,?
,?
,?
,?
,?
,NULL
,0
,? )
Values:
?3094610021
?3094610092
?281478201016407
?3094610042
?2.0
?3094610074
?281479605453533
?281478274941245
?1.0
?281500353443591
?1
CONVERT(DATETIME,?2008/4/4 13:40:19 ,120)
?281481907733138
?281484198675641
CONVERT(DATETIME,?2008/4/8 11:40:19 ,120)
CONVERT(DATETIME,?2008/4/7 22:0:0 ,120)
CONVERT(DATETIME,?2008/4/4 13:40:19 ,120)
?NL 270021742
?143509
?281478304891103
?3095986178
?281479605453533
?281478363742718
?1

Any help would be much appreciated.

Service Desk 4.5 SP20 on MS SQL 2000.

Regards, Tomas
1 REPLY
CA1501973
Honored Contributor.

Re: JDBC error 1934: creating Service Call

Hi Tomas,

Please do let me know SQL service pack for the service desk database instance.

If it is below to SP4, in that case you will have to install SP3 & SP4 on SQL Server for the Service Desk database.

I hope it helps.

Regards,
Crystenia