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

JIRA | Geurts null | 8 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 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))
  2. 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))

    Root Cause Analysis

    1. 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()
    2. com.dolby.atlassian
      CreateOrCommentHandler.handleMessage
      1. com.dolby.atlassian.jira.service.util.handler.EMHCreateIssueHandler.handleMessage(EMHCreateIssueHandler.java:137)
      2. com.dolby.atlassian.jira.service.util.handler.CreateOrCommentHandler.handleMessage(CreateOrCommentHandler.java:171)
      2 frames
    3. com.atlassian.jira
      ServiceRunner.execute
      1. com.atlassian.jira.service.services.mail.MailFetcherService.run(MailFetcherService.java:190)
      2. com.atlassian.jira.service.JiraServiceContainerImpl.run(JiraServiceContainerImpl.java:67)
      3. com.atlassian.jira.service.ServiceRunner.execute(ServiceRunner.java:61)
      3 frames
    4. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:191)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:516)
      2 frames