com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][id,11410][groupName,XXX][updatedDate,2011-05-04 13:28:51.993][description,Members of this management role group can view and manage the configuration for individual recipients and view recipients in an Exchange organization. Members of this role group can only manage the configuration each user can manage on his or her own mailbox. Additional permissions can be added by assigning additional management roles to this role group.][directoryId,10000][lowerDescription,members of this management role group can view and manage the configuration for individual recipients and view recipients in an exchange organization. members of this role group can only manage the configuration each user can manage on his or her own mailbox. additional permissions can be added by assigning additional management roles to this role group.][active,1][local,0][type,GROUP][lowerGroupName,help desk][createdDate,2011-05-04 13:28:51.993] (SQL Exception while executing the following:INSERT INTO jira.cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation))

Atlassian JIRA | James Winters [Atlassian] | 6 years ago
  1. 0

    The cwd_group table uses a length of 255 for the description and lower_description columns. Crowd has a longer limit than this, so during upgrade directories may not be added properly. You should see something similar to this in the logs, if you are affected. {code} com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][id,11410][groupName,XXX][updatedDate,2011-05-04 13:28:51.993][description,Members of this management role group can view and manage the configuration for individual recipients and view recipients in an Exchange organization. Members of this role group can only manage the configuration each user can manage on his or her own mailbox. Additional permissions can be added by assigning additional management roles to this role group.][directoryId,10000][lowerDescription,members of this management role group can view and manage the configuration for individual recipients and view recipients in an exchange organization. members of this role group can only manage the configuration each user can manage on his or her own mailbox. additional permissions can be added by assigning additional management roles to this role group.][active,1][local,0][type,GROUP][lowerGroupName,help desk][createdDate,2011-05-04 13:28:51.993] (SQL Exception while executing the following:INSERT INTO jira.cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation)) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.createValue(OfBizHelper.java:167) {code}

    Atlassian JIRA | 6 years ago | James Winters [Atlassian]
    com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][id,11410][groupName,XXX][updatedDate,2011-05-04 13:28:51.993][description,Members of this management role group can view and manage the configuration for individual recipients and view recipients in an Exchange organization. Members of this role group can only manage the configuration each user can manage on his or her own mailbox. Additional permissions can be added by assigning additional management roles to this role group.][directoryId,10000][lowerDescription,members of this management role group can view and manage the configuration for individual recipients and view recipients in an exchange organization. members of this role group can only manage the configuration each user can manage on his or her own mailbox. additional permissions can be added by assigning additional management roles to this role group.][active,1][local,0][type,GROUP][lowerGroupName,help desk][createdDate,2011-05-04 13:28:51.993] (SQL Exception while executing the following:INSERT INTO jira.cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation))
  2. 0

    The cwd_group table uses a length of 255 for the description and lower_description columns. Crowd has a longer limit than this, so during upgrade directories may not be added properly. You should see something similar to this in the logs, if you are affected. {code} com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][id,11410][groupName,XXX][updatedDate,2011-05-04 13:28:51.993][description,Members of this management role group can view and manage the configuration for individual recipients and view recipients in an Exchange organization. Members of this role group can only manage the configuration each user can manage on his or her own mailbox. Additional permissions can be added by assigning additional management roles to this role group.][directoryId,10000][lowerDescription,members of this management role group can view and manage the configuration for individual recipients and view recipients in an exchange organization. members of this role group can only manage the configuration each user can manage on his or her own mailbox. additional permissions can be added by assigning additional management roles to this role group.][active,1][local,0][type,GROUP][lowerGroupName,help desk][createdDate,2011-05-04 13:28:51.993] (SQL Exception while executing the following:INSERT INTO jira.cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation)) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.createValue(OfBizHelper.java:167) {code}

    Atlassian JIRA | 6 years ago | James Winters [Atlassian]
    com.atlassian.crowd.embedded.ofbiz.db.DataAccessException: org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][id,11410][groupName,XXX][updatedDate,2011-05-04 13:28:51.993][description,Members of this management role group can view and manage the configuration for individual recipients and view recipients in an Exchange organization. Members of this role group can only manage the configuration each user can manage on his or her own mailbox. Additional permissions can be added by assigning additional management roles to this role group.][directoryId,10000][lowerDescription,members of this management role group can view and manage the configuration for individual recipients and view recipients in an exchange organization. members of this role group can only manage the configuration each user can manage on his or her own mailbox. additional permissions can be added by assigning additional management roles to this role group.][active,1][local,0][type,GROUP][lowerGroupName,help desk][createdDate,2011-05-04 13:28:51.993] (SQL Exception while executing the following:INSERT INTO jira.cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation))

    Root Cause Analysis

    1. com.atlassian.crowd.embedded.ofbiz.db.DataAccessException

      org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:Group][id,11410][groupName,XXX][updatedDate,2011-05-04 13:28:51.993][description,Members of this management role group can view and manage the configuration for individual recipients and view recipients in an Exchange organization. Members of this role group can only manage the configuration each user can manage on his or her own mailbox. Additional permissions can be added by assigning additional management roles to this role group.][directoryId,10000][lowerDescription,members of this management role group can view and manage the configuration for individual recipients and view recipients in an exchange organization. members of this role group can only manage the configuration each user can manage on his or her own mailbox. additional permissions can be added by assigning additional management roles to this role group.][active,1][local,0][type,GROUP][lowerGroupName,help desk][createdDate,2011-05-04 13:28:51.993] (SQL Exception while executing the following:INSERT INTO jira.cwd_group (ID, group_name, lower_group_name, active, local, created_date, updated_date, description, lower_description, group_type, directory_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation))

      at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.createValue()
    2. com.atlassian.crowd
      OfBizHelper.createValue
      1. com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.createValue(OfBizHelper.java:167)
      1 frame