Search Community
- Force.com Discussion Boards
- :
- Salesforce User Discussions
- :
- Introduce Yourself
- :
- Duplicate Contact Blocker Error Message
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Duplicate Contact Blocker Error Message
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
10-19-2009 06:57 PM
I have installed the ForceLab Free Duplicate Contact Blocker.
Upon bulk import of contacts from Access Hoovers 2.0 (within the SFDC Interface). I get the following error message.
>CuplicateContactBlocker: execution of BeforeInsert caused by: System.Execption: Too many SOQL queries: 21 Trigger. DuplicateContactBlocker: line 4, column 55
Does anyone have any idea what this is, how I can go about fixing it. I am not very technical when it comes to code.
Any help is appreciated.
Re: Duplicate Contact Blocker Error Message
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
10-29-2009 11:46 AM
Re: Duplicate Contact Blocker Error Message
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
10-29-2009 12:08 PM
Thanks for the response. Unfortunately No, the import did not work. We were also getting this error with ZoomInfo.
This same error message (line of code) was repeated 18 times. After further investigation I figured out that my user was trying to import 18 records (which seem'd logical then; that the error was repeated 18 times). This might not be the real reason for the error 18 times but again... it seems logical that this is what was happening.
I began testing both ZoomInfo & Hoovers and determined that the magic number seems to be 10. We can successfully import 10 records at a time without triggering the error message.
Obviously the code must be pretty complex and with me brining in so many data elements on each record I must have exceeded the sql logic of 1000 queries (found out the 1000 query limit on the community boards).
So for any of you that run into the same problem, try selecting less records for import. I have instructed my users to only try to load 10 at a time. Then go back into the tool for the next batch of 10. Not the most efficient use of time for my users but the extra times they spend is worth keeping the data clean. It will take much more time to fix the duplicates on the back end if we turn Duplicate Blocker off.
Hope this helps someone in the future ![]()

