Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.1.1
-
Upgrading from JIRA 2.0.2, using Oracle
-
3.01
-
Description
Upgrade Task 47 automatically generates a name for the created permission schemes by creating a comma separated list of projects which the scheme is associated with.
If the number of projects is high enough and/or the project names are long enough the upgrade task will fail with something like:
2005-03-24 14:25:10,890 ERROR [atlassian.jira.upgrade.UpgradeManagerImpl] Exception thrown during upgrade: while updating: [GenericEntity:PermissionScheme][description,This permission scheme has been set up for Project TQMC_Arbeitsgruppen, TQMC_Beschwerdemanagement, TQMC_Produktkreise, TQMC_Projekte, TQMC_Qualitätszirkel, TQMR_BSM-Reporting, TQMR_Zufriedenheitsstudien, TQMS_MA als Testkunde, TQMS_Meinungsbox, TQMS_Qualitätsanalysen, TQMS_Reputation Risk, TQMS_Service Test][name,TQMC_Arbeitsgruppen, TQMC_Beschwerdemanagement, TQMC_Produktkreise, TQMC_Projekte, TQMC_Qualitätszirkel, TQMR_BSM-Reporting, TQMR_Zufriedenheitsstudien, TQMS_MA als Testkunde, TQMS_Meinungsbox, TQMS_Qualitätsanalysen, TQMS_Reputation Risk, TQMS_Service Test][id,10030] (SQL Exception while executing the following:UPDATE permissionscheme SET NAME=?, DESCRIPTION=? WHERE ID=? (ORA-01401: inserted value too large for column
))
org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:PermissionScheme][description,This permission scheme has been set up for Project TQMC_Arbeitsgruppen, TQMC_Beschwerdemanagement, TQMC_Produktkreise, TQMC_Projekte, TQMC_Qualitätszirkel, TQMR_BSM-Reporting, TQMR_Zufriedenheitsstudien, TQMS_MA als Testkunde, TQMS_Meinungsbox, TQMS_Qualitätsanalysen, TQMS_Reputation Risk, TQMS_Service Test][name,TQMC_Arbeitsgruppen, TQMC_Beschwerdemanagement, TQMC_Produktkreise, TQMC_Projekte, TQMC_Qualitätszirkel, TQMR_BSM-Reporting, TQMR_Zufriedenheitsstudien, TQMS_MA als Testkunde, TQMS_Meinungsbox, TQMS_Qualitätsanalysen, TQMS_Reputation Risk, TQMS_Service Test][id,10030] (SQL Exception while executing the following:UPDATE permissionscheme SET NAME=?, DESCRIPTION=? WHERE ID=? (ORA-01401: inserted value too large for column
))
at org.ofbiz.core.entity.GenericDAO.singleUpdate(GenericDAO.java:220)
at org.ofbiz.core.entity.GenericDAO.customUpdate(GenericDAO.java:164)
at org.ofbiz.core.entity.GenericDAO.update(GenericDAO.java:157)
at org.ofbiz.core.entity.GenericHelperDAO.store(GenericHelperDAO.java:207)
at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1396)
at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1376)
at org.ofbiz.core.entity.GenericValue.store(GenericValue.java:81)
The names of permission schemes are limited to 255 characters on most databses and 250 characters on Firebird.