Error while restoring a backup (cloud backup, being restored on server)

Jason Coan November 8, 2018

How do I fix/prevent this error?

Error importing data: org.xml.sax.SAXException: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSHistoryStep][owner,][caller,qm:1ea0110b-4773-4956-8dc5-9835fc4114a4:5b3f71213a19e02e9b935e18][stepId,8][actionId,1031][finishDate,2018-07-13 20:57:02.329][id,111242][startDate,2018-07-13 20:53:35.329][entryId,73524][status,null] (SQL Exception while executing the following:INSERT INTO OS_HISTORYSTEP (ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'CALLER' at row 1)) java.lang.Exception: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSHistoryStep][owner,][caller,qm:1ea0110b-4773-4956-8dc5-9835fc4114a4:5b3f71213a19e02e9b935e18][stepId,8][actionId,1031][finishDate,2018-07-13 20:57:02.329][id,111242][startDate,2018-07-13 20:53:35.329][entryId,73524][status,null] (SQL Exception while executing the following:INSERT INTO OS_HISTORYSTEP (ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'CALLER' at row 1))

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.
November 8, 2018

While you can fix this by changing the size of the column in the database, the better question would be to raise an Atlassian support and ask why was "qm:1ea0110b-4773-4956-8dc5-9835fc4114a4:5b3f71213a19e02e9b935e18" (64 chars) generated into a 60 char column.

Suggest an answer

Log in or Sign up to answer