+ Start a Discussion
alok29novalok29nov 

Trigger error while moving to production (urgent)

 

Hi All,

 

I have written a trigger and a test class for that. Test coverage for the trigger is 100% in sandbox. When I try to move it to Production, I get this error.(Please note it is a  bulkified trigger.).

 

TestBC_AverageAmountNew.ideaBatchTest()Class291Failure Message: "System.LimitException: Too many SOQL queries: 101", Failure Stack Trace: "Trigger.BookingQuota: line 29, column 1"

 

The above class "TestBC_AverageAmountNew" has been written for a batch class.

I am unable to understand how is the trigger related to above test class and how can I remove the error.

 

Any help would be greatly appreciated.

 

Thanks,

Alok

MikeyJamJamsMikeyJamJams

I've encountered the System.LimitException error before and we found out that with Salesforce you can only have 100 SOQL Queries across all your classes, and it looks like you've hit that limit.

alok29novalok29nov

My total number of classes are less than 100 in production , so does not seem to cause an error.

I am unable to understad a trigger which is working fine in sandbox having 100% test coverage is giving limit exception error when being moved to production and yes trigger is bulkified.

 

Apex experts, your help is needed. Please give me some pointers.

 

Thanks,

Alok