Timeline for Getting 101 SOQL error when updating bulk records through data loader
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 12, 2018 at 3:41 | comment | added | Ronnie | Are there triggers on Scratch Sheet that may be executing queries as well in certain cases that may be adding to these 5 queries you have here? i would also look into the Scratch sheet trigger if that is the case and check if that is running logic before and after that may be affecting your limits in some but not all cases. | |
| Oct 29, 2016 at 15:39 | comment | added | crmprogdev | @KSL I don't know if this trigger only runs when you do your data loads. If it runs at other times, it's possible that your issue could be caused by one or several of your users doing work that calls your trigger while you're running your batch data load job. That would explain why it happens at unpredictable times. | |
| Oct 29, 2016 at 10:07 | answer | added | Keith C | timeline score: 1 | |
| Oct 29, 2016 at 9:56 | comment | added | Keith C | While there doesn't look like anything that would cause the 101 SOQL error, you are matching records using doubly nested loops which might cause a CPU limit exception. I'll post an answer about that. | |
| Oct 29, 2016 at 9:54 | comment | added | KSL | Thanks Keith.. Can you confirm me that I have done no mistake please :)... It is only for my understanding to know If I have code properly or not | |
| Oct 29, 2016 at 9:52 | comment | added | Keith C | Suggest you get your senior team to point to exactly what they think is wrong. | |
| Oct 29, 2016 at 9:48 | comment | added | KSL | Yeah. I checked other triggers and I was told by my senior team that I am not handling the bulk logic. I don't know what I am doing wrong. I have done everything here. Also, I am getting SOQL issue only sometimes like, when I run batch of 200 for 10 times continuously, I am getting issue at 7th or 8th time and I am reducing the batch size to 80 and running the update. As you know I have 50 k records, I don't think its best practice to sit do it manually all the time. any changes I can do or any mistakes I have done here ? | |
| Oct 29, 2016 at 9:44 | comment | added | Keith C | This trigger looks OK to me. Have you checked for other triggers or declarative logic that might have the problem? | |
| Oct 29, 2016 at 9:36 | history | edited | Keith C | CC BY-SA 3.0 |
Format
|
| Oct 29, 2016 at 7:31 | history | asked | KSL | CC BY-SA 3.0 |