Reply
Contributor
Blonde
Posts: 8

Duplicate Contact Blocker Error Message

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.

Trusted Contributor
MATTYBME
Posts: 395

Re: Duplicate Contact Blocker Error Message

Did the bulk import work? If it did did you uncheck the checkboxes on the Duplicate Contact Blocker app? We have that app as weel and sometimes when we uncheck all the boxes to do an import of data we get an error message as well. Upon re-edited and re-selecting the checkboxes the error message goes away. It should not affect the import.
Contributor
Blonde
Posts: 8

Re: Duplicate Contact Blocker Error Message

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 :smileyhappy: