Originally asked by Support on 17 March 2023 (original question)
Hi,
I am experiencing the following issue when trying to Exalate a ticket from JSM to JIRA DC. I have previously been able to do this successfully, but from the error it seems like there’s something specific in the comments it’s trying to copy. Please, can you suggest what the issue is here?
while inserting: [GenericEntity:Action][updateauthor,JIRAUSER17700][issue,155542][level,null][author,JIRAUSER17700][created,0021-10-11 00:00:00.0][rolelevel,null][id,467363][type,comment][body,Werner, Andy commented: Ticket Owner changed to Customer Services KL on Oct 11 2021 11:48AM ][updated,0021-10-11 00:00:00.0] (SQL Exception while executing the following:INSERT INTO dbo.jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.))
Regards.
Comments:
Ariel Aguilar commented on 21 March 2023
Hi there,
It looks, the updated time is not valid. Is this happening to one transaction only?
Thanks,
Ariel
Support commented on 24 March 2023
Hey Ariel, yes it’s only affecting the one issue at the moment… But suspect it will affect more in the future.
It seems to be affecting issues where we’ve imported comments previously, so it may be something to do with the imported date format?
Greetings.