Data_Summary_Object_Record_Page: Component [force:highlightsPanel] attribute [actionNames]: We couldn't validate Quick Action LeftProp_DSS__Data_Summary__c.Run_Summary_Now

• I started with a backup of the old system that included all files, etc.  (checked both “Include images, documents, and attachments” and “Include Salesforce Files and Salesforce CRM Content document versions”)
• This generated 218 zip files.  I’ve downloaded and extracted all to my local machine
• I’ve moved all files from the ContentVersion folders in each zip to a single folder to ease uploading.
• This folder had 524k files, all named with a salesforce id that starts with 068 (which are ContentVersion records).  Sampling them, they’re a combination of short notes and scanned documents.

• Roughly 19k ContentVersion records and the same number of ContentDocument records
• 18k FeedAttachment records
• 682 ContentNote records

{
  "data": [
    {
      "created_at": "2021-06-12T00:00:01.000Z",
      "id": "1403502310429392901",
      "text": "She means business \uD83D\uDC69\uD83C\uDFFD‍⚖️ Gugu Mbatha-Raw is Judge Renslayer in Marvel Studios' #Loki. Stream new episodes of the Original Series every Wednesday on @DisneyPlus. https://t.co/IwpY2eUvwd"
    } ]
}

// Generated by JSON2Apex http://json2apex.herokuapp.com/
public class Twitter_TimelineParser {
    public class Data {
        public String created_at;
        public String id;
        public String text;
    }
    
    public static Twitter_TimelineParser parse(String json) {
        return (Twitter_TimelineParser) System.JSON.deserialize(json, Twitter_TimelineParser.class);
    }
}

id templateID='00X1R000000f3T1UAI';
Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
mail.setTemplateId(templateID);
Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });

• The code has 100% coverage in the sandbox with no errors
• Even when deploying from a brand new sandbox I get the error.
• There are no batch calls in the code

trigger TaskTrigger on Task (before insert, before update, before delete, after insert, after update, after delete, after undelete) {
 
    if (trigger.isAfter && trigger.isInsert) {
        TaskHandler.evaluateTasks(trigger.new);
    }
}

public with sharing class TaskHandler {
    // public TaskHandler() {  }
 
    public static void evaluateTasks(list<task> newTasks){
        set<string> didNums = new set<string>();
        set<id> leadIDs = new set<id>();
        for (task t : newTasks){
            if ( string.isNotBlank(t.Dialpad__PhoneNumber__c) ) {
                didNums.add( LeadSourceHandler.scrubber(t.Dialpad__PhoneNumber__c) );
            }
            if ( string.isNotBlank(t.WhoID) ) leadIDs.add(t.WhoID);
        }
        map<string, string> LeadSources = getLeadSources(didNums);
        set<id> LeadsInNeed = getLeadIDs(leadIDs);
       
        list<lead> leadsToUpdate = new list<lead>();
        list<Lead_Source__c> newLeadSources = new list<Lead_Source__c>();
        for (task t : newTasks){
            string didNum = LeadSourceHandler.scrubber(t.Dialpad__PhoneNumber__c);
 
            if ( LeadsInNeed.contains(t.WhoID) ){
                if ( LeadSources.containsKey( didNum ) ) {
                    leadsToUpdate.add( new Lead(id=t.WhoID, LeadSource = LeadSources.get( didNum ) ) );
                } else {
                    newLeadSources.add( new Lead_Source__c(name = t.Dialpad__PhoneNumber__c ) );
                }
            }
        }
 
        if( leadsToUpdate != null && leadsToUpdate.size() > 0 ) update leadsToUpdate;
        if( newLeadSources != null && newLeadSources.size() > 0 ) insert newLeadSources; // save new ones
    }
 
    public static set<id> getLeadIDs(set<id> leadIDs){
        map<id, lead> leadsInNeed = new map<id, lead>([select id from lead where LeadSource = null and id in :leadIDs]);
        return leadsInNeed.keySet();
    }
 
   
    public static map<string, string> getLeadSources(set<string> didNums){
        map<string, string> m = new map<string, string>();
        for (Lead_Source__c ls : [select name, lead_source__c from Lead_Source__c where name in :didNums and Lead_Source__c != null]){
            m.put(ls.name, ls.Lead_Source__c);
        }
        return m;
    }
}

@isTest
private class TaskHandler_test {
    // private TaskHandler_test() {  }
 
    @isTest static void AssignLeadSourcesPrimary_test(){
        insert new Lead_Source__c(name='1234', lead_source__c='source 1');
 
        lead l1 = new lead(lastname='lead 1', Language__c='English', Location__c='Los Angeles');
        lead l2 = new lead(lastname='lead 2', Language__c='English', Location__c='Los Angeles');
        insert new list<lead>{l1, l2};
 
        task t1 = new task(subject='task 1', whoID=l1.id, activitydate=date.today(), Dialpad__PhoneNumber__c='1234');
        task t2 = new task(subject='task 2', whoID=l2.id, activitydate=date.today(), Dialpad__PhoneNumber__c='47');
        insert new list<task>{t1, t2};
    }
 
}

SELECT id, name FROM Account
WHERE name = 'whatever' OR id IN ( SELECT accountID FROM contact WHERE lastname = 'something' )

MALFORMED_QUERY: Semi join sub-selects are not allowed with the 'OR' operator

Query A: 
SELECT id FROM Account
WHERE id IN ( SELECT accountID FROM contact WHERE lastname = 'something' )

Query B:
SELECT id, name FROM Account WHERE name = 'whatever'

1. Make the batch class stateful and in the init store the results of Query B to a map.
2. Make Query A the one returned by the batch start() method.  
3. In the execute() method, process the scope (from query A) and as all records from the map of query B as they're processed.
4. In the finish() method process records that remain in the map of query B after all query A results handled in the batches.

• 1 and 2 work and yield the same result, as you’d expect
• 3 works perfectly
• 4 errors with: "Invalid field Contacts for Account"

list<account> aa = [SELECT name, ( SELECT name FROM Contacts ) FROM Account];
for (account a : aa) {
    system.debug('-- 1: '+a.name);
    system.debug('-- 2: '+a.get('name'));
    system.debug('-- 3: '+a.contacts);
    system.debug('-- 4: '+a.get('Contacts'));  // errors out
}

<apex:page controller="GenerateRouteSheets" deferLastCommandUntilReady="true" renderAs="PDF" applyBodyTag="false" action="{!loadData}">
	<!-- <apex:page controller="GenerateRouteSheets" deferLastCommandUntilReady="true" renderAs="PDF" applyBodyTag="false" > -->
	<head>
		<style>
			@page{
			size: landscape;
			@bottom-right {
			font-family: 'Arial Unicode MS';
			font-size: 13px;
			content:  "Page " counter(page) " of " counter(pages);
			}
			} 
		</style>
	</head>
	<script>
	    var dt = new Date();
	    document.getElementById("datetime").innerHTML = dt.toLocaleString();
	</script>
	<body>
		<apex:pageBlock >
			<apex:repeat value="{!routes}" var="r">
				<div style="page-break-after:always;  ">
                    Route {!r}
                    ~~ SNIP ~~
                </div>
			</apex:repeat>
		</apex:pageBlock>
	</body>
</apex:page>

17:08:30.275 sfdx force:project:create --projectname Eden-tncDev --outputdir /Users/Steve/Dev/sfdx --template standard
ERROR running force:project:create:  Command failed with ENOENT: npm root -g --prefix /Users/Steve/Dev/sfdx/.yo-repository --loglevel error
spawnSync npm ENOENT
17:08:30.696 sfdx force:project:create --projectname Eden-tncDev --outputdir /Users/Steve/Dev/sfdx --template standard
 ended with exit code 1

if(trigger.isAfter && trigger.isUpdate){
  set<id> needsUpdate = new set<id>();
  for (account is : trigger.new){
   account was = trigger.oldMap.get(is.id);
   if( is.billinglatitude != was.billinglatitude || is.billinglongitude != was.billinglongitude)   needsUpdate.add(is.id);
  }
  // call to update the distance
}

public class1 {
    public static void methodA() {
    };
}

public class2 {
   public static void methodRunner(string methodName) {
      run( class1.methodName() );  // call that would execute the method (TBD)
   }
}

class2.methodRunner( class1.methodA );

• The code has 100% coverage in the sandbox with no errors
• Even when deploying from a brand new sandbox I get the error.
• There are no batch calls in the code

trigger TaskTrigger on Task (before insert, before update, before delete, after insert, after update, after delete, after undelete) {
 
    if (trigger.isAfter && trigger.isInsert) {
        TaskHandler.evaluateTasks(trigger.new);
    }
}

public with sharing class TaskHandler {
    // public TaskHandler() {  }
 
    public static void evaluateTasks(list<task> newTasks){
        set<string> didNums = new set<string>();
        set<id> leadIDs = new set<id>();
        for (task t : newTasks){
            if ( string.isNotBlank(t.Dialpad__PhoneNumber__c) ) {
                didNums.add( LeadSourceHandler.scrubber(t.Dialpad__PhoneNumber__c) );
            }
            if ( string.isNotBlank(t.WhoID) ) leadIDs.add(t.WhoID);
        }
        map<string, string> LeadSources = getLeadSources(didNums);
        set<id> LeadsInNeed = getLeadIDs(leadIDs);
       
        list<lead> leadsToUpdate = new list<lead>();
        list<Lead_Source__c> newLeadSources = new list<Lead_Source__c>();
        for (task t : newTasks){
            string didNum = LeadSourceHandler.scrubber(t.Dialpad__PhoneNumber__c);
 
            if ( LeadsInNeed.contains(t.WhoID) ){
                if ( LeadSources.containsKey( didNum ) ) {
                    leadsToUpdate.add( new Lead(id=t.WhoID, LeadSource = LeadSources.get( didNum ) ) );
                } else {
                    newLeadSources.add( new Lead_Source__c(name = t.Dialpad__PhoneNumber__c ) );
                }
            }
        }
 
        if( leadsToUpdate != null && leadsToUpdate.size() > 0 ) update leadsToUpdate;
        if( newLeadSources != null && newLeadSources.size() > 0 ) insert newLeadSources; // save new ones
    }
 
    public static set<id> getLeadIDs(set<id> leadIDs){
        map<id, lead> leadsInNeed = new map<id, lead>([select id from lead where LeadSource = null and id in :leadIDs]);
        return leadsInNeed.keySet();
    }
 
   
    public static map<string, string> getLeadSources(set<string> didNums){
        map<string, string> m = new map<string, string>();
        for (Lead_Source__c ls : [select name, lead_source__c from Lead_Source__c where name in :didNums and Lead_Source__c != null]){
            m.put(ls.name, ls.Lead_Source__c);
        }
        return m;
    }
}

@isTest
private class TaskHandler_test {
    // private TaskHandler_test() {  }
 
    @isTest static void AssignLeadSourcesPrimary_test(){
        insert new Lead_Source__c(name='1234', lead_source__c='source 1');
 
        lead l1 = new lead(lastname='lead 1', Language__c='English', Location__c='Los Angeles');
        lead l2 = new lead(lastname='lead 2', Language__c='English', Location__c='Los Angeles');
        insert new list<lead>{l1, l2};
 
        task t1 = new task(subject='task 1', whoID=l1.id, activitydate=date.today(), Dialpad__PhoneNumber__c='1234');
        task t2 = new task(subject='task 2', whoID=l2.id, activitydate=date.today(), Dialpad__PhoneNumber__c='47');
        insert new list<task>{t1, t2};
    }
 
}

SELECT id, name FROM Account
WHERE name = 'whatever' OR id IN ( SELECT accountID FROM contact WHERE lastname = 'something' )

MALFORMED_QUERY: Semi join sub-selects are not allowed with the 'OR' operator

Query A: 
SELECT id FROM Account
WHERE id IN ( SELECT accountID FROM contact WHERE lastname = 'something' )

Query B:
SELECT id, name FROM Account WHERE name = 'whatever'

1. Make the batch class stateful and in the init store the results of Query B to a map.
2. Make Query A the one returned by the batch start() method.  
3. In the execute() method, process the scope (from query A) and as all records from the map of query B as they're processed.
4. In the finish() method process records that remain in the map of query B after all query A results handled in the batches.

• 1 and 2 work and yield the same result, as you’d expect
• 3 works perfectly
• 4 errors with: "Invalid field Contacts for Account"

list<account> aa = [SELECT name, ( SELECT name FROM Contacts ) FROM Account];
for (account a : aa) {
    system.debug('-- 1: '+a.name);
    system.debug('-- 2: '+a.get('name'));
    system.debug('-- 3: '+a.contacts);
    system.debug('-- 4: '+a.get('Contacts'));  // errors out
}

<apex:page controller="GenerateRouteSheets" deferLastCommandUntilReady="true" renderAs="PDF" applyBodyTag="false" action="{!loadData}">
	<!-- <apex:page controller="GenerateRouteSheets" deferLastCommandUntilReady="true" renderAs="PDF" applyBodyTag="false" > -->
	<head>
		<style>
			@page{
			size: landscape;
			@bottom-right {
			font-family: 'Arial Unicode MS';
			font-size: 13px;
			content:  "Page " counter(page) " of " counter(pages);
			}
			} 
		</style>
	</head>
	<script>
	    var dt = new Date();
	    document.getElementById("datetime").innerHTML = dt.toLocaleString();
	</script>
	<body>
		<apex:pageBlock >
			<apex:repeat value="{!routes}" var="r">
				<div style="page-break-after:always;  ">
                    Route {!r}
                    ~~ SNIP ~~
                </div>
			</apex:repeat>
		</apex:pageBlock>
	</body>
</apex:page>

17:08:30.275 sfdx force:project:create --projectname Eden-tncDev --outputdir /Users/Steve/Dev/sfdx --template standard
ERROR running force:project:create:  Command failed with ENOENT: npm root -g --prefix /Users/Steve/Dev/sfdx/.yo-repository --loglevel error
spawnSync npm ENOENT
17:08:30.696 sfdx force:project:create --projectname Eden-tncDev --outputdir /Users/Steve/Dev/sfdx --template standard
 ended with exit code 1

<aura:component implements="force:lightningQuickActionWithoutHeader">
    <aura:handler name="init" value="{!this}" action="{!c.dismissIt}" />
</aura:component>

dismissIt : function(component, event, helper) {
        var wasDismissed = $A.get("e.force:closeQuickAction").fire(); 
    }

for(id opp : opps.keySet()){
  id dg = opps.get(opp);
  if (templates.containsKey(dg) ) {
    list<npsp__Allocation__c> thisTemplate = templates.get(dg);
    for (npsp__Allocation__c t : thisTemplate) {
      t.npsp__Opportunity__c = opp;
      toInsert.add(t);
      system.debug('added: '+toInsert[toInsert.size()-1].npsp__Opportunity__c);  // << #1
    }
  }
}
 
system.debug('------------------ ');
for (npsp__Allocation__c a : toInsert ) system.debug(a.npsp__Opportunity__c);   // << #2

public class1 {
    public static void methodA() {
    };
}

public class2 {
   public static void methodRunner(string methodName) {
      run( class1.methodName() );  // call that would execute the method (TBD)
   }
}

class2.methodRunner( class1.methodA );

Trapdoor is awesome but I do have some things that I wish I could control or fix.

1.) Duplicate URL.

I entered a URL into my list of servers as http://www.salesforce.com/login and then again as http://www.salesforce.com/login/

Trapdoor lists these as 2 distinct servers but if I delete one in order to correct it, Trapdoor deletes the other server in the list too.

I wish I could manually edit the list of servers and login details so that I could correct my typo.

2.) Sorting

I see that there is a "sort by alias" option but I don't see this working as expected.

If I had access to the list of servers ( see 1 above ) I would be happy to manually edit and order my servers.

Thanks !!

Hi guys,

today I received a strange error message after trying to change the controller in the visualforce editor

Error: java.sql.SQLException: ORA-00001: unique constraint (CORE.AKAPEX_CLASS) violated ORA-06512: at "HAPPY.CAPEX", line 505 ORA-06512: at line 1 : {call cApex.update_class(?,?,?,?,?,?,?,?,?,?,?,?)})} 

and remebered about a Blog article on Wes's Blog about strange error messages where I found this

Error: java.sql.SQLException: ORA-00001: unique constraint (CORE.AKAPEX_CLASS) violated ORA-06512: at “SNEEZY.CAPEX”, line 505 ORA-06512: at line 1 : {call cApex.update_class(?,?,?,?,?,?,?,?,?,?,?,?)})} 

.

Looks like some SF guys are huge fans 'Snow White and the Seven Dwarfs' .

So the big question is, where are the others and of course where's Snow White?