Trigger deployment to production shows "maximum trigger depth exceeded" error

Question

I am deploying a trigger from a sandbox to a production org. During validation it gives me "maximum trigger depth exceeded" error for some other trigger which is not part of the change set. The error points out to a line number containing insert and says CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY.

enter image description here

enter image description here When I run individual tests for that trigger in sandbox and production, they pass out with flying colors. I do not see any workflow or field update in production related to that trigger custom object which may cause this.

I dont know where I should start looking. Am I missing something here?

score 3 · Answer 1 · edited Apr 13 '17 at 12:54

3

This looks like a Recursive Trigger issue. Usually when you have maximum trigger depth exception this means that a trigger is getting recursively fired. You can only have something recursively fire 16 times (Max Stack Depth).

This can happen if you have triggers that fire DML updates that fire triggers that in turn update the original record, triggering a recursive loop that doesn't stop.

A Unit Test may pass but its possible if you use SeeAllData or some other test permuatation it could trigger this on some occassions and not others.

First make sure you are preventing recursive triggers. It's a best practice also. :)

I presented on Dreamforce on this exact issue in 2013. Here is the video. Go to minute 14 where I talk about Maximum Depth Trigger and how to prevent recursion. https://www.youtube.com/watch?v=rCDSZ8_UpVs#t=848

Take a look at this post also: How do I control recursive Triggers with static variables and permit Mass Edit from List View

edited Apr 13 '17 at 12:54

Community

1

answered Nov 13 '14 at 00:58

CoryCowgill

2,203
1
17
20

I wonder why this limit is never documented – Patlatus Oct 09 '15 at 16:04
1

This is documented here: https://developer.salesforce.com/docs/atlas.en-us.salesforce_app_limits_cheatsheet.meta/salesforce_app_limits_cheatsheet/salesforce_app_limits_platform_apexgov.htm . -> Please look at this line item: "Total stack depth for any Apex invocation that recursively fires triggers due to insert, update, or delete statements 16" – CoryCowgill Oct 12 '15 at 15:09
You are right. I was wrong – Patlatus Oct 13 '15 at 14:00
There is a similar limit of 32 (how many parameters can method have) which is not documented, looks like I confused these two – Patlatus Oct 13 '15 at 16:52
No worries. There are plenty of things that are undocumented. :) – CoryCowgill Oct 13 '15 at 16:59

Trigger deployment to production shows "maximum trigger depth exceeded" error

1 Answers1