+ Start a Discussion
Tyler Tran 94Tyler Tran 94 

Number of SOQL queries (DEBUG LOG)

16:28:15.277 (277195369)|CUMULATIVE_LIMIT_USAGE_END

16:28:15.5 (278152743)|CODE_UNIT_FINISHED|OpportunityTrigger on Opportunity trigger event BeforeUpdate|__sfdc_trigger/OpportunityTrigger
16:28:15.5 (293024723)|CODE_UNIT_STARTED|[EXTERNAL]|Validation:Opportunity:006N000000DbzfW
16:28:15.5 (293046110)|VALIDATION_RULE|03dN0000000BgE1|If_Opportunity_has_Stage_C_B_A_L
16:28:15.5 (296860426)|VALIDATION_FORMULA|( $UserRole.Id = '00EN00000012VBV' ) && ( (TEXT( StageName ) = 'C') || (TEXT( StageName ) = 'B') || (TEXT( StageName ) = 'A') || (TEXT( StageName ) = 'L')) && ( ISCHANGED( StageName ) )|$UserRole.Id=00EN00000012LoK , StageName=D1
16:28:15.5 (296874467)|VALIDATION_PASS
16:28:15.5 (296882576)|CODE_UNIT_FINISHED|Validation:Opportunity:006N000000DbzfW
16:28:15.5 (342020011)|CODE_UNIT_STARTED|[EXTERNAL]|01qN000000079iI|OpportunityTrigger on Opportunity trigger event AfterUpdate|__sfdc_trigger/OpportunityTrigger
16:28:15.5 (342063723)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:8
16:28:15.5 (342093410)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:8
16:28:15.5 (342163301)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.5 (342174194)|VARIABLE_SCOPE_BEGIN|[1]|this|OpportunityTrigger|true|false
16:28:15.5 (342193997)|VARIABLE_ASSIGNMENT|[1]|this|{}|0x4619ca00
16:28:15.5 (342240536)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.5 (342248644)|VARIABLE_SCOPE_BEGIN|[1]|this|OpportunityTrigger|true|false
16:28:15.5 (342261490)|VARIABLE_ASSIGNMENT|[1]|this|{}|0x4619ca00
16:28:15.5 (342269621)|STATEMENT_EXECUTE|[1]
16:28:15.5 (342279056)|STATEMENT_EXECUTE|[3]
16:28:15.5 (342284372)|STATEMENT_EXECUTE|[27]
16:28:15.5 (342289475)|STATEMENT_EXECUTE|[28]
16:28:15.5 (342294200)|STATEMENT_EXECUTE|[43]
16:28:15.5 (342295883)|STATEMENT_EXECUTE|[45]
16:28:15.5 (342300297)|HEAP_ALLOCATE|[45]|Bytes:50
16:28:15.5 (342335590)|USER_DEBUG|[45]|DEBUG|After Update Trigger In OOOOOOOOOOOOOOOPPPPPPPPPPP
16:28:15.5 (342357006)|HEAP_ALLOCATE|[46]|Bytes:4
16:28:15.5 (342426146)|HEAP_ALLOCATE|[46]|Bytes:26
16:28:15.5 (342447121)|HEAP_ALLOCATE|[46]|Bytes:4
16:28:15.5 (342471423)|HEAP_ALLOCATE|[46]|Bytes:5
16:28:15.5 (342485676)|VARIABLE_SCOPE_BEGIN|[46]|oppId|String|false|false
16:28:15.5 (342498612)|VARIABLE_ASSIGNMENT|[46]|oppId|"006N000000DbzfWIAR"
16:28:15.5 (342504050)|STATEMENT_EXECUTE|[46]
16:28:15.5 (342505674)|STATEMENT_EXECUTE|[48]
16:28:15.5 (342508323)|HEAP_ALLOCATE|[48]|Bytes:23
16:28:15.5 (342642539)|HEAP_ALLOCATE|[48]|Bytes:12
16:28:15.5 (342656478)|HEAP_ALLOCATE|[48]|Bytes:35
16:28:15.5 (342665720)|USER_DEBUG|[48]|DEBUG|New Total Asset Value: 828542140.00
16:28:15.5 (342764069)|STATEMENT_EXECUTE|[49]
16:28:15.5 (342898392)|STATEMENT_EXECUTE|[54]
16:28:15.5 (342986674)|HEAP_ALLOCATE|[65]|Bytes:28
16:28:15.5 (343025315)|STATEMENT_EXECUTE|[65]
16:28:15.5 (343061658)|STATEMENT_EXECUTE|[70]
16:28:15.5 (343063707)|STATEMENT_EXECUTE|[72]
16:28:15.5 (372520460)|VARIABLE_SCOPE_BEGIN|[7]|OpportunityTriggerHandler.ACCEPTED_CUSTOMER_STATUS|String|false|true
16:28:15.5 (372549115)|HEAP_ALLOCATE|[72]|Bytes:61
16:28:15.5 (372559206)|HEAP_ALLOCATE|[72]|Bytes:65
16:28:15.5 (372564268)|HEAP_ALLOCATE|[72]|Bytes:32
16:28:15.5 (372578322)|VARIABLE_ASSIGNMENT|[72]|OpportunityTriggerHandler.ACCEPTED_CUSTOMER_STATUS|"Tentatively Accepted (12 more) ..."
16:28:15.5 (372622061)|METHOD_ENTRY|[5]|01pN0000001HFzg|OpportunityTriggerHandler.OpportunityTriggerHandler()
16:28:15.5 (372629677)|STATEMENT_EXECUTE|[5]
16:28:15.5 (372633730)|STATEMENT_EXECUTE|[5]
16:28:15.5 (372642792)|HEAP_ALLOCATE|[72]|Bytes:5
16:28:15.5 (372655320)|METHOD_EXIT|[5]|OpportunityTriggerHandler
16:28:15.5 (372679956)|METHOD_ENTRY|[72]|01pN0000001HFzg|OpportunityTriggerHandler.setTotalDevelopedPotentialAmount(List<Opportunity>)
16:28:15.5 (372722895)|VARIABLE_SCOPE_BEGIN|[101]|oppList|List<Opportunity>|true|false
16:28:15.5 (373942154)|VARIABLE_ASSIGNMENT|[101]|oppList|[{"Total_Disbursed_Amount__c":0,"LastModifiedDate":"2019-03-25T09:28:15.000Z","AccountId":"001N000001Q67oPIAR","HasOpportunityLineItem":false,"Total_Asset_Value__c":828542140.00,"ForecastCategory":"Pipeline","Status_of_Each_Stage__c":"First meeting","CloseDate":"2019-03-31T00:00:00.000Z","Referral_Person__c":"003N000001KOVAYIA5","Name":"PhuongThanh-PC800Mil","HasOpenActivity":false,"Budget_Confirmed__c":false,"CreatedById":"005N0000006UNsHIAW","Remaining_Disbursement_Amount__c":0,"Other_Support_Commitment_from_Supplier__c":"None","IsDeleted":false,"Applied__c":false,"Referral_Source__c":"a04N000000JztVgIAJ","ROI_Analysis_Completed__c":false,"Application_No__c":"3xx","CreatedDate":"2019-03-20T03:06:45.000Z","HasOverdueTask":false,"Discovery_Completed__c":false,"BSL_Service__c":"Finance Lease","Id":"006N000000DbzfWIAR","Collateral_Asset__c":"None","Department__c":"Business Dept","ForecastCategoryName":"Pipeline","Approved_Amount__c":0,"Branch_Name__c":"Tokyo Headquarters","Verified_by_Branch_Leadership__c":false,"IsClosed":false,"PartnerAccountId":"001N000001Ph4kWIAR","Currency__c":"VND","Contract_Ending_Selection__c":"Ownership Transfer","Offer_from_Competitor__c":false,"Approved_Date__c":"2019-03-25T00:00:00.000Z","OwnerId":"005N0000006UNsHIAW","Contracted_Amount__c":0,"IsWon":false,"BSL_Branch__c":"Hanoi","Approval_Authority__c":"Branch Director","Number_of_Activities__c":0,"StageName":"D1","Total_Expected_Potential_Contract_Amount__c":725000000.00,"Probability":45,"SystemModstamp":"2019-03-25T09:28:15.000Z","Expected_Potential_Contract_Amount__c":725000000.00,"IsPrivate":false,"LastModifiedById":"005N0000006UIiGIAW"}]|0x7f0e8583
16:28:15.5 (373981781)|HEAP_ALLOCATE|[103]|Bytes:5
16:28:15.5 (373990918)|STATEMENT_EXECUTE|[101]
16:28:15.5 (373992834)|STATEMENT_EXECUTE|[103]
16:28:15.5 (374004166)|HEAP_ALLOCATE|[103]|Bytes:4
16:28:15.5 (374073296)|VARIABLE_SCOPE_BEGIN|[103]|refIdList|List<String>|true|false
16:28:15.5 (374101310)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.5 (374112245)|VARIABLE_ASSIGNMENT|[103]|refIdList|[]|0x130037b
16:28:15.5 (374118445)|STATEMENT_EXECUTE|[105]
16:28:15.5 (374171496)|HEAP_ALLOCATE|[105]|Bytes:4
16:28:15.5 (374230744)|VARIABLE_SCOPE_BEGIN|[105]|updatedRefList|List<Referral__c>|true|false
16:28:15.5 (374242374)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.5 (374250361)|VARIABLE_ASSIGNMENT|[105]|updatedRefList|[]|0x64bb9d30
16:28:15.5 (374294131)|HEAP_ALLOCATE|[107]|Bytes:5
16:28:15.5 (374311973)|VARIABLE_SCOPE_BEGIN|[107]|o|Opportunity|true|false
16:28:15.5 (374665756)|VARIABLE_ASSIGNMENT|[107]|o|{"Total_Disbursed_Amount__c":0,"LastModifiedDate":"2019-03-25T09:28:15.000Z","AccountId":"001N000001Q67oPIAR","HasOpportunityLineItem":false,"Total_Asset_Value__c":828542140.00,"ForecastCategory":"Pipeline","Status_of_Each_Stage__c":"First meeting","CloseDate":"2019-03-31T00:00:00.000Z","Referral_Person__c":"003N000001KOVAYIA5","Name":"PhuongThanh-PC800Mil","HasOpenActivity":false,"Budget_Confirmed__c":false,"CreatedById":"005N0000006UNsHIAW","Remaining_Disbursement_Amount__c":0,"Other_Support_Commitment_from_Supplier__c":"None","IsDeleted":false,"Applied__c":false,"Referral_Source__c":"a04N000000JztVgIAJ","ROI_Analysis_Completed__c":false,"Application_No__c":"3xx","CreatedDate":"2019-03-20T03:06:45.000Z","HasOverdueTask":false,"Discovery_Completed__c":false,"BSL_Service__c":"Finance Lease","Id":"006N000000DbzfWIAR","Collateral_Asset__c":"None","Department__c":"Business Dept","ForecastCategoryName":"Pipeline","Approved_Amount__c":0,"Branch_Name__c":"Tokyo Headquarters","Verified_by_Branch_Leadership__c":false,"IsClosed":false,"PartnerAccountId":"001N000001Ph4kWIAR","Currency__c":"VND","Contract_Ending_Selection__c":"Ownership Transfer","Offer_from_Competitor__c":false,"Approved_Date__c":"2019-03-25T00:00:00.000Z","OwnerId":"005N0000006UNsHIAW","Contracted_Amount__c":0,"IsWon":false,"BSL_Branch__c":"Hanoi","Approval_Authority__c":"Branch Director","Number_of_Activities__c":0,"StageName":"D1","Total_Expected_Potential_Contract_Amount__c":725000000.00,"Probability":45,"SystemModstamp":"2019-03-25T09:28:15.000Z","Expected_Potential_Contract_Amount__c":725000000.00,"IsPrivate":false,"LastModifiedById":"005N0000006UIiGIAW"}|0x275e34d2
16:28:15.5 (374694444)|STATEMENT_EXECUTE|[107]
16:28:15.5 (374696703)|STATEMENT_EXECUTE|[108]
16:28:15.5 (374755903)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.5 (374774794)|HEAP_ALLOCATE|[107]|Bytes:5
16:28:15.5 (374792592)|VARIABLE_ASSIGNMENT|[107]|o|null|
16:28:15.5 (374798665)|STATEMENT_EXECUTE|[111]
16:28:15.5 (374802773)|HEAP_ALLOCATE|[111]|Bytes:84
16:28:15.5 (374819587)|HEAP_ALLOCATE|[111]|Bytes:4
16:28:15.5 (375108901)|SOQL_EXECUTE_BEGIN|[111]|Aggregations:0|SELECT Id, Total_Developed_Potential_Amount__c FROM Referral__c WHERE Id IN :tmpVar1
16:28:15.5 (381377100)|SOQL_EXECUTE_END|[111]|Rows:1
16:28:15.5 (381400103)|HEAP_ALLOCATE|[111]|Bytes:8
16:28:15.5 (381416432)|HEAP_ALLOCATE|[111]|Bytes:108
16:28:15.5 (381441092)|HEAP_ALLOCATE|[111]|Bytes:8
16:28:15.5 (381452836)|VARIABLE_SCOPE_BEGIN|[111]|refList|List<Referral__c>|true|false
16:28:15.5 (381477717)|VARIABLE_ASSIGNMENT|[111]|refList|[{"Id":"a04N000000JztVgIAJ","Total_Developed_Potential_Amount__c":5757000000}]|0x2f1665cd
16:28:15.5 (381485009)|STATEMENT_EXECUTE|[115]
16:28:15.5 (381489382)|HEAP_ALLOCATE|[115]|Bytes:128
16:28:15.5 (381501761)|HEAP_ALLOCATE|[115]|Bytes:4
16:28:15.5 (381696542)|SOQL_EXECUTE_BEGIN|[115]|Aggregations:0|SELECT Id, Total_Expected_Potential_Contract_Amount__c, Referral_Source__c FROM Opportunity WHERE Referral_Source__c IN :tmpVar1
16:28:15.5 (392060337)|SOQL_EXECUTE_END|[115]|Rows:4
16:28:15.5 (392085738)|HEAP_ALLOCATE|[115]|Bytes:20
16:28:15.5 (392108194)|HEAP_ALLOCATE|[115]|Bytes:533
16:28:15.5 (392140052)|HEAP_ALLOCATE|[115]|Bytes:20
16:28:15.5 (392169564)|VARIABLE_SCOPE_BEGIN|[115]|checkedOppList|List<Opportunity>|true|false
16:28:15.5 (392215102)|VARIABLE_ASSIGNMENT|[115]|checkedOppList|[{"Id":"006N000000DOf9bIAD","Total_Expected_Potential_Contract_Amount__c":2757000000,"Referral_Source__c":"a04N000000JztVgIAJ"},{"Id":"006N000000DOqR0IAL","Referral_Source__c":"a04N000000JztVgIAJ"},{"Id":"006N000000Daf0qIAB","Total_Expected_Potential_Contract_Amount__c":2400000000,"Referral_Source__c":"a04N000000JztVgIAJ"},{"Id":"006N000000DbzfWIAR","Total_Expected_Potential_Contract_Amount__c":725000000,"Referral_Source__c":"a04N000000JztVgIAJ"}]|0x485413f0
16:28:15.5 (392409418)|HEAP_ALLOCATE|[119]|Bytes:5
16:28:15.5 (392431475)|HEAP_ALLOCATE|[119]|Bytes:12
16:28:15.5 (392439889)|VARIABLE_SCOPE_BEGIN|[119]|r|Referral__c|true|false
16:28:15.5 (392459465)|VARIABLE_ASSIGNMENT|[119]|r|{"Id":"a04N000000JztVgIAJ","Total_Developed_Potential_Amount__c":5757000000}|0x77c87c1
16:28:15.5 (392466974)|STATEMENT_EXECUTE|[119]
16:28:15.5 (392469432)|STATEMENT_EXECUTE|[120]
16:28:15.5 (392513316)|HEAP_ALLOCATE|[120]|Bytes:18
16:28:15.5 (392520784)|VARIABLE_SCOPE_BEGIN|[120]|rId|String|false|false
16:28:15.5 (392532638)|VARIABLE_ASSIGNMENT|[120]|rId|"a04N000000JztVgIAJ"
16:28:15.5 (392536998)|STATEMENT_EXECUTE|[121]
16:28:15.5 (392554029)|HEAP_ALLOCATE|[121]|Bytes:28
16:28:15.5 (392559437)|HEAP_ALLOCATE|[121]|Bytes:28
16:28:15.5 (392563937)|VARIABLE_SCOPE_BEGIN|[121]|potentialInRef|Decimal|false|false
16:28:15.5 (392576164)|VARIABLE_ASSIGNMENT|[121]|potentialInRef|0
16:28:15.5 (392612705)|HEAP_ALLOCATE|[123]|Bytes:5
16:28:15.5 (392625193)|HEAP_ALLOCATE|[123]|Bytes:16
16:28:15.5 (392631542)|VARIABLE_SCOPE_BEGIN|[123]|o|Opportunity|true|false
16:28:15.5 (392653924)|VARIABLE_ASSIGNMENT|[123]|o|{"Id":"006N000000DOf9bIAD","Total_Expected_Potential_Contract_Amount__c":2757000000,"Referral_Source__c":"a04N000000JztVgIAJ"}|0x47200c75
16:28:15.5 (392661050)|STATEMENT_EXECUTE|[123]
16:28:15.5 (392718227)|STATEMENT_EXECUTE|[124]
16:28:15.5 (392720795)|STATEMENT_EXECUTE|[127]
16:28:15.5 (392723728)|VARIABLE_SCOPE_BEGIN|[127]|potentialInOpp|Decimal|false|false
16:28:15.5 (392734364)|VARIABLE_ASSIGNMENT|[127]|potentialInOpp|null
16:28:15.5 (392747496)|STATEMENT_EXECUTE|[131]
16:28:15.5 (392749112)|STATEMENT_EXECUTE|[132]
16:28:15.5 (392755462)|VARIABLE_ASSIGNMENT|[132]|potentialInOpp|2757000000
16:28:15.5 (392760898)|STATEMENT_EXECUTE|[135]
16:28:15.5 (392798165)|HEAP_ALLOCATE|[135]|Bytes:28
16:28:15.5 (392812550)|VARIABLE_ASSIGNMENT|[135]|potentialInRef|2757000000
16:28:15.5 (392823898)|HEAP_ALLOCATE|[123]|Bytes:5
16:28:15.5 (392834898)|HEAP_ALLOCATE|[123]|Bytes:12
16:28:15.5 (392840502)|VARIABLE_SCOPE_BEGIN|[123]|o|Opportunity|true|false
16:28:15.5 (392855102)|VARIABLE_ASSIGNMENT|[123]|o|{"Id":"006N000000DOqR0IAL","Referral_Source__c":"a04N000000JztVgIAJ"}|0x69a0b76d
16:28:15.5 (392860864)|STATEMENT_EXECUTE|[123]
16:28:15.5 (392878247)|STATEMENT_EXECUTE|[124]
16:28:15.5 (392880203)|STATEMENT_EXECUTE|[127]
16:28:15.5 (392882583)|VARIABLE_SCOPE_BEGIN|[127]|potentialInOpp|Decimal|false|false
16:28:15.5 (392892087)|VARIABLE_ASSIGNMENT|[127]|potentialInOpp|null
16:28:15.5 (392898084)|STATEMENT_EXECUTE|[129]
16:28:15.5 (392899705)|STATEMENT_EXECUTE|[130]
16:28:15.5 (392906982)|HEAP_ALLOCATE|[130]|Bytes:28
16:28:15.5 (392910963)|HEAP_ALLOCATE|[130]|Bytes:28
16:28:15.5 (392917519)|VARIABLE_ASSIGNMENT|[130]|potentialInOpp|0
16:28:15.5 (392922373)|STATEMENT_EXECUTE|[135]
16:28:15.5 (392934177)|HEAP_ALLOCATE|[135]|Bytes:28
16:28:15.5 (392945100)|VARIABLE_ASSIGNMENT|[135]|potentialInRef|2757000000
16:28:15.5 (392955531)|HEAP_ALLOCATE|[123]|Bytes:5
16:28:15.5 (392968019)|HEAP_ALLOCATE|[123]|Bytes:16
16:28:15.5 (392973731)|VARIABLE_SCOPE_BEGIN|[123]|o|Opportunity|true|false
16:28:15.5 (392989836)|VARIABLE_ASSIGNMENT|[123]|o|{"Id":"006N000000Daf0qIAB","Total_Expected_Potential_Contract_Amount__c":2400000000,"Referral_Source__c":"a04N000000JztVgIAJ"}|0x24cfeb16
16:28:15.5 (392996089)|STATEMENT_EXECUTE|[123]
16:28:15.5 (393011516)|STATEMENT_EXECUTE|[124]
16:28:15.5 (393014118)|STATEMENT_EXECUTE|[127]
16:28:15.5 (393016574)|VARIABLE_SCOPE_BEGIN|[127]|potentialInOpp|Decimal|false|false
16:28:15.5 (393025042)|VARIABLE_ASSIGNMENT|[127]|potentialInOpp|null
16:28:15.5 (393032599)|STATEMENT_EXECUTE|[131]
16:28:15.5 (393034126)|STATEMENT_EXECUTE|[132]
16:28:15.5 (393039412)|VARIABLE_ASSIGNMENT|[132]|potentialInOpp|2400000000
16:28:15.5 (393043880)|STATEMENT_EXECUTE|[135]
16:28:15.5 (393054496)|HEAP_ALLOCATE|[135]|Bytes:28
16:28:15.5 (393065391)|VARIABLE_ASSIGNMENT|[135]|potentialInRef|5157000000
16:28:15.5 (393074847)|HEAP_ALLOCATE|[123]|Bytes:5
16:28:15.5 (393083424)|HEAP_ALLOCATE|[123]|Bytes:16
16:28:15.5 (393088288)|VARIABLE_SCOPE_BEGIN|[123]|o|Opportunity|true|false
16:28:15.5 (393102976)|VARIABLE_ASSIGNMENT|[123]|o|{"Id":"006N000000DbzfWIAR","Total_Expected_Potential_Contract_Amount__c":725000000,"Referral_Source__c":"a04N000000JztVgIAJ"}|0x1b669541
16:28:15.5 (393108939)|STATEMENT_EXECUTE|[123]
16:28:15.5 (393123366)|STATEMENT_EXECUTE|[124]
16:28:15.5 (393125377)|STATEMENT_EXECUTE|[127]
16:28:15.5 (393127895)|VARIABLE_SCOPE_BEGIN|[127]|potentialInOpp|Decimal|false|false
16:28:15.5 (393136223)|VARIABLE_ASSIGNMENT|[127]|potentialInOpp|null
16:28:15.5 (393143215)|STATEMENT_EXECUTE|[131]
16:28:15.5 (393144843)|STATEMENT_EXECUTE|[132]
16:28:15.5 (393149845)|VARIABLE_ASSIGNMENT|[132]|potentialInOpp|725000000
16:28:15.5 (393153882)|STATEMENT_EXECUTE|[135]
16:28:15.5 (393164645)|HEAP_ALLOCATE|[135]|Bytes:28
16:28:15.5 (393175438)|VARIABLE_ASSIGNMENT|[135]|potentialInRef|5882000000
16:28:15.5 (393185648)|HEAP_ALLOCATE|[123]|Bytes:5
16:28:15.5 (393194273)|VARIABLE_ASSIGNMENT|[123]|o|null|
16:28:15.5 (393198899)|STATEMENT_EXECUTE|[139]
16:28:15.5 (393258434)|VARIABLE_ASSIGNMENT|[139]|this.Total_Developed_Potential_Amount__c|5882000000|0x77c87c1
16:28:15.5 (393265317)|STATEMENT_EXECUTE|[140]
16:28:15.5 (393295676)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.5 (393310384)|HEAP_ALLOCATE|[119]|Bytes:5
16:28:15.5 (393320668)|VARIABLE_ASSIGNMENT|[119]|r|null|
16:28:15.5 (393325755)|STATEMENT_EXECUTE|[143]
16:28:15.5 (393370937)|DML_BEGIN|[143]|Op:Update|Type:Referral__c|Rows:1
16:28:15.5 (393397395)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:8
16:28:15.5 (410759859)|CODE_UNIT_STARTED|[EXTERNAL]|DuplicateDetector
16:28:15.5 (410777621)|DUPLICATE_DETECTION_BEGIN
16:28:15.5 (410848028)|DUPLICATE_DETECTION_RULE_INVOCATION|DuplicateRuleId:0BmN0000000kZCl|DuplicateRuleName:BSL referral|DmlType:UPDATE
16:28:15.5 (425699291)|DUPLICATE_DETECTION_END
16:28:15.5 (425709093)|CODE_UNIT_FINISHED|DuplicateDetector
16:28:15.5 (446530187)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:01I6F000003TsCP
16:28:15.5 (456370634)|WF_RULE_EVAL_BEGIN|Workflow
16:28:15.5 (456397352)|WF_CRITERIA_BEGIN|[Referral: SMTPFC Tokyo Hoa Test a04N000000JztVg]|Update_Contact_Referral_Supply_Chain301N0000000Q6Ql|01QN0000000FqTP|ON_ALL_CHANGES|0
16:28:15.5 (456466584)|WF_FORMULA|Formula:ENCODED:[treatNullAsNull]true|Values:
16:28:15.5 (456474055)|WF_CRITERIA_END|true
16:28:15.5 (468052626)|WF_SPOOL_ACTION_BEGIN|Workflow
16:28:15.5 (468079163)|WF_ACTION| Flow Trigger: 1;
16:28:15.5 (468083583)|WF_RULE_EVAL_END
16:28:15.552 (552138684)|FLOW_CREATE_INTERVIEW_BEGIN|00DN0000000R3xN|300N00000004tLP|301N0000000Q6Ql
16:28:15.552 (572497654)|FLOW_CREATE_INTERVIEW_END|4086fafcb4ceb8ab634678e1964e169b41efc78-5666|Update Contact Referral - Supply Chain
16:28:15.5 (572546557)|WF_FLOW_ACTION_BEGIN|09LN000000014s9
16:28:15.574 (574215736)|FLOW_START_INTERVIEWS_BEGIN|1
16:28:15.574 (574261808)|FLOW_START_INTERVIEW_BEGIN|4086fafcb4ceb8ab634678e1964e169b41efc78-5666|Update Contact Referral - Supply Chain
16:28:15.574 (576369393)|FLOW_START_INTERVIEW_END|4086fafcb4ceb8ab634678e1964e169b41efc78-5666|Update Contact Referral - Supply Chain
16:28:15.574 (576388241)|FLOW_START_INTERVIEWS_END|1
16:28:15.5 (577815451)|WF_FLOW_ACTION_END|09LN000000014s9
16:28:15.5 (577910178)|WF_ACTIONS_END| Flow Trigger: 1;
16:28:15.5 (577922652)|CODE_UNIT_FINISHED|Workflow:01I6F000003TsCP
16:28:15.5 (616450031)|DML_END|[143]
16:28:15.5 (616514016)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:8
16:28:15.5 (616543459)|METHOD_EXIT|[72]|01pN0000001HFzg|OpportunityTriggerHandler.setTotalDevelopedPotentialAmount(List<Opportunity>)
16:28:15.5 (616838863)|STATEMENT_EXECUTE|[76]
16:28:15.5 (616974612)|STATEMENT_EXECUTE|[87]
16:28:15.5 (617094465)|STATEMENT_EXECUTE|[98]
16:28:15.5 (617112090)|HEAP_ALLOCATE|[46]|Bytes:5
16:28:15.5 (617130156)|VARIABLE_ASSIGNMENT|[46]|oppId|null
16:28:15.5 (617140485)|STATEMENT_EXECUTE|[112]
16:28:15.617 (617146671)|CUMULATIVE_LIMIT_USAGE
16:28:15.617 (617146671)|LIMIT_USAGE_FOR_NS|(default)|
  Number of SOQL queries: 6 out of 100
  Number of query rows: 8 out of 50000
  Number of SOSL queries: 0 out of 20
  Number of DML statements: 2 out of 150
  Number of DML rows: 2 out of 10000
  Maximum CPU time: 16 out of 10000
  Maximum heap size: 0 out of 6000000
  Number of callouts: 0 out of 100
  Number of Email Invocations: 0 out of 10
  Number of future calls: 0 out of 50
  Number of queueable jobs added to the queue: 0 out of 50
  Number of Mobile Apex push calls: 0 out of 10

16:28:15.617 (617146671)|CUMULATIVE_LIMIT_USAGE_END

16:28:15.5 (618239286)|CODE_UNIT_FINISHED|OpportunityTrigger on Opportunity trigger event AfterUpdate|__sfdc_trigger/OpportunityTrigger
16:28:15.5 (619633710)|CODE_UNIT_STARTED|[EXTERNAL]|Workflow:Opportunity
16:28:15.5 (633377042)|WF_RULE_EVAL_BEGIN|Workflow
16:28:15.5 (633418838)|WF_CRITERIA_BEGIN|[Opportunity: PhuongThanh-PC800Mil 006N000000DbzfW]|Referral_Branch_Name_from_Contact_to_Opportunity301N0000000Q7Bc|01QN0000000Fqst|ON_ALL_CHANGES|0
16:28:15.5 (633531233)|WF_FORMULA|Formula:ENCODED:[treatNullAsNull]true|Values:
16:28:15.5 (633538391)|WF_CRITERIA_END|true
16:28:15.5 (642861078)|WF_CRITERIA_BEGIN|[Opportunity: PhuongThanh-PC800Mil 006N000000DbzfW]|Create_Task_when_Opportunity_Status_change_to_C301N0000000Q3Cq|01QN0000000Fozn|ON_ALL_CHANGES|0
16:28:15.5 (642956420)|WF_FORMULA|Formula:ENCODED:[treatNullAsNull]true|Values:
16:28:15.5 (642963354)|WF_CRITERIA_END|true
16:28:15.5 (642984904)|WF_CRITERIA_BEGIN|[Opportunity: PhuongThanh-PC800Mil 006N000000DbzfW]|Update_Branch_Value301N0000000Q1pl|01QN0000000Focj|ON_ALL_CHANGES|0
16:28:15.5 (643013064)|WF_FORMULA|Formula:ENCODED:[treatNullAsNull]true|Values:
16:28:15.5 (643018699)|WF_CRITERIA_END|true
16:28:15.5 (643037740)|WF_SPOOL_ACTION_BEGIN|Workflow
16:28:15.5 (643061052)|WF_ACTION| Flow Trigger: 3;
16:28:15.5 (643065604)|WF_RULE_EVAL_END
16:28:15.747 (747894021)|FLOW_CREATE_INTERVIEW_BEGIN|00DN0000000R3xN|300N0000000DGl5|301N0000000Q1pl
16:28:15.747 (771817223)|FLOW_CREATE_INTERVIEW_END|4087fafcb4ceb8ab634678e1964e169b41efc78-5665|Update Branch Value
16:28:15.5 (771863906)|WF_FLOW_ACTION_BEGIN|09LN000000013jG
16:28:15.773 (773227758)|FLOW_START_INTERVIEWS_BEGIN|1
16:28:15.773 (773270805)|FLOW_START_INTERVIEW_BEGIN|4087fafcb4ceb8ab634678e1964e169b41efc78-5665|Update Branch Value
16:28:15.773 (781683390)|FLOW_START_INTERVIEW_END|4087fafcb4ceb8ab634678e1964e169b41efc78-5665|Update Branch Value
16:28:15.889 (889266750)|CODE_UNIT_STARTED|[EXTERNAL]|01qN000000079iI|OpportunityTrigger on Opportunity trigger event BeforeUpdate|__sfdc_trigger/OpportunityTrigger
16:28:15.889 (889329065)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:8
16:28:15.889 (889357413)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:8
16:28:15.889 (889401460)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.889 (889410767)|VARIABLE_SCOPE_BEGIN|[1]|this|OpportunityTrigger|true|false
16:28:15.889 (889434576)|VARIABLE_ASSIGNMENT|[1]|this|{}|0x5456c94a
16:28:15.889 (889477551)|HEAP_ALLOCATE|[EXTERNAL]|Bytes:4
16:28:15.889 (889485355)|VARIABLE_SCOPE_BEGIN|[1]|this|OpportunityTrigger|true|false
16:28:15.889 (889497530)|VARIABLE_ASSIGNMENT|[1]|this|{}|0x5456c94a
16:28:15.889 (889504828)|STATEMENT_EXECUTE|[1]
16:28:15.889 (889515001)|STATEMENT_EXECUTE|[3]
16:28:15.889 (889520476)|STATEMENT_EXECUTE|[27]
16:28:15.889 (889524702)|STATEMENT_EXECUTE|[28]
16:28:15.889 (889544710)|HEAP_ALLOCATE|[29]|Bytes:4
16:28:15.889 (889614678)|HEAP_ALLOCATE|[29]|Bytes:26
16:28:15.889 (889635473)|HEAP_ALLOCATE|[29]|Bytes:4
16:28:15.889 (889658719)|HEAP_ALLOCATE|[29]|Bytes:5
16:28:15.889 (889672938)|VARIABLE_SCOPE_BEGIN|[29]|oppId|String|false|false
16:28:15.889 (889686228)|VARIABLE_ASSIGNMENT|[29]|oppId|"006N000000DbzfWIAR"
16:28:15.889 (889691631)|STATEMENT_EXECUTE|[29]
16:28:15.889 (889816958)|STATEMENT_EXECUTE|[30]
16:28:15.889 (890013380)|STATEMENT_EXECUTE|[35]
16:28:15.889 (890024762)|HEAP_ALLOCATE|[29]|Bytes:5
16:28:15.889 (890038749)|VARIABLE_ASSIGNMENT|[29]|oppId|null
16:28:15.889 (890049514)|STATEMENT_EXECUTE|[43]
16:28:15.889 (890054451)|STATEMENT_EXECUTE|[112]
16:28:15.890 (890059584)|CUMULATIVE_LIMIT_USAGE
16:28:15.890 (890059584)|LIMIT_USAGE_FOR_NS|(default)|
  Number of SOQL queries: 7 out of 100
  Number of query rows: 9 out of 50000
  Number of SOSL queries: 0 out of 20
  Number of DML statements: 3 out of 150
  Number of DML rows: 3 out of 10000
  Maximum CPU time: 16 out of 10000
  Maximum heap size: 0 out of 6000000
  Number of callouts: 0 out of 100
  Number of Email Invocations: 0 out of 10
  Number of future calls: 0 out of 50
  Number of queueable jobs added to the queue: 0 out of 50
  Number of Mobile Apex push calls: 0 out of 10
I have a debug log file above! Can you explain for me why the Number of SOQL queries increase from 6 to 7, even it doesn't have any SOQL queries at second process (|CODE_UNIT_FINISHED|OpportunityTrigger on Opportunity trigger event AfterUpdate|__sfdc_trigger/OpportunityTrigger)
Thanks for your help!
Raj VakatiRaj Vakati
Salesforce will calculate this on entire transaction basic from beginning to end of one complete transaction.
  • Check you have any other triggers 
  • Check you are using any SOQL inside for loops 
  • Check you have any flow or process 
Tyler Tran 94Tyler Tran 94
Thank you Raj, I will check it later