Salesforce Developer Community

Sumant Kuchipudi
NEWBIE
55 Points
Member since 2016

Chatter

Feed
0

Best Answers
4

Likes Received
0

Likes Given
46

Questions
28

Replies

How to decrypt the encrpted password in apex?

Hi,
I have a custom object with an encrypted text field to store password from record. I'm trying to write a trigger to read the encrypted field and send via email. Would that be possible? I tried to decrypt the password but recieved the below error.

System.StringException: Unrecognized base64 character: *

Sumant Kuchipudi
October 04, 2022
Like
0

1 replies

Unable to login to salesforce using salesforce universal urls

Hi,
We have domain and it is unchecked Login Policy
"Prevent login from https://login.salesforce.com" but still i'm not able to login to salesforce usng login.salesforce.com (or test.salesforce.com using sandbox creds). It is also prevening to authorize third party installs (adobe acrobat sign). May I know what would be the reason not able to use salesforce universal urls to login?

Sumant Kuchipudi
September 30, 2022
Like
0

2 replies

Adobe's Acrobat sign integration

Hi, I'm new to this integration and trying to integration with Adobe Acrobat Sign via the apex code (not with installing the Application package from Salesforce Appexchange).. and I would like to send documents (with dynamic fields from a custom object record) to the users to sign and get the document back to salesforce saved.

I did the smilar thing on box integration (without installing the app, send and retrieve the document).

If this is possible that would be really helpful.

Thanks,
Sumant K

Sumant Kuchipudi
September 18, 2022
Like
0

2 replies

Email to Case Description filling unwanted stuff

Hi,
We are higly depending on Cases and whenever the Email to Case happened, the desciprion field is filling with a lot of unwanted stuf and we are deleting the description field on all cases with dataloader. Is there a betterway to clear and not update this field?

Sumant Kuchipudi
September 09, 2022
Like
0

1 replies

Generate PDF with static and dynamic text

Hi,
I have a requirement that we have a pdf sample which we need to generate when the user click from Action/Button from Case and display and when we click on another button that generate pdf should be emailed to the customer. We developed Visuasource page to genrate pdf, is there any alternate solution because we have plenty of requirements to write pdfs.

Sumant Kuchipudi
September 09, 2022
Like
0

1 replies

Not receving verification code email

Hi,
I used to get login verification code to my email address but not receiving since couple weeks. I even assigned "Email-Based Identity Verification Option" permission set but still unable to recive the code. Any isse?

Sumant Kuchipudi
February 12, 2022
Like
0

2 replies

Lead conversion mapping for Account quesion

Hi,
When we convert a lead, internally it creates Account with the Lead.Company name but I would like to create an Account based on the Lead last name provided on the Lead page not with the Company name. Looks like it is standard mapping but is there a way to change the mapping? or if not possible can we do a custom Lead conversion with the Custom button and apex code ?

Sumant Kuchipudi
February 09, 2022
Like
0

3 replies

Getting SalesforceException: Remotely closed

Hi,
I'm using Mulesoft integration tool and invoking Salesforce Apex Rest API (@RestResource(urlMapping = '/matchingtool/*'), it is working since year until couple of weeks or less. for each hour in a 24 hour window the integration may invoke this api for 1000 times, most of the hours it is working completely for those 1000 but for couple of hourls it's failing with this exception. I poste d question in Mulesoft but everyone replying that this might be Salesforce issue so checking here.
Below is Apex code:

@RestResource(urlMapping = '/matchingtool/*')
global class EmpMatchingTool {
    @HttpPost
    global static String getIdByIdentifiers(Identifiers identifiers) {
        ---------
   }
}

Below is complete exception:

org.mule.extension.salesforce.internal.error.exception.service.SalesforceException: Remotely closed
	at org.mule.extension.salesforce.internal.error.exception.service.handlers.IOExceptionHandler.handle(IOExceptionHandler.java:44)
	at org.mule.extension.salesforce.internal.connection.ForceWSCConnection.send(ForceWSCConnection.java:332)
	at org.mule.extension.salesforce.internal.service.apex.rest.ApexRestInvocation.invokeApexRest(ApexRestInvocation.java:392)
	at org.mule.extension.salesforce.internal.service.apex.util.ApexClient.invokeRestMethod(ApexClient.java:188)
	at org.mule.extension.salesforce.internal.service.ApexServiceImpl.lambda$invokeRestMethod$1(ApexServiceImpl.java:66)
	at org.mule.extension.salesforce.internal.connection.ForceWSCConnection.executeOverApexRestClient(ForceWSCConnection.java:239)
	at org.mule.extension.salesforce.internal.service.ForceWSCService.executeOverApexRestClient(ForceWSCService.java:28)
	at org.mule.extension.salesforce.internal.service.ApexServiceImpl.invokeRestMethod(ApexServiceImpl.java:53)
	at org.mule.extension.salesforce.internal.operation.apex.InvokeApexRestMethodOperation.invokeApexRestMethod(InvokeApexRestMethodOperation.java:54)
	at org.mule.extension.salesforce.internal.operation.apex.InvokeApexRestMethodOperation$invokeApexRestMethod$MethodComponentExecutor.execute(Unknown Source)
	at org.mule.runtime.module.extension.internal.runtime.execution.GeneratedMethodComponentExecutor.execute(GeneratedMethodComponentExecutor.java:97)
	at org.mule.runtime.module.extension.internal.runtime.execution.CompletableMethodOperationExecutor.doExecute(CompletableMethodOperationExecutor.java:29)
	at org.mule.runtime.module.extension.internal.runtime.execution.AbstractCompletableMethodOperationExecutor.execute(AbstractCompletableMethodOperationExecutor.java:63)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeCommand(DefaultExecutionMediator.java:211)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$executeWithInterceptors$6(DefaultExecutionMediator.java:192)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$executeWithRetry$2(DefaultExecutionMediator.java:130)
	at net.jodah.failsafe.Functions.lambda$promiseOfStage$8(Functions.java:193)
	at net.jodah.failsafe.internal.executor.RetryPolicyExecutor$1.call(RetryPolicyExecutor.java:101)
	at net.jodah.failsafe.internal.executor.RetryPolicyExecutor.lambda$supplyAsync$1(RetryPolicyExecutor.java:133)
	at net.jodah.failsafe.Functions.lambda$null$1(Functions.java:69)
	at org.mule.runtime.core.internal.util.rx.ConditionalExecutorServiceDecorator.synchronousSchedule(ConditionalExecutorServiceDecorator.java:181)
	at org.mule.runtime.core.internal.util.rx.ConditionalExecutorServiceDecorator.schedule(ConditionalExecutorServiceDecorator.java:167)
	at net.jodah.failsafe.Functions.lambda$makeAsync$2(Functions.java:79)
	at net.jodah.failsafe.AsyncExecution.executeAsync(AsyncExecution.java:174)
	at net.jodah.failsafe.FailsafeExecutor.callAsync(FailsafeExecutor.java:346)
	at net.jodah.failsafe.FailsafeExecutor.getStageAsync(FailsafeExecutor.java:178)
	at org.mule.runtime.core.internal.retry.policies.SimpleRetryPolicy.applyPolicy(SimpleRetryPolicy.java:90)
	at org.mule.runtime.core.api.retry.policy.RetryPolicyTemplate.applyPolicy(RetryPolicyTemplate.java:144)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeWithRetry(DefaultExecutionMediator.java:128)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeWithInterceptors(DefaultExecutionMediator.java:192)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$execute$1(DefaultExecutionMediator.java:113)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$new$0(DefaultExecutionMediator.java:61)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.execute(DefaultExecutionMediator.java:112)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.executeOperation(ComponentMessageProcessor.java:563)
	at org.mule.runtime.module.extension.internal.runtime.operation.OAuthOperationMessageProcessor.executeOperation(OAuthOperationMessageProcessor.java:58)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.prepareAndExecuteOperation(ComponentMessageProcessor.java:765)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.access$100(ComponentMessageProcessor.java:185)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor$4.lambda$innerEventDispatcher$9(ComponentMessageProcessor.java:637)
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableConditionalSubscriber.tryOnNext(FluxPeekFuseable.java:510)
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableConditionalSubscriber.tryOnNext(FluxPeekFuseable.java:523)
	at reactor.core.publisher.FluxPublishOn$PublishOnConditionalSubscriber.runAsync(FluxPublishOn.java:866)
	at reactor.core.publisher.FluxPublishOn$PublishOnConditionalSubscriber.run(FluxPublishOn.java:939)
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84)
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at org.mule.service.scheduler.internal.AbstractRunnableFutureDecorator.doRun(AbstractRunnableFutureDecorator.java:111)
	at org.mule.service.scheduler.internal.RunnableFutureDecorator.run(RunnableFutureDecorator.java:54)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

Sumant Kuchipudi
February 18, 2021
Like
0

2 replies

Getting "Future method cannot be called from a future or batch method" error

Hi,
I have a trigger that invokes UpdateCallToExternal (future method), this external class checks for System.isFuture() and enqueJob with another class, and that another class invokes the future method in UpdateCallToExternal. Below is the code snippet.

global class UpdateCallToExternal {
    private static Integer callCount=0;

    @InvocableMethod
    global static void updateDeliveryStatus(List<Id> recIds){
        if(System.isFuture()){
            System.enqueueJob(new UpdateCallToExternalQueuable(String.join(recIds,',')));
        }else{
            invokeBulkUpdate(String.join(recIds,','));
        }

    }
    
    @future(callout=true)
    global static void invokeExternalSystem(String recIds){
        HttpRequest muleRequest = new HttpRequest();
        .....
    }

    global static void invokeBulkUpdate(String recIds) {
        callCount+=1;
        try {
            invokeExternalSystem(recIds);

         } catch(Exception e) {
             if (callCount <= 5)
                 invokeBulkUpdate(recIds);
         } 
    }

Below is Queuable class that invokes UpdateCallToExternal (future callout)

public class UpdateCallToExternalQueuable implements Queueable,Database.AllowsCallouts{
    String recIds;
    public UpdateCallToExternalQueuable(String recIds){
        this.recIds = recIds;
    }
    public void execute(QueueableContext qc){
        UpdateCallToExternal.invokeBulkUpdate(recIds);
    }
}

No idea what's wrong in this, could someone review the code and let me know the issue?
fyi: this error is raising exaclty raising at 10:00 PM only, no other timings.

Sumant Kuchipudi
February 07, 2021
Like
0

2 replies

Record Currently Unavailable: The record you are attempting to edit... getting this issue

First I directly trying to update records but got "UNABLE_TO_LOCK_ROW on updating records.." issue, then I use "FOR UPDATE" keyword on select query then I'm getting this error from select statement.

Record Currently Unavailable: The record you are attempting to edit, or one of its related records, is currently being modified by another user. Please try again

I have no clue how to avoid this issue, is there anything I'm missing? please advise.

Sumant Kuchipudi
September 08, 2020
Like
0

SOLVED

3 replies

Process builder not triggering on update field

Hi,
i have process builder which should trigger when a field (boolean) is changed (checked/unchecked) on UPDATE record (not new) but it seems not triggering, here is the Formuls used in PB.

NOT(ISNEW()) && ISCHANGED([Contact].Is_Contacted__c )

Any issue on the abve formula?

Sumant Kuchipudi
September 04, 2020
Like
0

0 replies

How to check Date before Database upsert?

Hi, I'm getting an incoming date field from the the HttpRequest as "Sun Sep 08 00:00:00 GMT 20" and when I upsert the record I get "invalid date: Sun Sep 08 00:00:00 GMT 20". I want to verify this field and remove if its Invalid date before upsert.

Sumant Kuchipudi
February 14, 2020
Like
0

0 replies

How to merge Contacts with related list in lightning?

hi,
Salesforce has "Potential Duplicates" lightning component but that works only if contact "A" has no related list to merge Contact "B" but if "A" has related litst then getting a problem. I need to transfer A's related list to B when merging A to B. Hows it possible? Appreciate your help.

Sumant Kuchipudi
January 17, 2020
Like
0

5 replies

how to get file preview on Lightning Component?

Hi,
I have lightning components that displays images from ContentVersion as thumbnails and also links, when I click on the image its directly downloading the image but I would like it to open as preivew or open the image in a new tab/window. please advice.
below is the current line that displays image thumbnails with link to open big

<aura:iteration items="{!v.items}" var="content">
	       <a href="/sfc/servlet.shepherd/version/download/'+{!content.id}" target="_blank"> <img src="/sfc/servlet.shepherd/version/download/'+{!content.id}" width="100" height="100"/> </a>
	    </aura:iteration>

Sumant Kuchipudi
December 05, 2018
Like
1

2 replies

Batch execute on Http callouts

Hi,
I have an object with 1.5 million records and I need to update couple of fields on all 1.5 m records by calling HTTP callout for each records, i.e. inside batch I need to call outside for 1.5 m times. Is that ok to run the query on all these records and invoke HttP callout? Is that feacible? whats the best procedure.
Thank you very much.

Sumant Kuchipudi
November 29, 2018
Like
0

1 replies

How can we bulk delete Content Bodies?

Hi,
I have sandbox and we are cleaning up the data for fresh loads, we were able to bulk delete records(dataloader) on Standard and Custom objects but I can't find the way to delete the Content Bodies. All these content (files) recrods childs to Accounts, I think when we delete all Accounts these Contents should have been deleted but I still see the Content Bodies in Storage Usage page.
User-added image

Sumant Kuchipudi
November 20, 2018
Like
0

1 replies

Bulk upsert api not calling trigger

Hi,
I have a trigger on an object that compares the new values with the existing and send email if new value comes for each record. When I tested with simeple UPSERT record it worked and whem I tested with an integration that calls upser bulk api, the trigger didn't invoke. Triggerns won't triggern on bulk api requests?

Sumant Kuchipudi
November 02, 2018
Like
0

2 replies

"System.LimitException: Too many SOQL queries" ERROR in RestResource

Hi,
I have RestResource (httppost) that receives the data (JSON) from third party, they have bunch of members information which we need to upsert them into our system. if JSOn contains couple of records then fine but when they send 20 records then failing with "FATAL_ERROR|System.LimitException: Too many DML statements: 151". please see below code. What is the best way to process those bunch of records?

@RestResource(urlMapping='/ELPMData/*')
global with sharing class ELPMData {
	@httpPost
    global static String getMembersData(List<ELPMember> members){
        try{
            for (ELPMember elp: members){
                Bio bio = elp.bio;
                Account acc = new Account();
                acc.Name = bio.LastName+', '+bio.FirstName;
                acc.External_ID__c = bio.ID;
                acc.State__c = bio.State;
                acc.Type = 'Member';
                upsert acc External_ID__c;

                Contact con = new Contact();
                con.AccountId = acc.id;
                //Other contact fields mapping here
                upsert con External_ID__c;

                if (elp.ContactInformations != null){
                    List<Address__c> addrList = new List<Address__c>();
                    for (ContactInformation ci:elp.ContactInformations){
                        if (ci.AddressID != null && ci.AddressID != ''){
                            System.debug(' INSIDE ADDRESS '+ci.AddressID);
                            Address__c add = new Address__c();
                            add.AddressID__c = ci.AddressID;
                            //Other Address fields mapping here
                            addrList.add(add);
                        }
                    }
                    if (addrList.size()>0){
                        upsert addrList AddressID__c;
                    }
                }
                if (elp.Affiliations != null){
                    List<Affiliation__c> affilList = new List<Affiliation__c>();
                    for (Affiliation aff:elp.Affiliations){
                        if (aff.UniqueID != null && aff.UniqueID != ''){
                            Affiliation__c elpAffl = new Affiliation__c();
                            elpAffl.UniqueID__c = aff.UniqueID;
                            //Other Affiliation__c fields mapping here
                            affilList.add(elpAffl);
                        }
                        
                    }
                    if (affilList.size()>0){
                        upsert affilList UniqueID__c;
                    }
                }
                if (elp.Educations != null){
                    List<Education__c> eduList = new List<Education__c>();
                    for (Education edu:elp.Educations){
                        if (edu.InstitutionID != null && edu.InstitutionID != ''){
                            Education__c elpEdu = new Education__c();
                            elpEdu.InstitutionID__c = edu.InstitutionID;
                            //Other Education mapping here
                            eduList.add(elpEdu);
                        }
                    }
                    if (eduList.size()>0){
                        upsert eduList InstitutionID__c;
                    }
                }
                if (elp.Employments != null){
                    List<Employment__c> empList = new List<Employment__c>();
                    for (Employment emp:elp.Employments){
                        if (emp.UniqueID != null && emp.UniqueID != ''){
                            Employment__c elpEmp = new Employment__c();
                            elpEmp.UniqueID__c = emp.UniqueID;
                            //Other Employments mapping here
                            empList.add(elpEmp);
                        }
                    }
                    if (empList.size()>0){
                        upsert empList UniqueID__c;
                    }
                }
                
               
            }
        }catch(Exception e){
            System.debug('The following exception has occurred: ' + e.getMessage());
			return 'Integration FAILED, check with GU Admins';
        }
        return 'SUCCESS';
    }
    
    global class ELPMember {
        global Bio Bio {get;set;}
        global List<ContactInformation> ContactInformations {get;set;}
        global List<Affiliation> Affiliations {get;set;}
        global List<Education> Educations {get;set;}
        global List<Employment> Employments {get;set;}
    }
    global class Bio{
        //All Bio fields
    }
    global class Education {
        //All Education Fields
    }
    global class Affiliation{
        //All Affiliation fields
    }
    global class ContactInformation{
        //All Contact Fields
    }
    
    global class Employment{
        //All Employment fields
    }
    
}

they may have 10000 members which we need to insert first time.

Sumant Kuchipudi
October 01, 2018
Like
0

4 replies

ProcessBuilder failing with "Future method cannot be called from a future or batch method: " error

Hi,
I have a process builder which calls Apex method (@InvocableMethod) and the apex method calls future callout, this process is failing with the below error. I have the code checking !system.isFuture() but still failing, not able to figure out.

Error element myRule_1_A1 (FlowActionCall).
An Apex error occurred: System.AsyncException: Future method cannot be called from a future or batch method: AddressValidateController.invokeAddressController(List)

Apex Code is below.

global with sharing class AddressValidateController {
    public static boolean isVerified = false;
   
	@InvocableMethod
    global static void validateAddressFromPB(List<Id> recIds){
       
        if(!system.isFuture() && !isVerified){
            integer count = 0;
            List<String> subList = new List<String>();
            for (Id recId:recIds){
                count+=1;
                subList.add(recId);
                if (Math.Mod(count, 100)==0){
                    invokeAddressController(subList);
                    subList=new List<String>();
                }
            }
            invokeAddressController(subList);
            isVerified = true;
        }
    }
    
    
	@future(callout=true)
    global static void invokeAddressController(List<Id> recIds){
        
               Address validation callout code here
    }
}

Please advice..!

Sumant Kuchipudi
September 25, 2018
Like
0

1 replies

Upsert Account failing with Duplicate error

I have created an external field in Account and have very simple code that upserts Account record.
below is the code

Account a = new Account();
a.name='Testing 99test9911';
a.Account_External_Id__c='99test99';
upsert a;

First time it creatd record but next time when I ran it failed (below is error), my environment is pretty much new (no triggers and no Workflows and no ProcessBuilders), I don't know how to fix this. Please advice

12:11:45:057 EXCEPTION_THROWN [4]|System.DmlException: Upsert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: Account_External_Id__c duplicates value on record with id: 0010t0000137DHM: []

Sumant Kuchipudi
September 25, 2018
Like
0

5 replies

how to get file preview on Lightning Component?

<aura:iteration items="{!v.items}" var="content">
	       <a href="/sfc/servlet.shepherd/version/download/'+{!content.id}" target="_blank"> <img src="/sfc/servlet.shepherd/version/download/'+{!content.id}" width="100" height="100"/> </a>
	    </aura:iteration>

Sumant Kuchipudi
December 05, 2018
Like
1

1 replies

How can we restrict to one File/Note upload only on Custom object

I have custom object and it has Notes and Files related list, I want to restrict to one Note and one File for each custom record. Would that be possible?

Sumant Kuchipudi
September 06, 2018
Like
1

5 replies

How to make a visual force page public?

I have a requirement that ananymous user who doesn't requre login to access a page, fills the details, saves to an object (custom, and it has lookup field to contact) . For this I have done the below steps

Added Domain
Created new Site
Assigned the created VF page in to the list 'Site Visualforce Pages'
Activated the site
Gave perrmissions (RWA) to the custom object

But when I click on the page I got the following error

Authorization Required

You must first log in or register before accessing this page.
If you have forgotten your password, click Forgot Password to reset it.

We should directly access to the page without authorize, how can we do this?
Thanks,

Sumant Kuchipudi
February 12, 2018
Like
1

SOLVED

1 replies

How to get a field from Parent's another child record?

Hi,

I have custom object which has a Account ( lookup ) and that account has Contact record. How can I get Contact's external Id (custom field) value ? Please advice.

Thanks

Sumant Kuchipudi
April 06, 2017
Like
1

SOLVED

2 replies

How to decrypt the encrpted password in apex?

System.StringException: Unrecognized base64 character: *

Sumant Kuchipudi
October 04, 2022
Like
0

2 replies

Adobe's Acrobat sign integration

Sumant Kuchipudi
September 18, 2022
Like
0

2 replies

Email to Case Description filling unwanted stuff

Sumant Kuchipudi
September 09, 2022
Like
0

2 replies

Lead conversion mapping for Account quesion

Sumant Kuchipudi
February 09, 2022
Like
0

3 replies

Getting SalesforceException: Remotely closed

@RestResource(urlMapping = '/matchingtool/*')
global class EmpMatchingTool {
    @HttpPost
    global static String getIdByIdentifiers(Identifiers identifiers) {
        ---------
   }
}

Below is complete exception:

org.mule.extension.salesforce.internal.error.exception.service.SalesforceException: Remotely closed
	at org.mule.extension.salesforce.internal.error.exception.service.handlers.IOExceptionHandler.handle(IOExceptionHandler.java:44)
	at org.mule.extension.salesforce.internal.connection.ForceWSCConnection.send(ForceWSCConnection.java:332)
	at org.mule.extension.salesforce.internal.service.apex.rest.ApexRestInvocation.invokeApexRest(ApexRestInvocation.java:392)
	at org.mule.extension.salesforce.internal.service.apex.util.ApexClient.invokeRestMethod(ApexClient.java:188)
	at org.mule.extension.salesforce.internal.service.ApexServiceImpl.lambda$invokeRestMethod$1(ApexServiceImpl.java:66)
	at org.mule.extension.salesforce.internal.connection.ForceWSCConnection.executeOverApexRestClient(ForceWSCConnection.java:239)
	at org.mule.extension.salesforce.internal.service.ForceWSCService.executeOverApexRestClient(ForceWSCService.java:28)
	at org.mule.extension.salesforce.internal.service.ApexServiceImpl.invokeRestMethod(ApexServiceImpl.java:53)
	at org.mule.extension.salesforce.internal.operation.apex.InvokeApexRestMethodOperation.invokeApexRestMethod(InvokeApexRestMethodOperation.java:54)
	at org.mule.extension.salesforce.internal.operation.apex.InvokeApexRestMethodOperation$invokeApexRestMethod$MethodComponentExecutor.execute(Unknown Source)
	at org.mule.runtime.module.extension.internal.runtime.execution.GeneratedMethodComponentExecutor.execute(GeneratedMethodComponentExecutor.java:97)
	at org.mule.runtime.module.extension.internal.runtime.execution.CompletableMethodOperationExecutor.doExecute(CompletableMethodOperationExecutor.java:29)
	at org.mule.runtime.module.extension.internal.runtime.execution.AbstractCompletableMethodOperationExecutor.execute(AbstractCompletableMethodOperationExecutor.java:63)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeCommand(DefaultExecutionMediator.java:211)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$executeWithInterceptors$6(DefaultExecutionMediator.java:192)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$executeWithRetry$2(DefaultExecutionMediator.java:130)
	at net.jodah.failsafe.Functions.lambda$promiseOfStage$8(Functions.java:193)
	at net.jodah.failsafe.internal.executor.RetryPolicyExecutor$1.call(RetryPolicyExecutor.java:101)
	at net.jodah.failsafe.internal.executor.RetryPolicyExecutor.lambda$supplyAsync$1(RetryPolicyExecutor.java:133)
	at net.jodah.failsafe.Functions.lambda$null$1(Functions.java:69)
	at org.mule.runtime.core.internal.util.rx.ConditionalExecutorServiceDecorator.synchronousSchedule(ConditionalExecutorServiceDecorator.java:181)
	at org.mule.runtime.core.internal.util.rx.ConditionalExecutorServiceDecorator.schedule(ConditionalExecutorServiceDecorator.java:167)
	at net.jodah.failsafe.Functions.lambda$makeAsync$2(Functions.java:79)
	at net.jodah.failsafe.AsyncExecution.executeAsync(AsyncExecution.java:174)
	at net.jodah.failsafe.FailsafeExecutor.callAsync(FailsafeExecutor.java:346)
	at net.jodah.failsafe.FailsafeExecutor.getStageAsync(FailsafeExecutor.java:178)
	at org.mule.runtime.core.internal.retry.policies.SimpleRetryPolicy.applyPolicy(SimpleRetryPolicy.java:90)
	at org.mule.runtime.core.api.retry.policy.RetryPolicyTemplate.applyPolicy(RetryPolicyTemplate.java:144)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeWithRetry(DefaultExecutionMediator.java:128)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.executeWithInterceptors(DefaultExecutionMediator.java:192)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$execute$1(DefaultExecutionMediator.java:113)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.lambda$new$0(DefaultExecutionMediator.java:61)
	at org.mule.runtime.module.extension.internal.runtime.operation.DefaultExecutionMediator.execute(DefaultExecutionMediator.java:112)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.executeOperation(ComponentMessageProcessor.java:563)
	at org.mule.runtime.module.extension.internal.runtime.operation.OAuthOperationMessageProcessor.executeOperation(OAuthOperationMessageProcessor.java:58)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.prepareAndExecuteOperation(ComponentMessageProcessor.java:765)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor.access$100(ComponentMessageProcessor.java:185)
	at org.mule.runtime.module.extension.internal.runtime.operation.ComponentMessageProcessor$4.lambda$innerEventDispatcher$9(ComponentMessageProcessor.java:637)
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableConditionalSubscriber.tryOnNext(FluxPeekFuseable.java:510)
	at reactor.core.publisher.FluxPeekFuseable$PeekFuseableConditionalSubscriber.tryOnNext(FluxPeekFuseable.java:523)
	at reactor.core.publisher.FluxPublishOn$PublishOnConditionalSubscriber.runAsync(FluxPublishOn.java:866)
	at reactor.core.publisher.FluxPublishOn$PublishOnConditionalSubscriber.run(FluxPublishOn.java:939)
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:84)
	at reactor.core.scheduler.WorkerTask.call(WorkerTask.java:37)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at org.mule.service.scheduler.internal.AbstractRunnableFutureDecorator.doRun(AbstractRunnableFutureDecorator.java:111)
	at org.mule.service.scheduler.internal.RunnableFutureDecorator.run(RunnableFutureDecorator.java:54)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

Sumant Kuchipudi
February 18, 2021
Like
0

2 replies

Getting "Future method cannot be called from a future or batch method" error

global class UpdateCallToExternal {
    private static Integer callCount=0;

    @InvocableMethod
    global static void updateDeliveryStatus(List<Id> recIds){
        if(System.isFuture()){
            System.enqueueJob(new UpdateCallToExternalQueuable(String.join(recIds,',')));
        }else{
            invokeBulkUpdate(String.join(recIds,','));
        }

    }
    
    @future(callout=true)
    global static void invokeExternalSystem(String recIds){
        HttpRequest muleRequest = new HttpRequest();
        .....
    }

    global static void invokeBulkUpdate(String recIds) {
        callCount+=1;
        try {
            invokeExternalSystem(recIds);

         } catch(Exception e) {
             if (callCount <= 5)
                 invokeBulkUpdate(recIds);
         } 
    }

Below is Queuable class that invokes UpdateCallToExternal (future callout)

public class UpdateCallToExternalQueuable implements Queueable,Database.AllowsCallouts{
    String recIds;
    public UpdateCallToExternalQueuable(String recIds){
        this.recIds = recIds;
    }
    public void execute(QueueableContext qc){
        UpdateCallToExternal.invokeBulkUpdate(recIds);
    }
}

No idea what's wrong in this, could someone review the code and let me know the issue?
fyi: this error is raising exaclty raising at 10:00 PM only, no other timings.

Sumant Kuchipudi
February 07, 2021
Like
0

2 replies

Record Currently Unavailable: The record you are attempting to edit... getting this issue

First I directly trying to update records but got "UNABLE_TO_LOCK_ROW on updating records.." issue, then I use "FOR UPDATE" keyword on select query then I'm getting this error from select statement.

Record Currently Unavailable: The record you are attempting to edit, or one of its related records, is currently being modified by another user. Please try again

I have no clue how to avoid this issue, is there anything I'm missing? please advise.

Sumant Kuchipudi
September 08, 2020
Like
0

SOLVED

3 replies

Process builder not triggering on update field

Hi,
i have process builder which should trigger when a field (boolean) is changed (checked/unchecked) on UPDATE record (not new) but it seems not triggering, here is the Formuls used in PB.

NOT(ISNEW()) && ISCHANGED([Contact].Is_Contacted__c )

Any issue on the abve formula?

Sumant Kuchipudi
September 04, 2020
Like
0

5 replies

how to get file preview on Lightning Component?

<aura:iteration items="{!v.items}" var="content">
	       <a href="/sfc/servlet.shepherd/version/download/'+{!content.id}" target="_blank"> <img src="/sfc/servlet.shepherd/version/download/'+{!content.id}" width="100" height="100"/> </a>
	    </aura:iteration>

Sumant Kuchipudi
December 05, 2018
Like
1

2 replies

"System.LimitException: Too many SOQL queries" ERROR in RestResource

@RestResource(urlMapping='/ELPMData/*')
global with sharing class ELPMData {
	@httpPost
    global static String getMembersData(List<ELPMember> members){
        try{
            for (ELPMember elp: members){
                Bio bio = elp.bio;
                Account acc = new Account();
                acc.Name = bio.LastName+', '+bio.FirstName;
                acc.External_ID__c = bio.ID;
                acc.State__c = bio.State;
                acc.Type = 'Member';
                upsert acc External_ID__c;

                Contact con = new Contact();
                con.AccountId = acc.id;
                //Other contact fields mapping here
                upsert con External_ID__c;

                if (elp.ContactInformations != null){
                    List<Address__c> addrList = new List<Address__c>();
                    for (ContactInformation ci:elp.ContactInformations){
                        if (ci.AddressID != null && ci.AddressID != ''){
                            System.debug(' INSIDE ADDRESS '+ci.AddressID);
                            Address__c add = new Address__c();
                            add.AddressID__c = ci.AddressID;
                            //Other Address fields mapping here
                            addrList.add(add);
                        }
                    }
                    if (addrList.size()>0){
                        upsert addrList AddressID__c;
                    }
                }
                if (elp.Affiliations != null){
                    List<Affiliation__c> affilList = new List<Affiliation__c>();
                    for (Affiliation aff:elp.Affiliations){
                        if (aff.UniqueID != null && aff.UniqueID != ''){
                            Affiliation__c elpAffl = new Affiliation__c();
                            elpAffl.UniqueID__c = aff.UniqueID;
                            //Other Affiliation__c fields mapping here
                            affilList.add(elpAffl);
                        }
                        
                    }
                    if (affilList.size()>0){
                        upsert affilList UniqueID__c;
                    }
                }
                if (elp.Educations != null){
                    List<Education__c> eduList = new List<Education__c>();
                    for (Education edu:elp.Educations){
                        if (edu.InstitutionID != null && edu.InstitutionID != ''){
                            Education__c elpEdu = new Education__c();
                            elpEdu.InstitutionID__c = edu.InstitutionID;
                            //Other Education mapping here
                            eduList.add(elpEdu);
                        }
                    }
                    if (eduList.size()>0){
                        upsert eduList InstitutionID__c;
                    }
                }
                if (elp.Employments != null){
                    List<Employment__c> empList = new List<Employment__c>();
                    for (Employment emp:elp.Employments){
                        if (emp.UniqueID != null && emp.UniqueID != ''){
                            Employment__c elpEmp = new Employment__c();
                            elpEmp.UniqueID__c = emp.UniqueID;
                            //Other Employments mapping here
                            empList.add(elpEmp);
                        }
                    }
                    if (empList.size()>0){
                        upsert empList UniqueID__c;
                    }
                }
                
               
            }
        }catch(Exception e){
            System.debug('The following exception has occurred: ' + e.getMessage());
			return 'Integration FAILED, check with GU Admins';
        }
        return 'SUCCESS';
    }
    
    global class ELPMember {
        global Bio Bio {get;set;}
        global List<ContactInformation> ContactInformations {get;set;}
        global List<Affiliation> Affiliations {get;set;}
        global List<Education> Educations {get;set;}
        global List<Employment> Employments {get;set;}
    }
    global class Bio{
        //All Bio fields
    }
    global class Education {
        //All Education Fields
    }
    global class Affiliation{
        //All Affiliation fields
    }
    global class ContactInformation{
        //All Contact Fields
    }
    
    global class Employment{
        //All Employment fields
    }
    
}

they may have 10000 members which we need to insert first time.

Sumant Kuchipudi
October 01, 2018
Like
0

4 replies

ProcessBuilder failing with "Future method cannot be called from a future or batch method: " error

Error element myRule_1_A1 (FlowActionCall).
An Apex error occurred: System.AsyncException: Future method cannot be called from a future or batch method: AddressValidateController.invokeAddressController(List)

Apex Code is below.

global with sharing class AddressValidateController {
    public static boolean isVerified = false;
   
	@InvocableMethod
    global static void validateAddressFromPB(List<Id> recIds){
       
        if(!system.isFuture() && !isVerified){
            integer count = 0;
            List<String> subList = new List<String>();
            for (Id recId:recIds){
                count+=1;
                subList.add(recId);
                if (Math.Mod(count, 100)==0){
                    invokeAddressController(subList);
                    subList=new List<String>();
                }
            }
            invokeAddressController(subList);
            isVerified = true;
        }
    }
    
    
	@future(callout=true)
    global static void invokeAddressController(List<Id> recIds){
        
               Address validation callout code here
    }
}

Please advice..!

Sumant Kuchipudi
September 25, 2018
Like
0

1 replies

Upsert Account failing with Duplicate error

I have created an external field in Account and have very simple code that upserts Account record.
below is the code

Account a = new Account();
a.name='Testing 99test9911';
a.Account_External_Id__c='99test99';
upsert a;

12:11:45:057 EXCEPTION_THROWN [4]|System.DmlException: Upsert failed. First exception on row 0; first error: DUPLICATE_VALUE, duplicate value found: Account_External_Id__c duplicates value on record with id: 0010t0000137DHM: []

Sumant Kuchipudi
September 25, 2018
Like
0

3 replies

How to update LinkedEntityId in ContentDocumentLink ?

HI,
I need to pull the all ContentDocumentLink recrods related to All Contacts (30K) and update LinkedEntityId (related to Contact) with new custom object record ids. while updating ContentDocumentLink record I got below error

LinkedEntityIdUnable to create/update fields: LinkedEntityId. Please check the security settings of this field and verify that it is read/write for your profile or permission set.INVALID_FIELD_FOR_INSERT_UPDATEfalse

I'm using python script to do this (but apex solution is also fine). please check below code

query_result  = self.svc.query("select id from contact where Student__c=true and id='00336000014TJv9'")
            cnt=0
            contList=[]
            while True:
                for row in query_result[self.sf.records:]:
                    cnt+=1
                    contList.append(str(row[1]))
                if str(query_result[self.sf.done]) == 'true':
                    break
                query_result = self.svc.queryMore(str(query_result[self.sf.queryLocator]))
            for con in contList:
                links = self.svc.query("select id,ContentDocumentid from ContentDocumentLink where LinkedEntityId = '"+str(con)+"' limit 1");
                if (links!=None and len(links)>0):
                    for link in links[self.sf.records:]:
                        writer.writerow({'Contac_ID': str(con), 'Document_ID': str(link[3]),'Document_Linked_ID': str(link[1])})
                        emNotes = {
                            'type' : 'Em_Note__c',
                            'Contact__c' : str(con),
                            'Name' : str(link[3])
                        }
                        results = self.svc.create(emNotes )
                        emNotesID= results[0]
                        contentDocumentLink = {
                            'type' : 'ContentDocumentLink',
                            'id' : str(link[1]),
                            'LinkedEntityId' : str(emNotesID)
                        }
                        self.svc.update(contentDocumentLink); # I guess the error is here

Please advice

Sumant Kuchipudi
September 05, 2018
Like
0

3 replies

How can I get dynamic YEAR and MONTH in SOQL?

Hi,
I have below SOQL clause with Static Year and Month, is it possible to have dynamic values in those fields?

(
  ( 
     ( YEAR__c=2016 and Month__c='July' )  or 
     ( YEAR__c=2016 and Month__c='August' ) or 
     ( YEAR__c=2016 and Month__c='September' ) or 
     ( YEAR__c=2016 and Month__c='October' ) or 
     ( YEAR__c=2016 and Month__c='November' ) or  
     ( YEAR__c=2016 and Month__c='December' ) or 
     ( YEAR__c=2017 and Month__c='January' ) or 
     ( YEAR__c=2017 and Month__c='February' ) or 
     ( YEAR__c=2017 and Month__c='March' ) or 
     ( YEAR__c=2017 and Month__c='April' ) or 
     ( YEAR__c=2017 and Month__c='May' ) or 
     ( YEAR__c=2017 and Month__c='June' )
  ) 
  OR YEAR__c=null
)
)

Sumant Kuchipudi
August 07, 2018
Like
0

3 replies

How to change a record's field dynamically when a new record with the same Type and RecordType matches?

I have BioRecord custom object which has Email, Phone, Status(picklist, Current, Former), Type (picklist, Home, Office, etc) and Record type (Phone and Email), we have integration that writes the data into this object. If a record is existed with a Type='Home' and recordtype='Phone' and if a new record comes with the same Type and same recordtype, I need to change the status of old record to 'Former'.
i'm guessting that I can do it in Trigger but is there any alternate way we can change the Status of the record?

Sumant Kuchipudi
August 02, 2018
Like
0

5 replies

Process builder not triggering on creating record.

I have a custom Address object, which has address fields, phone, and email fields. I'm wriging Process Builder on this object, with the following steps
1) Start the process, when a record created or edited
2) criteria.:
Criteria for Executing Actions: Formula Evaluates to True
The formula should be on fields (Street, City , state, zipcode), one of these created, edited only the Process should trigger but when I create with these its not triggering. below is the formula I'm using. Its working when edited the record.

AND(
 OR(
    AND(NOT(ISBLANK([Address__c].Street__c)),ISCHANGED([Address__c].Street__c)), 
    AND(NOT(ISBLANK([Address__c].State__c)),ISCHANGED([Address__c].State__c)), 
    AND(NOT(ISBLANK([Address__c].City__c)),ISCHANGED([Address__c].City__c)), 
    AND(NOT(ISBLANK([Address__c].ZipCode__c)),ISCHANGED([Address__c].ZipCode__c)), 
    AND(NOT(ISBLANK([Address__c].Country__c))ISCHANGED([Address__c].Country__c))
   )
)

Sumant Kuchipudi
July 27, 2018
Like
0

1 replies

how to show Attachment image on Public Site?

Hi,
I have a PUBLIC SITE (url=uploadphoto) which uploads image and stores into Attachment, but after file upload, need to display on page but not able to show.
I used the below URLs to display.

<img src="/uploadphoto/servlet/servlet.FileDownload?file={!attID}" style="height: 160px; width:200px;" />

or

<apex:image url="/uploadphoto/servlet/servlet.FileDownload?file={!attID}" style="height: 160px; width:200px;" />

If public sites will not have access to Attachment, can we call RemoteAction and get image string and show? how could we do that?

Please advice

Sumant Kuchipudi
June 07, 2018
Like
0