com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Resolution][id,10100][sequence,7][description,][name,Trying to put the resolution name to be longer than 60 characters and see if that will throw an error or something] (SQL Exception while executing the following:INSERT INTO resolution (ID, SEQUENCE, pname, DESCRIPTION, ICONURL) VALUES (?, ?, ?, ?, ?) (Data truncation: Data too long for column 'pname' at row 1))

Atlassian JIRA | Zulfadli Noor Sazali [Atlassian] | 3 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    The following are thrown in the {{atlassian-jira.log}} {noformat}com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Resolution][id,10100][sequence,7][description,][name,Trying to put the resolution name to be longer than 60 characters and see if that will throw an error or something] (SQL Exception while executing the following:INSERT INTO resolution (ID, SEQUENCE, pname, DESCRIPTION, ICONURL) VALUES (?, ?, ?, ?, ?) (Data truncation: Data too long for column 'pname' at row 1)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:393) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:206){noformat} Basically the {{pname}} column for {{resolution}} table has a limit of 60 characters, which can easily be updated in the database to have it more than 60 characters. Instead of showing the following image/page !error.png! It would be nicer to have a warning saying something like the following {quote}The 'resolution' name is too long. Please enter a shorter name.{quote}

    Atlassian JIRA | 3 years ago | Zulfadli Noor Sazali [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Resolution][id,10100][sequence,7][description,][name,Trying to put the resolution name to be longer than 60 characters and see if that will throw an error or something] (SQL Exception while executing the following:INSERT INTO resolution (ID, SEQUENCE, pname, DESCRIPTION, ICONURL) VALUES (?, ?, ?, ?, ?) (Data truncation: Data too long for column 'pname' at row 1))
  2. 0

    The following are thrown in the {{atlassian-jira.log}} {noformat}com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Resolution][id,10100][sequence,7][description,][name,Trying to put the resolution name to be longer than 60 characters and see if that will throw an error or something] (SQL Exception while executing the following:INSERT INTO resolution (ID, SEQUENCE, pname, DESCRIPTION, ICONURL) VALUES (?, ?, ?, ?, ?) (Data truncation: Data too long for column 'pname' at row 1)) at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:393) at com.atlassian.jira.ofbiz.WrappingOfBizDelegator.createValue(WrappingOfBizDelegator.java:206){noformat} Basically the {{pname}} column for {{resolution}} table has a limit of 60 characters, which can easily be updated in the database to have it more than 60 characters. Instead of showing the following image/page !error.png! It would be nicer to have a warning saying something like the following {quote}The 'resolution' name is too long. Please enter a shorter name.{quote}

    Atlassian JIRA | 3 years ago | Zulfadli Noor Sazali [Atlassian]
    com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Resolution][id,10100][sequence,7][description,][name,Trying to put the resolution name to be longer than 60 characters and see if that will throw an error or something] (SQL Exception while executing the following:INSERT INTO resolution (ID, SEQUENCE, pname, DESCRIPTION, ICONURL) VALUES (?, ?, ?, ?, ?) (Data truncation: Data too long for column 'pname' at row 1))

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Resolution][id,10100][sequence,7][description,][name,Trying to put the resolution name to be longer than 60 characters and see if that will throw an error or something] (SQL Exception while executing the following:INSERT INTO resolution (ID, SEQUENCE, pname, DESCRIPTION, ICONURL) VALUES (?, ?, ?, ?, ?) (Data truncation: Data too long for column 'pname' at row 1))

      at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue()
    2. com.atlassian.jira
      DefaultOfBizDelegator.createValue
      1. com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:393)
      1 frame