Web developers wiki ASP.NET Sitecore Sharepoint Kentico by Evident Interactive

When the Sitecore Sharepoint Connector module throws a "string or binary data would be truncated" exception we have to alter a couple of things in the Sitecore Master DB:

1. An exception occurs on document with Url lenght equals to 270 characters. So you need to change Key column type from varchar(255) to at least varchar(500) in IDTable(master database).

Implement the following steps to do this correctly:

1. Go to IDTable indexes. 2. Right click on ndxPrefixKey index ->Script Index As ->Create To -> New Query Editor Window. 3. Change Key column type(index based on this key will be deleted).

2. In SQL Management Studio navigate to your databases, IDTable table and change CustomData column type from varchar(255) to ntext by the following script

alter table IDTable alter column CustomData ntext

 © Evident Interactive BV