com.atlassian.jira.exception.DataAccessException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • When adding a comment that contains Unicode characters outside the BMP (e.g.- ⚔✏Ṣᴔᖲ⋂𒟤ၽ긄ְ𳨒𝴠㧁㸏㱠嫖㰾) JIRA throws the following error (Oops - an error has occurred): {noformat} ... Cause: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,10030][body,?????????????????][author,admin][level,null][updated,2010-05-04 15:04:55.046][created,2010-05-04 15:04:55.046][issue,10011][rolelevel,null][type,comment][updateauthor,admin] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x92\x9F\xA4\xE1\x81...' for column 'actionbody' at row 1)) ... com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,10031][body,?????????????????][author,admin][level,null][updated,2010-05-04 15:07:43.156][created,2010-05-04 15:07:43.156][issue,10011][rolelevel,null][type,comment][updateauthor,admin] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x92\x9F\xA4\xE1\x81...' for column 'actionbody' at row 1)) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:202) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:170) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:164) at com.atlassian.jira.bc.issue.comment.DefaultCommentService.create(DefaultCommentService.java:156) ... {noformat} It is *IMPORTANT* to note that this error may also crop up when the MySQL server and/or JIRA connection to it are mis-configured. In this case JIRA may also fail for characters in the Unicode BMP (see https://confluence.atlassian.com/display/JIRAKB/SQL+Exception+when+Entering%2C+Updating+or+Importing+an+Issue+in+JIRA+with+MySQL+Due+to+Encoding). In this case this issue does not apply and its just a configuration problem. This problem only happens in *MySQL* environment. MySQL has a [known limitation|http://jira.atlassian.com/browse/JRA-21224?focusedCommentId=217291&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-217291] in that it is unable to store 4 byte UTF-8 characters in MySQL before 5.5.3. I think we should: # Add a startup warning admins when JIRA connects to a MySQL database with these problems. # Update the documentation of MySQL database configuration to indicate this problem. # Sanatising the input so that this error does not occur when connected to MySQL before 5.5.3. This will probably be much harder than it sounds because JIRA can get input data from anywhere (e.g. CSV, E-Mail, HTTP, SOAP etc). We will probably have to choose our battles. # Update out documentation to indicate this is the database that gets around this problem. # Update the upgrade guide once we work out an upgrade path.
    via by Joachim Ooi [Atlassian],
  • When adding a comment that contains Unicode characters outside the BMP (e.g.- ⚔✏Ṣᴔᖲ⋂𒟤ၽ긄ְ𳨒𝴠㧁㸏㱠嫖㰾) JIRA throws the following error (Oops - an error has occurred): {noformat} ... Cause: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,10030][body,?????????????????][author,admin][level,null][updated,2010-05-04 15:04:55.046][created,2010-05-04 15:04:55.046][issue,10011][rolelevel,null][type,comment][updateauthor,admin] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x92\x9F\xA4\xE1\x81...' for column 'actionbody' at row 1)) ... com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,10031][body,?????????????????][author,admin][level,null][updated,2010-05-04 15:07:43.156][created,2010-05-04 15:07:43.156][issue,10011][rolelevel,null][type,comment][updateauthor,admin] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x92\x9F\xA4\xE1\x81...' for column 'actionbody' at row 1)) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:202) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:170) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:164) at com.atlassian.jira.bc.issue.comment.DefaultCommentService.create(DefaultCommentService.java:156) ... {noformat} It is *IMPORTANT* to note that this error may also crop up when the MySQL server and/or JIRA connection to it are mis-configured. In this case JIRA may also fail for characters in the Unicode BMP (see https://confluence.atlassian.com/display/JIRAKB/SQL+Exception+when+Entering%2C+Updating+or+Importing+an+Issue+in+JIRA+with+MySQL+Due+to+Encoding). In this case this issue does not apply and its just a configuration problem. This problem only happens in *MySQL* environment. MySQL has a [known limitation|http://jira.atlassian.com/browse/JRA-21224?focusedCommentId=217291&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-217291] in that it is unable to store 4 byte UTF-8 characters in MySQL before 5.5.3. I think we should: # Add a startup warning admins when JIRA connects to a MySQL database with these problems. # Update the documentation of MySQL database configuration to indicate this problem. # Sanatising the input so that this error does not occur when connected to MySQL before 5.5.3. This will probably be much harder than it sounds because JIRA can get input data from anywhere (e.g. CSV, E-Mail, HTTP, SOAP etc). We will probably have to choose our battles. # Update out documentation to indicate this is the database that gets around this problem. # Update the upgrade guide once we work out an upgrade path.
    via by Joachim Ooi [Atlassian],
    • com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Action][id,10031][body,?????????????????][author,admin][level,null][updated,2010-05-04 15:07:43.156][created,2010-05-04 15:07:43.156][issue,10011][rolelevel,null][type,comment][updateauthor,admin] (SQL Exception while executing the following:INSERT INTO jiraaction (ID, issueid, AUTHOR, actiontype, actionlevel, rolelevel, actionbody, CREATED, UPDATEAUTHOR, UPDATED, actionnum) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xF0\x92\x9F\xA4\xE1\x81...' for column 'actionbody' at row 1)) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:202) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:170) at com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:164) at com.atlassian.jira.bc.issue.comment.DefaultCommentService.create(DefaultCommentService.java:156)
    No Bugmate found.