value too large for column during HSQL migration

[Steven Wallace]

We are trying to migrate data from the HSQL evaluation database to Oracle as part of our production install. During this process we are receiving errors like the below. The error seems related to the Checklist plugin we used in our trail evaluation. 

We used this plugin to build acceptance criteria lists for our user stories. Is migrating this data not possible now or are we missing something?

Thanks,

Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][customfield,10010][issue,10041][stringvalue,[V1-0-M]Determine if SpeedPay API is available. Document API requirements and implement a basic API test that demonstrates GMP's ability to use the API correctly in a development environment. API test can be confirmed with simple curl calls or a basic Java test class.][id,10178] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-12899: value too large for column "JIRA"."CUSTOMFIELDVALUE"."STRINGVALUE" (actual: 268, maximum: 255) )) java.lang.Exception: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][customfield,10010][issue,10041][stringvalue,[V1-0-M]Determine if SpeedPay API is available. Document API requirements and implement a basic API test that demonstrates GMP's ability to use the API correctly in a development environment. API test can be confirmed with simple curl calls or a basic Java test class.][id,10178] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-12899: value too large for column "JIRA"."CUSTOMFIELDVALUE"."STRINGVALUE" (actual: 268, maximum: 255) ))

[Pedro Cora]

HI Steven,

This knowledge base article: https://confluence.atlassian.com/display/CONFKB/Failed+to+upgrade+confluence+with+error%3A+Caused+by%3A+java.sql.SQLException%3A+ORA-12899%3A+value+too+large+for+column might help. Even though it 's from Confluence, the queries that you need to run are similar.