-
ChatterFeed
-
0Best Answers
-
0Likes Received
-
0Likes Given
-
3Questions
-
1Replies
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:
Sample xml file:
Appreciate your help!!!
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
- Continue reading or reply
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
- Continue reading or reply
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
- Continue reading or reply
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
- Continue reading or reply