Service Desk Practitioners Forum
cancel

Need help to interpet JDBC error 8115

Highlighted
Jan Gunnar Helg
Senior Member

Need help to interpet JDBC error 8115

Hi

During a import of person data to person table in SD using data exchange we randomly get an error like this:

JDBC error 8115: [GDC-VSQL-C04\GAPP02]Arithmetic overflow error converting expression to data type datetime., SQL state: 22003 for query: UPDATE itsm_per_custom_fields SET pec_persondate1= CONVERT(DATETIME,?,120) WHERE (((pec_per_oid = ?))) Values: CONVERT(DATETIME,?1600/12/31 23:0:0 ,120) ((pec_per_oid = ?281505275380058 ))

I can find the person object by identifying the object ID. But I cannot figure out what causes this error to occur?

Can someone help me interpet this?
2 REPLIES
Jan Gunnar Helg
Senior Member

Re: Need help to interpet JDBC error 8115

bump
Jan Gunnar Helg
Senior Member

Re: Need help to interpet JDBC error 8115

I identifed the issue.

I was trying to pass an invalid date to a date time field on the person form.

Removed the date field from my mapping, problem gone.
//Add this to "OnDomLoad" event