Salesforce Developer Community

Eittay Basly 15
NEWBIE
10 Points
Member since 2021

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
3

Questions
1

Replies

Dataloader Command Line Error on Extraction

Hello Everyone,

I am attempting to export fields from the contacts object through the DataLoader command line. I have created the xml file and sdl file for the mapping. I am getting the following response from the command line interface:

C:\Users\ebasly00\dataloader\v57.0.1\bin>process C:\Users\ebasly00\dataloader\v57.0.1\samples\conf contactExtractAttemptTwo-conf
Data Loader requires Java JRE 11 or later. Checking if it is installed...
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2023-03-24 14:02:19,096 INFO  [main] controller.Controller _doInitializeLog (Controller.java:402) - The log has been initialized
2023-03-24 14:02:19,100 INFO  [main] process.ProcessRunner getInstance (ProcessRunner.java:319) - Initializing process engine
2023-03-24 14:02:19,100 INFO  [main] process.ProcessRunner getInstance (ProcessRunner.java:334) - process.nameis specified in the command line. Loading DynaBean with id contactExtractAttemptTwo-conf from process-conf.xml located in directory C:\Users\ebasly00\dataloader\v57.0.1\samples\conf
2023-03-24 14:02:19,103 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:106) - Loading process configuration from config file: C:\Users\ebasly00\dataloader\v57.0.1\samples\conf\process-conf.xml
2023-03-24 14:02:19,204 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:98) - Error loading process: contactExtractAttemptTwo-conf configuration from config file: C:\Users\ebasly00\dataloader\v57.0.1\samples\conf\process-conf.xml
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'contactExtractAttemptTwo-conf' available
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:874) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:339) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:285) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:78) ~[dataloader-57.0.1-uber.jar:?]
2023-03-24 14:02:19,209 FATAL [main] process.ProcessRunner logErrorAndExitProcess (ProcessRunner.java:245) - Unable to run process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: contactExtractAttemptTwo-conf configuration from config file: C:\Users\ebasly00\dataloader\v57.0.1\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:99) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:339) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:285) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:78) ~[dataloader-57.0.1-uber.jar:?]
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'contactExtractAttemptTwo-conf' available
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:874) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1344) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:309) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[dataloader-57.0.1-uber.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) ~[dataloader-57.0.1-uber.jar:?]
        ... 3 more
2023-03-24 14:02:19,212 FATAL [main] process.ProcessRunner logErrorAndExitProcess (ProcessRunner.java:245) - Unable to run process
java.lang.RuntimeException: Error loading process: contactExtractAttemptTwo-conf configuration from config file: C:\Users\ebasly00\dataloader\v57.0.1\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessRunner.logErrorAndExitProcess(ProcessRunner.java:246) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:301) ~[dataloader-57.0.1-uber.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:78) ~[dataloader-57.0.1-uber.jar:?]
Exception in thread "main" java.lang.RuntimeException: Error loading process: contactExtractAttemptTwo-conf configuration from config file: C:\Users\ebasly00\dataloader\v57.0.1\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessRunner.logErrorAndExitProcess(ProcessRunner.java:246)
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:80)

Sample xml file:

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<bean id="csvContactExtractProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          scope="prototype">
      <description>"csvContactExtract job gets contact info from salesforce and saves info into a CSV file."</description>
        <property name="name" value="csvContactExtractProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\sfdcSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="XXX"/>
                <entry key="sfdc.username" value="XXX"/>
                <!-- password specified below is invalid, please generate one using the encrypt.bat utility -->
                <entry key="sfdc.password" value="XXX"/>
                <entry key="process.encryptionKeyFile" value="C:\Users\ebasly00\.dataloader\dataLoader.key"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="50"/>
                <entry key="sfdc.entity" value="Contact"/>
                <entry key="sfdc.extractionRequestSize" value="500"/>
                <entry key="sfdc.extractionSOQL" value="Select FirstName, LastName, AccountId, Title, Contact_Role_Type__c, Email, HasOptedOutOfEmail, Email_Opt_Out_Date__c FROM Contact"/>
                <entry key="process.operation" value="extract"/>
                <entry key="process.mappingFile" value="c:\dataloader\samples\conf\contactExtractMap.sdl"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="c:\dataloader\samples\data\dailyContactextract.csv"/>
            </map>
        </property>
    </bean>

Appreciate your help!!!

Eittay Basly 15
March 24, 2023
Like
0

SOLVED

2 replies

Help with Trigger on Custom Object

Hi there,

I am trying to save this trigger after I added a condition for the Account__c filed (line 13). Unfortunately, I am getting the following 2 errors:

#1. Error: Compile Error: Duplicate variable: obj at line 13 column 31
#2 Error: Compile Error: Duplicate variable: obj at line 20 column 39

1	trigger TriggerOnAcquiredLead on Purchased_Data__c (before insert, after insert) { 
2	    
3	    If(Trigger.isBefore && Trigger.isInsert){
4	    
5	    for(Purchased_Data__c obj :trigger.new){
6	    if(obj.Account__c != null){
7	        continue;
8	    }else{
9	        List<Purchased_Data__c> NewRecs = new List<Purchased_Data__c>();
10	        Map<string,Purchased_Data__c> VersionMap = new Map<string,Purchased_Data__c>();
11	        set<String> LenderCodes = new set<String>();
12	        
13	        for(Purchased_Data__c obj :trigger.new){
14	            LenderCodes.add(obj.Lender_Code__c);
15	        }
16	        system.debug('Lender codes are '+LenderCodes);
17	        if(!LenderCodes.isEmpty()){
18	            List<Purchased_Data__c> TempLst = [select Id,Name,Lender_Code__c,Version__c,CreatedDate from Purchased_Data__c where Lender_Code__c =:LenderCodes];
19	            if(!TempLst.isEmpty()){
20	                for(Purchased_Data__c obj: TempLst){
21	                    Purchased_Data__c TempObj = new Purchased_Data__c();
22	                    if(VersionMap.containsKey(obj.Lender_Code__c)){
23	                        TempObj = VersionMap.get(obj.Lender_Code__c);
24	                        if(obj.createddate > TempObj.createddate){
25	                            VersionMap.put(obj.Lender_Code__c,obj);
26	                        }
27	                    }else{
28	                        VersionMap.put(obj.Lender_Code__c,obj);
29	                    }
30	                }    
31	            }
32	            system.debug('Version Mapping is '+VersionMap);
33	            /*for(string Lcode: LenderCodes){
34	                system.debug('Current Lender code is '+Lcode);
35	                for(Purchased_Data__c obj:[select Id,Name,Lender_Code__c,Version__c,CreatedDate from Purchased_Data__c where Lender_Code__c =:Lcode ORDER BY createddate DESC Limit 1]){
36	                    system.debug('Purchased date record is '+obj);
37	                    VersionMap.put(obj.Lender_Code__c,obj);
38	                }    
39	            }*/
40	            //Now update the version numbers
41	            for(Purchased_Data__c pd: trigger.new){
42	                system.debug('New record is '+pd);
43	                if(string.isNotBlank(pd.Lender_Code__c) && VersionMap.containsKey(pd.Lender_Code__c)){
44	                    string[] tempV = VersionMap.get(pd.Lender_Code__c).Version__c.split(' ');
45	                    Integer temp = Integer.valueOf(tempV[1]);
46	                    temp = temp + 1;
47	                    pd.Version__c = 'Version '+temp;
48	                }else{
49	                    //Set Lender Code as Version 1
50	                    pd.Version__c = 'Version 1';
51	                }
52	            }    
53	        }
54	    }
55	    }
56	}
57	    
58	       
59	   
60	    //To Trigger when Acquired Lead is Created
61	    if(Trigger.isAfter && Trigger.isInsert){
62	       UpsertAcquriedLead.checkAccAndLead(Trigger.newmap.keySet());
63	    }
64	}

Thank you!

Eittay Basly 15
November 23, 2021
Like
0

1 replies

CPU Limit Exceeded

Hello all,

My org heavily relies on a few processes on the process builder. Most processes are built on the account object. We have been getting these errors due to our Salesforce to Salesforce connection. In short data is passed from one org to ours and triggers these processes on the process builder. Some records have no issues, but some are triggering the timeout error:

Error Occurred: The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: Apex CPU time limit exceeded. You can look up ExceptionCode values in the SOAP API Developer Guide.---The flow tried to update these records: null.

I sincerely appreciate your support.

Eittay Basly 15
October 15, 2021
Like
0