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))

Atlassian JIRA | Joachim Ooi [Atlassian] | 7 years ago
  1. 0

    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.

    Atlassian JIRA | 7 years ago | 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))
  2. 0

    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.

    Atlassian JIRA | 7 years ago | 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))
  3. 0

    Got the following stack trace when trying to create an issue. Customfield = QTP Test Results Path (Text Field (< 255 characters) ) {noformat} value trying to insert = //jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/ javax.mail.MessagingException: Unhandled Exception. Unable to process mail from eric.geurts@dieteren.be : org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,13175][stringvalue,//jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/][issue,11103][parentkey,null][customfield,10165] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xC2\x97BIC/...' for column 'STRINGVALUE' at row 1)); nested exception is: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,13175][stringvalue,//jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/][issue,11103][parentkey,null][customfield,10165] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xC2\x97BIC/...' for column 'STRINGVALUE' at row 1)) at com.dolby.atlassian.jira.service.util.handler.EMHCreateIssueHandler.handleMessage(EMHCreateIssueHandler.java:137) at com.dolby.atlassian.jira.service.util.handler.CreateOrCommentHandler.handleMessage(CreateOrCommentHandler.java:171) at com.atlassian.jira.service.services.mail.MailFetcherService.run(MailFetcherService.java:190) at com.atlassian.jira.service.JiraServiceContainerImpl.run(JiraServiceContainerImpl.java:67) at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:61) at org.quartz.core.JobRunShell.run(JobRunShell.java:191) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516) {noformat}

    JIRA | 8 years ago | Geurts null
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,13175][stringvalue,//jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/][issue,11103][parentkey,null][customfield,10165] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xC2\x97BIC/...' for column 'STRINGVALUE' at row 1))
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Got the following stack trace when trying to create an issue. Customfield = QTP Test Results Path (Text Field (< 255 characters) ) {noformat} value trying to insert = //jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/ javax.mail.MessagingException: Unhandled Exception. Unable to process mail from eric.geurts@dieteren.be : org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,13175][stringvalue,//jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/][issue,11103][parentkey,null][customfield,10165] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xC2\x97BIC/...' for column 'STRINGVALUE' at row 1)); nested exception is: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,13175][stringvalue,//jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/][issue,11103][parentkey,null][customfield,10165] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xC2\x97BIC/...' for column 'STRINGVALUE' at row 1)) at com.dolby.atlassian.jira.service.util.handler.EMHCreateIssueHandler.handleMessage(EMHCreateIssueHandler.java:137) at com.dolby.atlassian.jira.service.util.handler.CreateOrCommentHandler.handleMessage(CreateOrCommentHandler.java:171) at com.atlassian.jira.service.services.mail.MailFetcherService.run(MailFetcherService.java:190) at com.atlassian.jira.service.JiraServiceContainerImpl.run(JiraServiceContainerImpl.java:67) at com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:61) at org.quartz.core.JobRunShell.run(JobRunShell.java:191) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516) {noformat}

    JIRA | 8 years ago | Geurts null
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:CustomFieldValue][id,13175][stringvalue,//jupiter.dpc.dieteren.be/ctg/CTG/Framework/02-FrameworkMyTeam—BIC/Developement framework/05-Results/Release_v00.2.260/Execution/2008-11-6_15h17_58/][issue,11103][parentkey,null][customfield,10165] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Incorrect string value: '\xC2\x97BIC/...' for column 'STRINGVALUE' at row 1))
  6. 0

    h1. Symptom Getting the following error when trying to view a profile page: {noformat} jiraschema.userhistoryitem (ID, entitytype, entityid, USERNAME, lastviewed, data) VALUES (?, ?, ?, ?, ?, ?) (Cannot insert duplicate key row in object 'jiraschema.userhistoryitem' with unique index 'uh_type_user_entity'.)) com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserHistoryItem][id,10374][username,admin][data,null][entityId,admin][lastViewed,1350569188345][type,Assignee] (SQL Exception while executing the following:INSERT INTO jiraschema.userhistoryitem (ID, entitytype, entityid, USERNAME, lastviewed, data) VALUES (?, ?, ?, ?, ?, ?) (Cannot insert duplicate key row in object 'jiraschema.userhistoryitem' with unique index 'uh_type_user_entity'.)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:379) at com.atlassian.jira.user.OfBizUserHistoryStore.addHistoryItemNoChecks(OfBizUserHistoryStore.java:104) at com.atlassian.jira.user.CachingUserHistoryStore$2.run(CachingUserHistoryStore.java:94) at com.atlassian.util.concurrent.ManagedLocks$ManagedLockImpl.withLock(ManagedLocks.java:333) at com.atlassian.jira.user.CachingUserHistoryStore.addHistoryItem(CachingUserHistoryStore.java:84) at com.atlassian.jira.user.SessionBasedAnonymousUserHistoryStore$2.run(SessionBasedAnonymousUserHistoryStore.java:120) at com.atlassian.util.concurrent.ManagedLocks$ManagedLockImpl.withLock(ManagedLocks.java:333) {noformat} h2. Cause If a user's name changes case and you are connected to a database that does case insensitive comparison (e.g. MSSQL 2008 as setup following the steps on https://confluence.atlassian.com/x/CpX2Cw). The most common way for a user's name to change is for it to change in an external user directory where case is important (e.g. some LDAP servers). h2. Steps * Setup JIRA to an LDAP directory. * Create a user with username "testuser" in the internal JIRA directory. * Login with username "testuser" * Go to the user's profile page. * Inside the LDAP directory, create a user "TestUser". * Move the LDAP directory to the top. * (BUG) Go to the current user's profile page. You will get the above exception.

    Atlassian JIRA | 4 years ago | Brenden Bain [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:UserHistoryItem][id,10374][username,admin][data,null][entityId,admin][lastViewed,1350569188345][type,Assignee] (SQL Exception while executing the following:INSERT INTO jiraschema.userhistoryitem (ID, entitytype, entityid, USERNAME, lastviewed, data) VALUES (?, ?, ?, ?, ?, ?) (Cannot insert duplicate key row in object 'jiraschema.userhistoryitem' with unique index 'uh_type_user_entity'.))

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    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()
    2. com.atlassian.jira
      DefaultCommentService.create
      1. com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:202)
      2. com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:170)
      3. com.atlassian.jira.issue.comments.DefaultCommentManager.create(DefaultCommentManager.java:164)
      4. com.atlassian.jira.bc.issue.comment.DefaultCommentService.create(DefaultCommentService.java:156)
      4 frames