BCM error converting data type int to smallint

The problem: you receive an error while trying to delete a business contact or account: "error converting data type int to smallint". You can make changes to the contact, just not delete it.

This problem occurs when there are more than 32,767 (the number that a smallint can handle at max) business contacts in the database and you try to delete one of the contacts beyond 32,767.

When deleting a business contact dbo.DeleteContactoid gets called which itself calls dbo.UpdatePhoneLogs. dbo.UpdatePhoneLogs accepts @ContactServiceID and @GrandParentContactServiceID as smallints. Change both parameters to int and you're set.

Download and install SQL Management Studio: SQL Management Studio 2008 R2. You'll need to download the version of SQL to match your version of Windows.

To make the change, use SQL Management Studio and expand {database name} > Programmability > Stored Procedures.

1. Right click on dbo.UpdatePhoneLogs and choose Modify
2. Change @ContactServiceID and @GrandParentContactServiceID to int
3. Parse and Execute.
4. You can verify the change was successful by reopening the modify window.