Import data into JIRA 4.4

Karen.Newsome@crowley.com February 6, 2013

I received this error during the data import into SQL Server 2008 Database:

Unexpected error occurred during import: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Worklog][id,14201][body,][author,freshmk][startdate,0001-01-06 14:46:02.0][updated,2013-01-04 15:15:21.0][created,2013-01-04 15:15:21.0][issue,135483][timeworked,900][updateauthor,freshmk] (SQL Exception while setting value: (Only dates between January 1, 1753 and December 31, 9999 are accepted.))

Can the STARTDATE on the WorkLog Table be updated via MySQL to correct this error? Are there any other tables that would be effected by this update?

1 answer

1 accepted

0 votes
Answer accepted
Timothy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 6, 2013

It does look like the import is failing because of that weird date. You should be able to update the record without any problems. But of course, just keep a backup of your existing database.

Suggest an answer

Log in or Sign up to answer