Jira import fail - "The import was aborted because there were too many errors"

[Dennis Bursy]

Hi everyone!

we want to migrate a project:

Now we become this failure message:

"The import was aborted because there were too many errors"

In the log files are many messages like this:

(Incorrect string value: '\xF0\x9F\x93\x8E 2...' for column 'DESCRIPTION' at row 1)

Is this an encoding problem ?

Here the full stacktrace for one process:

2019-06-21 22:33:57,479 ProjectImport: CreateIssues:thread-4 ERROR dennisb 1353x1383x1 17l2iae 79.201.166.56,10.3.252.21,0:0:0:0:0:0:0:1 /secure/admin/ProjectImportSummary.jspa [c.a.j.imports.project.DefaultProjectImportPersister] Unable to create issue with key 'ELMS-3040'.
com.atlassian.jira.external.ExternalException: Unable to create issue: ELMS-7187
at com.atlassian.jira.external.ExternalUtils.createIssue(ExternalUtils.java:228)
at com.atlassian.jira.imports.project.DefaultProjectImportPersister.createIssue(DefaultProjectImportPersister.java:145)
at com.atlassian.jira.imports.project.handler.IssuePersisterHandler$1.run(IssuePersisterHandler.java:71)
at com.atlassian.jira.util.concurrent.BoundedExecutor$1.run(BoundedExecutor.java:50)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.atlassian.jira.exception.CreateException: com.atlassian.jira.workflow.WorkflowException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,Falsches Icon, Abstände und Strings auf Button][watches,0][creator,j.z][created,2018-08-23 10:58:38.09][timespent,null][timeoriginalestimate,null][project,10501][description,Bitte so anpassen, wie in den anderen Blöcken, die Buttons müssen auf der gleichen Höhe stehen, wie sonst auch. Auf den Buttons soll stehen: Bewertung , Abschlüsse. Habe mal aus anderer Design Studie zum ein Bild eingefüngt. Farben natürlich nicht ändern.
📎 2 Files

_Issue created by the Stride bot in the Bug-Sammlung conversation by J Z._][reporter,j.z][type,10100][priority,3][number,7187][environment,null][security,null][timeestimate,null][duedate,null][resolutiondate,null][votes,0][assignee,sebo][id,22646][updated,2018-08-30 14:38:31.01][workflowId,22646][status,10304] (SQL Exception while executing the following:INSERT INTO jiraissue (ID, pkey, issuenum, PROJECT, REPORTER, ASSIGNEE, CREATOR, issuetype, SUMMARY, DESCRIPTION, ENVIRONMENT, PRIORITY, RESOLUTION, issuestatus, CREATED, UPDATED, DUEDATE, RESOLUTIONDATE, VOTES, WATCHES, TIMEORIGINALESTIMATE, TIMEESTIMATE, TIMESPENT, WORKFLOW_ID, SECURITY, FIXFOR, COMPONENT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x9F\x93\x8E 2...' for column 'DESCRIPTION' at row 1))
at com.atlassian.jira.issue.managers.DefaultIssueManager.createIssue(DefaultIssueManager.java:519)
at com.atlassian.jira.issue.managers.RequestCachingIssueManager.createIssue(RequestCachingIssueManager.java:204)
... 6 more
Caused by: com.atlassian.jira.workflow.WorkflowException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Issue][summary,Falsches Icon, Abstände und Strings auf Button][watches,0][creator,j.z][created,2018-08-23 10:58:38.09][timespent,null][timeoriginalestimate,null][project,10501][description,Bitte den Pfeil benutzen der bei allen Blöcken genutzt wird. Bitte die Abstände unter den Buttons so anpassen, wie in den anderen Blöcken, die Buttons müssen auf der gleichen Höhe stehen, wie sonst auch. Auf den Buttons soll stehen: Bewertung , Abschlüsse. Habe mal aus anderer Design Studie zum ein Bild eingefüngt. Farben natürlich nicht ändern.
📎 2 Files

Or is this an error like this?

https://confluence.atlassian.com/confkb/incorrect-string-value-error-thrown-when-restoring-xml-backup-in-confluence-777009599.html

Have you any suggestions here ?

Best regards

Dennis

[Andy Heinzer]

Hi Dennis,
I see that you created a separate topic for this problem.   Had I known, I would have replied here instead.  Just to try to close the loop, I posted a response to this specific error over in https://community.atlassian.com/t5/Jira-questions/Re-Re-Migrate-Jira-project-from-cloud-to-server/qaq-p/1115558/comment-id/355283#M355283

The problem looks to be caused by a known limitation in regards to MySQL databases when used with Jira Server and their inability to store 4-byte characters like emojis or in this case the attachment/paperclip character.  The solution here can vary depending on the version of Jira in use. 

For Jira 8 and higher, Jira officially supports MySQL 5.7 versions setup to use the utf8mb4 encoding that can handle these characters correctly. 

For older Jira versions there is a bug ticket about this in JRASERVER-36135 - That ticket does explain some alternative methods to work past this problem.

I hope this helps of both you Dennis, and anyone else that might come across this same error.

Regards,

Andy