Salesforce Developer Community

Tyler Tran 94
NEWBIE
20 Points
Member since 2018
Developer

Chatter

Feed
0

Best Answers
0

Likes Received
1

Likes Given
6

Questions
8

Replies

Generate and download PDF file from Base64 Encode String

Hello everyone! I want to create a LWC to download a simple PDF file with a random string. Here is my code:
Apex class:

public with sharing class PdfLwcController {
    @AuraEnabled
    public static String getBase64String() {
        String s = 'Hello World!';
        
        return EncodingUtil.base64Encode(Blob.toPdf(s));
    }
}

Client-side controller:

import { LightningElement } from 'lwc';
import getBase64String from '@salesforce/apex/PdfLwcController.getBase64String';

export default class PdfButton extends LightningElement {
    handleClick() {
        getBase64String({})
            .then(response =>{
                // I don't know how to generate and download pdf file.
            })
    }
}

HTML:

<template>
    <lightning-card title="Downloading Pdf Demo">
        <lightning-button label="Neutral" title="Non-primary action" onclick={handleClick} class="slds-m-left_x-small"></lightning-button>
    </lightning-card>
</template>

The Server-side controller can return a Base64 String, but I don't know how to generate the PDF file and download it immediately (don't save it to the attachment or file). Do you have any idea?
Thank you so much.

Tyler Tran 94
June 30, 2022
Like
0

4 replies

Cannot read properties of undefined in LWC

Hi everyone! I have to get the response from an API Endpoint and display them in a data table (LWC). The response look like this:

"list": [
        {
            "projectName": "Onnami",
            "point": {
                "min": 9.11,
                "max": 9.18,
                "default": 9.11
            }
        },
        {
            "projectName": "Sunshine INC",
            "point": {
                "min": 9.11,
                "default": 9.11
            }
        }
]

I got no problem when getting the "projectName", but when I try to get the "default" key in "point". I get the error: Uncaught (in promise) TypeError: LWC component's @wire target property or method threw an error during value provisioning. Original error:
[Cannot read properties of undefined (reading 'default')].
Here is my client side controller:

import { LightningElement, api, wire } from 'lwc';
import getSubmissionRecords from '@salesforce/apex/SubmissionController.getSubmissionRecords';

const columns = [
    { label: 'Project Name', fieldName: 'projectName' },
    { label: 'Points', fieldName: 'point', type: 'number' },
    { 
        label: '', 
        fieldName: 'details', 
        type: 'url',  
        typeAttributes: {
            label: { 
                fieldName: 'detailName' 
            },
            target : '_blank'
        }},
];

export default class PricingTab extends LightningElement {
    @api recordId;
    @api columnData;

    @wire(getSubmissionRecords, { projectId: '$recordId' })
    returnedSubmissions({data, error}) {
        if(data) {
            let dataRefer = [];
            
            data.forEach((record) => {
                let preparedData = {};

                preparedData.projectName = record.projectName;
                preparedData.point = record.point.default;
                preparedData.detailName = 'Details';
                preparedData.details = 'https://google.com';

                dataRefer.push(preparedData);
            })

            this.columnData = dataRefer;
        }

        if(error) {
            console.log(error)
        }
    }
}

Here is the HTML file:

<template>
    <lightning-datatable key-field="Id" data={columnData} columns={columns}></lightning-datatable>
</template>

The response returns about over 500 records.
Thank you so much!

Tyler Tran 94
June 13, 2022
Like
0

3 replies

Can't login to iframe URL in Visualforce Page

I want to log in to the URL Iframe in a visualforce page, but it can't be done. When I check in Network tab in Developer console, it looks like Salesforce system tries to block the logging-in process. Here is my Iframe link and javascript tag.

<div style="float: left; width: 100%"> <apex:outputPanel layout="block" style="overflow:hidden"> <apex:iframe height="500px" width="100%" id="loginFrame"/> </apex:outputPanel> </div> <script type="text/javascript"> window.onload = function() { setTimeout(function() { var frame = document.getElementById('loginFrame'); if(frame) { frame.src = "https://dev-mk.eaga.com/prices/app/{!oppId}"; } }, 500); } </script>

What can I do to fix this problem?

Tyler Tran 94
May 30, 2022
Like
0

SOLVED

2 replies

getObjectInfos is not working

I have a basic coding about getObjectInfos adapter but it seems not working:

import { LightningElement, wire } from 'lwc';
import { getObjectInfos } from 'lightning/uiObjectInfoApi';
import ACCOUNT_OBJECT from '@salesforce/schema/Account';
import OPPORTUNITY_OBJECT from '@salesforce/schema/Opportunity';


export default class GetObjectInfosLwc extends LightningElement {
    @wire(getObjectInfos, {objectApiName:[ACCOUNT_OBJECT, OPPORTUNITY_OBJECT]})
    objectInfosHandler({data, error}) {
        if(data) {
            console.log("Get Multiple " + data)
        }
        if(error) {
            console.error(error)
        }
    }
}

and here is the Browser Console log:

beaconLib.BeaconLibrary.js:37 {InstrumentationResult :  ( RECEIVED = 14 , SUCCESS -> LOG = 14 , Topic = AILTN )  , TracingResponse : ( AsyncResults ) , TelemetryResponse : ( AsyncResults ): {…}}

As you can see, it doesn't print the list of metadata (for Account and Opportunity). I need some help!
Thank you so much.

Tyler Tran 94
June 21, 2021
Like
0

SOLVED

2 replies

LWC - Variable is not defined

Can someone help me with this problem? When I load the component tab then it shows 2 errors: isVpbank is not defined and isHsbcBank is not defined

creditCard.html

<template>
    <template if:true={isVpbank}>
        <img class="image-card" src={vpbankImage}/>
    </template>

    <template if:true={isHsbcBank}>
        <img class="image-card" src={hsbcImage}/>
    </template>
    
    
    <div class="slds-m-around_medium">
        <template if:true={creditCard.data}>
            <template for:each={creditCard.data} for:item="cc">
                <p key={cc.Id}>{cc.Name}</p>
            </template>
        </template>
    </div>

</template>

creditCard.js

import { LightningElement, api, wire } from 'lwc';

import myResource from '@salesforce/resourceUrl/creditCard';
import getCreditCard from '@salesforce/apex/CreditCardController.getCreditCard';
import isVpBankCredit from '@salesforce/apex/CreditCardController.isVpBankCredit';
import isHsbcCredit from '@salesforce/apex/CreditCardController.isHsbcCredit';


const VP_BANK = myResource + '/credit-card-images/vp-bank.jpg';
const HSBC = myResource + '/credit-card-images/hsbc.jpg';

export default class CreditCard extends LightningElement {
    vpbankImage = VP_BANK;
    hsbcImage = HSBC;
    isVpbank = false;
    isHsbcBank = false;
    
    @wire(getCreditCard) creditCard;

    connectedCallback() {
        isVpBankCredit().then((result) => {
            this.isVpbank = result;
            console.log(isVpbank);
        });

        isHsbcCredit().then((result) => {
            this.isHsbcBank = result;
            console.log(isHsbcBank);
        });
    }
}

Tyler Tran 94
April 02, 2021
Like
0

2 replies

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') &#124;&#124; (TEXT( StageName ) = 'B') &#124;&#124; (TEXT( StageName ) = 'A') &#124;&#124; (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!

Tyler Tran 94
March 26, 2019
Like
0

4 replies

Cannot read properties of undefined in LWC

Hi everyone! I have to get the response from an API Endpoint and display them in a data table (LWC). The response look like this:

"list": [
        {
            "projectName": "Onnami",
            "point": {
                "min": 9.11,
                "max": 9.18,
                "default": 9.11
            }
        },
        {
            "projectName": "Sunshine INC",
            "point": {
                "min": 9.11,
                "default": 9.11
            }
        }
]

import { LightningElement, api, wire } from 'lwc';
import getSubmissionRecords from '@salesforce/apex/SubmissionController.getSubmissionRecords';

const columns = [
    { label: 'Project Name', fieldName: 'projectName' },
    { label: 'Points', fieldName: 'point', type: 'number' },
    { 
        label: '', 
        fieldName: 'details', 
        type: 'url',  
        typeAttributes: {
            label: { 
                fieldName: 'detailName' 
            },
            target : '_blank'
        }},
];

export default class PricingTab extends LightningElement {
    @api recordId;
    @api columnData;

    @wire(getSubmissionRecords, { projectId: '$recordId' })
    returnedSubmissions({data, error}) {
        if(data) {
            let dataRefer = [];
            
            data.forEach((record) => {
                let preparedData = {};

                preparedData.projectName = record.projectName;
                preparedData.point = record.point.default;
                preparedData.detailName = 'Details';
                preparedData.details = 'https://google.com';

                dataRefer.push(preparedData);
            })

            this.columnData = dataRefer;
        }

        if(error) {
            console.log(error)
        }
    }
}

Here is the HTML file:

<template>
    <lightning-datatable key-field="Id" data={columnData} columns={columns}></lightning-datatable>
</template>

The response returns about over 500 records.
Thank you so much!

Tyler Tran 94
June 13, 2022
Like
0

3 replies

Can't login to iframe URL in Visualforce Page

<div style="float: left; width: 100%"> <apex:outputPanel layout="block" style="overflow:hidden"> <apex:iframe height="500px" width="100%" id="loginFrame"/> </apex:outputPanel> </div> <script type="text/javascript"> window.onload = function() { setTimeout(function() { var frame = document.getElementById('loginFrame'); if(frame) { frame.src = "https://dev-mk.eaga.com/prices/app/{!oppId}"; } }, 500); } </script>

What can I do to fix this problem?

Tyler Tran 94
May 30, 2022
Like
0

SOLVED

2 replies

getObjectInfos is not working

I have a basic coding about getObjectInfos adapter but it seems not working:

import { LightningElement, wire } from 'lwc';
import { getObjectInfos } from 'lightning/uiObjectInfoApi';
import ACCOUNT_OBJECT from '@salesforce/schema/Account';
import OPPORTUNITY_OBJECT from '@salesforce/schema/Opportunity';


export default class GetObjectInfosLwc extends LightningElement {
    @wire(getObjectInfos, {objectApiName:[ACCOUNT_OBJECT, OPPORTUNITY_OBJECT]})
    objectInfosHandler({data, error}) {
        if(data) {
            console.log("Get Multiple " + data)
        }
        if(error) {
            console.error(error)
        }
    }
}

and here is the Browser Console log:

beaconLib.BeaconLibrary.js:37 {InstrumentationResult :  ( RECEIVED = 14 , SUCCESS -> LOG = 14 , Topic = AILTN )  , TracingResponse : ( AsyncResults ) , TelemetryResponse : ( AsyncResults ): {…}}

As you can see, it doesn't print the list of metadata (for Account and Opportunity). I need some help!
Thank you so much.

Tyler Tran 94
June 21, 2021
Like
0

1 replies

Webhook Intent to receive required

Hi Guys,
I am Integrating Xero with salesforce in my dev org
here's the validation code for the webhook

@RestResource(urlMapping='/XeroApi/*')
Global class RT_XeroApiClass {
    global static String jsonResults;
    @HttpPost
    global static Integer validatexero () {
        String xeroSignature = RestContext.request.headers.get('x-xero-signature');
        String xeroPayload = RestContext.request.requestBody.toString();
        Blob signedPayload = Crypto.generateMac('hmacSHA256', Blob.valueOf(xeroPayload), Blob.valueOf(System.Label.Webhook_Payload));
        String encodedPayload = EncodingUtil.base64Encode(signedPayload);
        RestContext.response.statusCode = encodedPayload == xeroSignature ? 200 : 401;
        
        return RestContext.response.statusCode;
    }
}

The Delivery URL in the webhook is

https://appl-dev-ed.my.salesforce.com/services/apexrest/XeroApi

when I am sending Intent to receive the status always shows "Intent to receive" required
User-added image

can you please tell me what I am missing here?
Thanks,
Rahul

Test Dev 81
June 09, 2021
Like
0

SOLVED

2 replies

LWC - Variable is not defined

Can someone help me with this problem? When I load the component tab then it shows 2 errors: isVpbank is not defined and isHsbcBank is not defined

creditCard.html

<template>
    <template if:true={isVpbank}>
        <img class="image-card" src={vpbankImage}/>
    </template>

    <template if:true={isHsbcBank}>
        <img class="image-card" src={hsbcImage}/>
    </template>
    
    
    <div class="slds-m-around_medium">
        <template if:true={creditCard.data}>
            <template for:each={creditCard.data} for:item="cc">
                <p key={cc.Id}>{cc.Name}</p>
            </template>
        </template>
    </div>

</template>

creditCard.js

import { LightningElement, api, wire } from 'lwc';

import myResource from '@salesforce/resourceUrl/creditCard';
import getCreditCard from '@salesforce/apex/CreditCardController.getCreditCard';
import isVpBankCredit from '@salesforce/apex/CreditCardController.isVpBankCredit';
import isHsbcCredit from '@salesforce/apex/CreditCardController.isHsbcCredit';


const VP_BANK = myResource + '/credit-card-images/vp-bank.jpg';
const HSBC = myResource + '/credit-card-images/hsbc.jpg';

export default class CreditCard extends LightningElement {
    vpbankImage = VP_BANK;
    hsbcImage = HSBC;
    isVpbank = false;
    isHsbcBank = false;
    
    @wire(getCreditCard) creditCard;

    connectedCallback() {
        isVpBankCredit().then((result) => {
            this.isVpbank = result;
            console.log(isVpbank);
        });

        isHsbcCredit().then((result) => {
            this.isHsbcBank = result;
            console.log(isHsbcBank);
        });
    }
}

Tyler Tran 94
April 02, 2021
Like
0

2 replies

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') &#124;&#124; (TEXT( StageName ) = 'B') &#124;&#124; (TEXT( StageName ) = 'A') &#124;&#124; (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

Tyler Tran 94
March 26, 2019
Like
0

SOLVED

9 replies

Too many Query Rows - Developer Console

Can someone please assist, how do i get around this exception of 'Too many query Rows 5001'

list<Id> accId = new list<Id>();

list<Contact> conDSA = [Select Id, Name, DSA__c, AccountID from Contact 
                        Where DSA__c = true AND AccountID!=null ];

system.debug('Number of Contacts that are DSA ' +conDSA.size());
for (Contact c: conDSA){
system.debug('>>> ' +c.Name + c.AccountId);
    accId.add(c.AccountId);

}

list<AccountContactRelation> acr = [SELECT Id, isDSA__c,AccountId, ContactId 
                                    FROM AccountContactRelation 
                                    Where AccountId IN :accId ];

system.debug('Number of records in ACR are: ' +acr.size());

for (AccountContactRelation a: acr){
    	a.isDSA__c = true;
}
update acr;

RarLopz
March 25, 2019
Like
1

36 replies

Hi All, I am getting this error message on my trailhead free trail financial Service Cloud

I am getting the following error message while creating an account (Person Account/Household):

"FinServ.AccountTrigger: execution of BeforeInsert caused by: FinServ.MoiExceptionWrapper.ValidationException: Your account record type is missing, a duplicate, or invalid. Ask your admin to check the individual record type configurations in Setup. (FinServ)"

I think it has something to do with my account record type settings. I tried checking in setup for the same but couldn't find anything. Also under Wealth Management Set up> Groups > Record types - I didn't find any records. Is this ok?

*Note - The org set up is not part of any firm or entity. Its set up for training purposes as suggested in Trailhead modules.

Any help to resolve this would be great. Thanks in advance.

Pushkar Bhutada 5
June 20, 2018
Like
2

SOLVED

9 replies

Too many Query Rows - Developer Console

Can someone please assist, how do i get around this exception of 'Too many query Rows 5001'

list<Id> accId = new list<Id>();

list<Contact> conDSA = [Select Id, Name, DSA__c, AccountID from Contact 
                        Where DSA__c = true AND AccountID!=null ];

system.debug('Number of Contacts that are DSA ' +conDSA.size());
for (Contact c: conDSA){
system.debug('>>> ' +c.Name + c.AccountId);
    accId.add(c.AccountId);

}

list<AccountContactRelation> acr = [SELECT Id, isDSA__c,AccountId, ContactId 
                                    FROM AccountContactRelation 
                                    Where AccountId IN :accId ];

system.debug('Number of records in ACR are: ' +acr.size());

for (AccountContactRelation a: acr){
    	a.isDSA__c = true;
}
update acr;

RarLopz
March 25, 2019
Like
1