function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Gaby FrydmanGaby Frydman 

Trigger creates extra records in Production than in Sandbox

Ok, so in sandbox, I have a trigger on an object called Exam - so if an exam is updated to "Fail" then I want to create a new examination record that replicates the original one but also marks it as a resit. 

My trigger works fine in Sandbox  but in Production I get 2 extra records instead of 1 extra record. 

I dont have any other triggers on the same objects and the Debug console isnt very helpful either. 

Any idea how to troubleshoot?
Gaby FrydmanGaby Frydman
There is the debug :
34.0 APEX_CODE,DEBUG;APEX_PROFILING,INFO;CALLOUT,INFO;DB,INFO;SYSTEM,DEBUG;VALIDATION,INFO;VISUALFORCE,INFO;WORKFLOW,INFO
12:22:27.068 (68650480)|EXECUTION_STARTED
12:22:27.068 (68675989)|CODE_UNIT_STARTED|[EXTERNAL]|TRIGGERS
12:22:27.068 (68706078)|CODE_UNIT_STARTED|[EXTERNAL]|01q24000000hyFI|FailedGrade on Exam_Grade trigger event BeforeUpdate for [a4H24000000H1x7]
12:22:27.069 (69784594)|SYSTEM_CONSTRUCTOR_ENTRY|[5]|<init>()
12:22:27.069 (69827336)|SYSTEM_CONSTRUCTOR_EXIT|[5]|<init>()
12:22:27.069 (69942068)|SYSTEM_METHOD_ENTRY|[7]|List<Exam_Grade__c>.size()
12:22:27.069 (69991939)|SYSTEM_METHOD_EXIT|[7]|List<Exam_Grade__c>.size()
12:22:27.070 (70023746)|SYSTEM_METHOD_ENTRY|[8]|List<Exam_Grade__c>.get(Integer)
12:22:27.070 (70080090)|SYSTEM_METHOD_EXIT|[8]|List<Exam_Grade__c>.get(Integer)
12:22:27.070 (70666206)|SYSTEM_METHOD_ENTRY|[21]|List<Exam_Grade__c>.add(Object)
12:22:27.070 (70700179)|SYSTEM_METHOD_EXIT|[21]|List<Exam_Grade__c>.add(Object)
12:22:27.070 (70719553)|SYSTEM_METHOD_ENTRY|[7]|List<Exam_Grade__c>.size()
12:22:27.070 (70726692)|SYSTEM_METHOD_EXIT|[7]|List<Exam_Grade__c>.size()
12:22:27.070 (70734666)|SYSTEM_METHOD_ENTRY|[26]|List<Exam_Grade__c>.size()
12:22:27.070 (70754486)|SYSTEM_METHOD_EXIT|[26]|List<Exam_Grade__c>.size()
12:22:27.070 (70809090)|DML_BEGIN|[28]|Op:Insert|Type:Exam_Grade__c|Rows:1
12:22:27.124 (124521673)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:01I240000013TSY
12:22:27.140 (140519408)|WF_RULE_EVAL_BEGIN|Workflow
12:22:27.140 (140553643)|WF_CRITERIA_BEGIN|[Exam Grade: 2015-07-13-4782 a4H24000000H1xK]|Date Exam Taken|01Q24000000YXPi|ON_CREATE_OR_TRIGGERING_UPDATE|0
12:22:27.147 (147190103)|WF_RULE_FILTER|[Exam Grade : Status not equal to ] AND
 [Exam Grade : Date Taken equals ]
12:22:27.147 (147242255)|WF_RULE_EVAL_VALUE|
12:22:27.147 (147255047)|WF_CRITERIA_END|false
12:22:27.147 (147274448)|WF_SPOOL_ACTION_BEGIN|Workflow
12:22:27.147 (147282286)|WF_ACTION| None
12:22:27.147 (147286411)|WF_RULE_EVAL_END
12:22:27.147 (147329254)|WF_ACTIONS_END| None
12:22:27.147 (147336085)|CODE_UNIT_FINISHED|Workflow:01I240000013TSY
12:22:27.199 (199722544)|ENTERING_MANAGED_PKG|SFSSDupeCatcher
12:22:27.261 (261664714)|SOQL_EXECUTE_BEGIN|[159]|Aggregations:0|SELECT Id, Name, SFSSDupeCatcher__Match_On_Insert_Action__c, SFSSDupeCatcher__Match_On_Update_Action__c, SFSSDupeCatcher__Create_Tasks_for_Warnings__c, SFSSDupeCatcher__Blocked_Duplicates__c, SFSSDupeCatcher__Merged_Duplicates__c, SFSSDupeCatcher__Converted_Duplicates__c, SFSSDupeCatcher__Error_Message__c, SFSSDupeCatcher__Scenario_Type__c, SFSSDupeCatcher__Deployed__c, SFSSDupeCatcher__Bypass_Security__c, SFSSDupeCatcher__Person_Account_Filter__c, OwnerID, CreatedById FROM Scenario__c WHERE (Deployed__c = TRUE AND Match_On_Update_Action__c != 'Report Duplicate') LIMIT 100
12:22:27.269 (269448120)|SOQL_EXECUTE_END|[159]|Rows:0
12:22:27.273 (273428223)|ENTERING_MANAGED_PKG|enlighten
12:22:27.293 (293763438)|SOQL_EXECUTE_BEGIN|[162]|Aggregations:0|SELECT Id, enlighten__MoodleID__c FROM enlighten__Role__c WHERE enlighten__Short_Name__c = :tmpVar1
12:22:27.296 (296100959)|SOQL_EXECUTE_END|[162]|Rows:1
12:22:27.300 (300865963)|ENTERING_MANAGED_PKG|ts2
12:22:27.334 (334467532)|SOQL_EXECUTE_BEGIN|[436]|Aggregations:0|SELECT Id FROM RecordType WHERE (SobjectType = :tmpVar1 AND DeveloperName = :tmpVar2 AND NamespacePrefix = :tmpVar3 AND IsActive = TRUE)
12:22:27.341 (341749021)|SOQL_EXECUTE_END|[436]|Rows:1
12:22:27.346 (346110876)|CODE_UNIT_STARTED|[EXTERNAL]|01q24000000KmGH|UpdateAccountTrigger on Contact trigger event BeforeUpdate for [003240000069sI6]
12:22:27.346 (346332872)|SYSTEM_METHOD_ENTRY|[3]|List<Contact>.size()
12:22:27.346 (346362512)|SYSTEM_METHOD_EXIT|[3]|List<Contact>.size()
12:22:27.346 (346385875)|SYSTEM_METHOD_ENTRY|[4]|List<Contact>.get(Integer)
12:22:27.346 (346418922)|SYSTEM_METHOD_EXIT|[4]|List<Contact>.get(Integer)
12:22:27.346 (346948980)|SYSTEM_METHOD_ENTRY|[6]|List<Contact>.get(Integer)
12:22:27.346 (346986184)|SYSTEM_METHOD_EXIT|[6]|List<Contact>.get(Integer)
12:22:27.347 (347021163)|SYSTEM_METHOD_ENTRY|[6]|List<Contact>.get(Integer)
12:22:27.347 (347034311)|SYSTEM_METHOD_EXIT|[6]|List<Contact>.get(Integer)
12:22:27.347 (347078207)|SYSTEM_METHOD_ENTRY|[6]|String.equals(Object)
12:22:27.347 (347093339)|SYSTEM_METHOD_EXIT|[6]|String.equals(Object)
12:22:27.347 (347116036)|SYSTEM_METHOD_ENTRY|[19]|List<Contact>.get(Integer)
12:22:27.347 (347147990)|SYSTEM_METHOD_EXIT|[19]|List<Contact>.get(Integer)
12:22:27.347 (347200368)|SYSTEM_METHOD_ENTRY|[19]|List<Contact>.get(Integer)
12:22:27.347 (347212813)|SYSTEM_METHOD_EXIT|[19]|List<Contact>.get(Integer)
12:22:27.347 (347247311)|SYSTEM_METHOD_ENTRY|[3]|List<Contact>.size()
12:22:27.347 (347255105)|SYSTEM_METHOD_EXIT|[3]|List<Contact>.size()
12:22:27.347 (347276578)|CUMULATIVE_LIMIT_USAGE
12:22:27.347 (347276578)|LIMIT_USAGE_FOR_NS|(default)|


Second record

12:22:27.690 (690835619)|CUMULATIVE_LIMIT_USAGE_END

12:22:27.691 (691018707)|CODE_UNIT_FINISHED|FailedGrade on Exam_Grade trigger event BeforeUpdate for [a4H24000000H1x7]
12:22:27.706 (706688322)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:01I240000013TSY
12:22:27.715 (715570853)|WF_RULE_EVAL_BEGIN|Workflow
12:22:27.715 (715593336)|WF_CRITERIA_BEGIN|[Exam Grade: 2015-07-13-4773 a4H24000000H1x7]|Date Exam Taken|01Q24000000YXPi|ON_CREATE_OR_TRIGGERING_UPDATE|0
12:22:27.715 (715680987)|WF_RULE_FILTER|[Exam Grade : Status not equal to ] AND
 [Exam Grade : Date Taken equals ]
12:22:27.715 (715703816)|WF_RULE_EVAL_VALUE|2
12:22:27.715 (715710672)|WF_RULE_EVAL_VALUE|
12:22:27.715 (715714970)|WF_CRITERIA_END|true
12:22:27.716 (716263164)|WF_SPOOL_ACTION_BEGIN|Workflow
12:22:27.716 (716463123)|WF_FIELD_UPDATE|[Exam Grade: 2015-07-13-4773 a4H24000000H1x7]|Field:Exam Grade: Date Taken|Value:Mon Jul 13 11:22:28 GMT 2015|Id=04Y24000000InRd|CurrentRule:Date Exam Taken (Id=01Q24000000YXPi)
12:22:27.716 (716487149)|WF_ACTION| Field Update: 1;
12:22:27.716 (716490868)|WF_RULE_EVAL_END
12:22:27.717 (717404488)|CODE_UNIT_STARTED|[EXTERNAL]|01q24000000hyFI|FailedGrade on Exam_Grade trigger event BeforeUpdate for [a4H24000000H1x7]
12:22:27.717 (717629428)|SYSTEM_CONSTRUCTOR_ENTRY|[5]|<init>()
12:22:27.717 (717647474)|SYSTEM_CONSTRUCTOR_EXIT|[5]|<init>()
12:22:27.717 (717691913)|SYSTEM_METHOD_ENTRY|[7]|List<Exam_Grade__c>.size()
12:22:27.717 (717703978)|SYSTEM_METHOD_EXIT|[7]|List<Exam_Grade__c>.size()
12:22:27.717 (717732740)|SYSTEM_METHOD_ENTRY|[8]|List<Exam_Grade__c>.get(Integer)
12:22:27.717 (717750622)|SYSTEM_METHOD_EXIT|[8]|List<Exam_Grade__c>.get(Integer)
12:22:27.718 (718064448)|SYSTEM_METHOD_ENTRY|[21]|List<Exam_Grade__c>.add(Object)
12:22:27.718 (718080874)|SYSTEM_METHOD_EXIT|[21]|List<Exam_Grade__c>.add(Object)
12:22:27.718 (718098756)|SYSTEM_METHOD_ENTRY|[7]|List<Exam_Grade__c>.size()
12:22:27.718 (718105700)|SYSTEM_METHOD_EXIT|[7]|List<Exam_Grade__c>.size()
12:22:27.718 (718113285)|SYSTEM_METHOD_ENTRY|[26]|List<Exam_Grade__c>.size()
12:22:27.718 (718118838)|SYSTEM_METHOD_EXIT|[26]|List<Exam_Grade__c>.size()
12:22:27.718 (718186352)|DML_BEGIN|[28]|Op:Insert|Type:Exam_Grade__c|Rows:1
12:22:27.744 (744868599)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:01I240000013TSY
12:22:27.753 (753660140)|WF_RULE_EVAL_BEGIN|Workflow
12:22:27.753 (753685103)|WF_CRITERIA_BEGIN|[Exam Grade: 2015-07-13-4783 a4H24000000H1xL]|Date Exam Taken|01Q24000000YXPi|ON_CREATE_OR_TRIGGERING_UPDATE|0
12:22:27.753 (753754217)|WF_RULE_FILTER|[Exam Grade : Status not equal to ] AND
 [Exam Grade : Date Taken equals ]
12:22:27.753 (753785692)|WF_RULE_EVAL_VALUE|
12:22:27.753 (753792066)|WF_CRITERIA_END|false
12:22:27.753 (753805009)|WF_SPOOL_ACTION_BEGIN|Workflow
12:22:27.753 (753810579)|WF_ACTION| None
12:22:27.753 (753813972)|WF_RULE_EVAL_END
12:22:27.753 (753866788)|WF_ACTIONS_END| None
12:22:27.753 (753875118)|CODE_UNIT_FINISHED|Workflow:01I240000013TSY
12:22:27.760 (760357614)|ENTERING_MANAGED_PKG|SFSSDupeCatcher
12:22:27.766 (766330743)|SOQL_EXECUTE_BEGIN|[159]|Aggregations:0|SELECT Id, Name, SFSSDupeCatcher__Match_On_Insert_Action__c, SFSSDupeCatcher__Match_On_Update_Action__c, SFSSDupeCatcher__Create_Tasks_for_Warnings__c, SFSSDupeCatcher__Blocked_Duplicates__c, SFSSDupeCatcher__Merged_Duplicates__c, SFSSDupeCatcher__Converted_Duplicates__c, SFSSDupeCatcher__Error_Message__c, SFSSDupeCatcher__Scenario_Type__c, SFSSDupeCatcher__Deployed__c, SFSSDupeCatcher__Bypass_Security__c, SFSSDupeCatcher__Person_Account_Filter__c, OwnerID, CreatedById FROM Scenario__c WHERE (Deployed__c = TRUE AND Match_On_Update_Action__c != 'Report Duplicate') LIMIT 100
12:22:27.769 (769866116)|SOQL_EXECUTE_END|[159]|Rows:0
12:22:27.770 (770809989)|ENTERING_MANAGED_PKG|enlighten
12:22:27.773 (773330438)|SOQL_EXECUTE_BEGIN|[162]|Aggregations:0|SELECT Id, enlighten__MoodleID__c FROM enlighten__Role__c WHERE enlighten__Short_Name__c = :tmpVar1
12:22:27.775 (775825703)|SOQL_EXECUTE_END|[162]|Rows:1
12:22:27.777 (777374840)|ENTERING_MANAGED_PKG|ts2
12:22:27.778 (778685002)|CODE_UNIT_STARTED|[EXTERNAL]|01q24000000KmGH|UpdateAccountTrigger on Contact trigger event BeforeUpdate for [003240000069sI6]
12:22:27.778 (778812360)|SYSTEM_METHOD_ENTRY|[3]|List<Contact>.size()
12:22:27.778 (778822495)|SYSTEM_METHOD_EXIT|[3]|List<Contact>.size()
12:22:27.778 (778845374)|SYSTEM_METHOD_ENTRY|[4]|List<Contact>.get(Integer)
12:22:27.778 (778858379)|SYSTEM_METHOD_EXIT|[4]|List<Contact>.get(Integer)
12:22:27.778 (778903768)|SYSTEM_METHOD_ENTRY|[6]|List<Contact>.get(Integer)
12:22:27.778 (778915965)|SYSTEM_METHOD_EXIT|[6]|List<Contact>.get(Integer)
12:22:27.778 (778951250)|SYSTEM_METHOD_ENTRY|[6]|List<Contact>.get(Integer)
12:22:27.778 (778969666)|SYSTEM_METHOD_EXIT|[6]|List<Contact>.get(Integer)
12:22:27.779 (779016414)|SYSTEM_METHOD_ENTRY|[6]|String.equals(Object)
12:22:27.779 (779032830)|SYSTEM_METHOD_EXIT|[6]|String.equals(Object)
12:22:27.779 (779053574)|SYSTEM_METHOD_ENTRY|[19]|List<Contact>.get(Integer)
12:22:27.779 (779065173)|SYSTEM_METHOD_EXIT|[19]|List<Contact>.get(Integer)
12:22:27.779 (779103019)|SYSTEM_METHOD_ENTRY|[19]|List<Contact>.get(Integer)
12:22:27.779 (779114250)|SYSTEM_METHOD_EXIT|[19]|List<Contact>.get(Integer)
12:22:27.779 (779147077)|SYSTEM_METHOD_ENTRY|[3]|List<Contact>.size()
12:22:27.779 (779154575)|SYSTEM_METHOD_EXIT|[3]|List<Contact>.size()
12:22:27.779 (779171381)|CUMULATIVE_LIMIT_USAGE
12:22:27.779 (779171381)|LIMIT_USAGE_FOR_NS|(default)|
Nilesh JayswalNilesh Jayswal
Please check if there is any process builder or flow is there on same object.