Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-6295

Upgrade from 2.0.2 fails with many projects: inserted value too large for column

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            anton@atlassian.com AntonA
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 1h
                1h
                Remaining:
                Remaining Estimate - 1h
                1h
                Logged:
                Time Spent - Not Specified
                Not Specified