You need to sign in to do that
Don't have an account?
bikla78
Before Update SOQL query strange exeception
I a getting a strange error. I am performing insert using the apex dataloader. However, I am receiving a before update exception? Does anyone now why an update exception would show up when I am inserting new records?
Event_To_Cand_Status: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Class.Event_WorkFlow_Manager.UpdateCandidateStatus: line 4, column 19
Trigger.Event_To_Cand_Status: line 2, column 1
Just wondering out loud here, but does your insert fire off other triggers that cause existing records to be updated?
Jeff Douglas
Appirio, Inc.
http://blog.jeffdouglas.com
yes. i have a trigger that does a before insert or an update. When a event_type__c is a certain value, it updates a field in the candidate object. I kept getting soql governor limit errors so I was uploading 8 records at a time using the dataloader for the qualified profile value. As soon as I uploaded 8 records for the qualified resume value, i get this error:
BODY{font-family:monospace;}
Apex script unhandled trigger exception by user/organization: 00530000000cnEV/00D300000000KZt
Event_To_Cand_Status: execution of BeforeUpdate
caused by: System.Exception: Too many SOQL queries: 21
Class.Event_WorkFlow_Manager.UpdateCandidateStatus: line 4, column 19
Trigger.Event_To_Cand_Status: line 2, column 1
trigger Event_To_Cand_Status on Event (before update) {