Liferay 7 Upgrade is truncating DDM data

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 Beta 7
• Fix Version/s: 7.0.0 CE RC1, 7.0.0 DXP SP1
• Component/s: Dynamic Data Mapping > Upgrades
• Labels:
  • EE-Only
  • LR7UPGRADE
• Fix Priority: 3
• Databases:
  SQL Server 2008 R2
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/36763

I'm not 100% sure why it's happening, but Liferay 7 is trying to insert this DDM data via a Verify on boot, in the description column:

<?xml version='1.0' encoding='UTF-8'?><root available-locales="en_US,es_ES,ja_JP,iw_IL,fi_FI,nl_NL,zh_CN,de_DE,ca_ES,pt_BR,fr_FR,hu_HU," default-locale="en_US"><Description language-id="es_ES">Muestra una columna para cada vocabulario. Cada columna incluye el nombre de un vocabulario con categorías de nivel superior del vocabulario listados debajo.</Description><Description language-id="ja_JP">各用語用に列を表示する。各列は以下にリストになっている、最上位に設定されている用語名を含んでいます</Description><Description language-id="iw_IL">Displays a column for each vocabulary. Each column includes the name of a vocabulary with the vocabulary's top level categories listed underneath.</Description><Description language-id="fi_FI">Displays a column for each vocabulary. Each column includes the name of a vocabulary with the vocabulary's top level categories listed underneath.</Description><Description language-id="nl_NL">Geeft een kolom voor elke woordenschat weer. Elke kolom bevat de naam van een vocabulaire met het vocabulaire toprubrieken vermeld onder.</Description><Description language-id="zh_CN">显示每个词汇为一列。每个列包含词汇的名称与词汇的最高级别类别下面列出。</Description><Description language-id="de_DE">Stellt eine Spalte für jedes Vokabular dar. Jede Spalte enthält den Namen eines Vokabulars mit der obersten Kategorienebene darunter.</Description><Description language-id="en_US">Displays a column for each vocabulary. Each column includes the name of a vocabulary with the vocabulary's top level categories listed underneath.</Description><Description language-id="ca_ES">Displays a column for each vocabulary. Each column includes the name of a vocabulary with the vocabulary's top level categories listed underneath.</Description><Description language-id="pt_BR">Exibe uma coluna para cada vocabulário. Cada coluna inclui o nome de um vocabulário com as categorias de nível superior do vocabulário, listadas abaixo.</Description><Description language-id="fr_FR">Affiche une colonne pour chaque vocabulaire. Chaque colonne inclut le nom d'un vocabulaire avec les catégories de niveau supérieur du vocabulaire répertoriées sous.</Description><Description language-id="hu_HU">Megjelenít egy oszlopot minden szótár számára. Minden oszlop tartalmazza a szótár nevét, alatta a szótár felső szintű kategóriáival.</Description></root>

Which is over the nvarchar(2000) size and just dies. Can we increase the description size to nvarchar(max)?

I get this error:

Could not execute JDBC batch update [insert into DDMTemplate (uuid_, groupId, companyId, userId, userName, versionUserId, versionUserName, createDate, modifiedDate, classNameId, classPK, resourceClassNameId, templateKey, version, name, description, type_, mode_, language, script, cacheable, smallImage, smallImageId, smallImageURL, lastPublishDate, templateId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]