Switch Jira 3.12 databases to MS-SQL with custom fields

[Дмитрий TV]

Hi

I try import backup of jira 3.12 to MSSQL from HSQL but I have error:

Failed to import data: Error in action: com.atlassian.jira.action.admin.DataImport@1933eab, result: error Error importing data: org.apache.commons.lang.exception.NestableException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,23603][issue,11663][numbervalue,4.471491289001E12][customfield,10040] (SQL Exception while executing the following:INSERT INTO dbo.customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation))

How I can resolve this problem ?

[Dieter · Accepted solution]

Obviously this huge number (>1000000000000!) cannot be stored in the mysql column numbervalue. It's hard to say how this value was created and i just can give you a receipt how to make the import progress skip that particular value ( of course there may be a lot more of those values). if your export file was zipped unzip it and open the included xml file in an editor. Then locate the following string: CustomFieldValue id="23603" this should give you the xml element that causes the import problems. Just remove this element and save the xml which you now use to import. maybe you find more occurences of this strange number value in your xml file which should also be removed before you retry the import.