Timeline for Batch Apex: Too many SOQL queries: 201
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 10, 2019 at 14:27 | vote | accept | AB5 | ||
| May 10, 2019 at 13:42 | comment | added | AB5 | I didn't put anything for the batch size. Setting the batch size to 1 solved the issue thanks. | |
| May 10, 2019 at 9:28 | answer | added | summer | timeline score: 2 | |
| May 10, 2019 at 9:16 | comment | added | Vijay Ganji | Do you have any triggers/PB/Flows on Opportunity ? | |
| May 10, 2019 at 9:01 | comment | added | Manish Anand | What is the batch size you are using? If it is greater than 200, then query on DatedConversionRate in the execute method is running that number of time. Each execution of the 'execute' method is a single transaction which means in a single transaction you are trying to execute more than 200 SOQL query , hence the above governor limit error. Try to reduce the batch size and check the result. You can try with the batch size of 1 | |
| May 10, 2019 at 8:50 | review | First posts | |||
| May 10, 2019 at 9:15 | |||||
| May 10, 2019 at 8:48 | history | asked | AB5 | CC BY-SA 4.0 |