Upgrade.sql error - String or binary data would be truncated

Upgrading from v9 to v11

We're on TelligentCommunity- I successfully execute the upgrade script to TelligentCommunity-, but then the upgrade fails with the following error when applying Upgrade.sql from the build TelligentCommunity-

Starting applying schema patch [10.2-IdeaCategories2] at 2019-09-04 20:10:34

Successfully applied patch [10.2-IdeaCategories2] after 17ms

Starting applying schema patch [10.2-ThemeStudio-MigrationPreparation] at 2019-09-04 20:10:34

Msg 50000, Level 16, State 1, Line 102252 Failed to apply schema patch [10.2-ThemeStudio-MigrationPreparation], Error 8152, Level 16, State 10, Batch Line 2: String or binary data would be truncated.

Completion time: 2019-09-04T20:10:38.1703221-05:00

Parents Reply
  • It appears that the 9.x site has a large number of wrapping formats defined for the site Social theme (3fc3f82...). Two potential work-arounds:

    Option 1: Manual restoration:

    1. Take note of the wrapping format configuration for this theme in 9 and remove all but one of the custom formats (to ensure the theme still identifies that there are custom formats).
    2. Upgrade the site to 11
    3. Restore the wrapping formats by editing the site Social theme and following the format of the single migrated format.

    Option 2: Export restoration:

    1. Export the Social theme from the 9.x site from Administration > Interface > Themes.
    2. Remove all but one custom wrapping format from the 9.x site.
    3. Upgrade the site to 11.
    4. Import the export from step 1 into Administration > Interface > Theme Studio