Business Contact Manager 2010:Only 80 total sales activities can be defined. Please delete other sales activities before adding another
Symptoms
When you try to add a sales activity, you may see the following error:
Only 80 total sales activities can be defined. Please delete other sales activities before adding another.
Cause
This occurs because Hidden User Field definitions are present in the database.
Resolution
1. Download and install SQL Management Studio
2. Backup the BCM Database
3. In SQL Management Studio run the following Query
use <Database>
delete from UserFieldDefinitions where datatableid = '4' and predefinedmetadatablob <> -1
where <Database> is the name of the affected Database
4. Backup the BCM Database Again – be sure and give the backup a different name than the
one in Step 2!
5. Create a new BCM Database
6. Restore the Database backup from Step 4
Thanks & Regards
Rahul Thomas