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

Upgrading from v9 to v11

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

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
  • Just tried that and I am getting the same error.

    Starting applying schema patch [10.2-ThemeStudio-MigrationPreparation] at 2019-09-05 09:52:54
    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.
    Msg 207, Level 16, State 1, Procedure cs_vw_Users_FullUser, Line 14 [Batch Start Line 104206]

Children
  • 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
  • Thanks Ben!  I went into the theme and just deleted those definitions and the upgrade worked fine now!