com.atlassian.crowd.embedded.ofbiz.db.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.

  • 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}
    via by James Winters [Atlassian],
  • 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}
    via by 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)) at com.atlassian.crowd.embedded.ofbiz.db.OfBizHelper.createValue(OfBizHelper.java:167)
    No Bugmate found.