+ Start a Discussion
DSIDSI 

APEX 22.0 Data Loader - Command line interface

Hello,

 

I've been having problems with the last few versions of the APEX data loader.  I use the command line interface from Windows 7.  The last time it worked properly was with APEX 17.0.  I missed APEX 18, 19, 20, but when I downloaded and used APEX 21 (and now also 22) with the same batch file, I get a bunch of debug messages that did not occur when I was using APEX 17.0.  The debug messages do not appear to be affecting the ability of data to load properly, however my output files are huge.  Here's an example of some of the DEBUG messages:

 

C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit>..\_jvm\bin\java.exe -cp ..\DataLoader.jar -Dsalesforce.config.dir="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit" com.salesforce.dataloader.process.ProcessRunner process.name="StuPeriodExportProcess"
0 [main] INFO com.salesforce.dataloader.process.ProcessConfig  - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml
37 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Loading XML bean definitions from file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml]
39 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader  - Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl@1f42b49]
60 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  - Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and system ID [http://www.springframework.org/dtd/spring-beans.dtd]
60 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  - Trying to locate [spring-beans.dtd] in Spring jar
63 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  - Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpath
166 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser  - Loading bean definitions
170 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser  - Default lazy init 'false'
170 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser  - Default autowire 'no'
170 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser  - Default dependency check 'none'
175 [main] INFO org.springframework.core.CollectionFactory  - JDK 1.4+ collections available
184 [main] INFO org.springframework.core.CollectionFactory  - Commons Collections 3.x available
185 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
189 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
190 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
191 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
192 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
193 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
195 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
195 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
196 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
198 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
199 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
200 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
201 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
202 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
205 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
205 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
206 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
207 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
208 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
208 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
209 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
210 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
211 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
211 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
212 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
213 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
213 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
215 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
215 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
215 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
216 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
216 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
217 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
217 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
218 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
218 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
219 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
219 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
221 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
221 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
224 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
227 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
227 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
227 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
228 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
228 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
228 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
229 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
229 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
229 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
230 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
232 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
232 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
233 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
234 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
235 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
235 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
235 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
236 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
237 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
238 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
239 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
239 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
239 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
240 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionParser  - Found 84 <bean> elements in file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml]
241 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Creating instance of bean 'StuPeriodExportProcess' with merged definition [Root bean: class [com.salesforce.dataloader.process.ProcessRunner]; abstract=false; singleton=false; lazyInit=false; autowire=0; dependencyCheck=0; initMethodName=null; destroyMethodName=null; factoryMethodName=null; factoryBeanName=null; defined in file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\Summit\process-conf.xml]]
242 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invoking BeanPostProcessors before instantiation of bean 'StuPeriodExportProcess'
273 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Getting BeanInfo for class [com.salesforce.dataloader.process.ProcessRunner]
277 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Caching PropertyDescriptors for class [com.salesforce.dataloader.process.ProcessRunner]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found property 'class' of type [java.lang.Class]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found property 'configOverrideMap' of type [java.util.Map]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found property 'controller' of type [com.salesforce.dataloader.controller.Controller]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found property 'name' of type [java.lang.String]
278 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Class [com.salesforce.dataloader.process.ProcessRunner] is cache-safe
281 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.util.LinkedHashMap]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - About to invoke write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setName(java.lang.String)] on object of class [com.salesforce.dataloader.process.ProcessRunner]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - Invoked write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setName(java.lang.String)] with value of type [java.lang.String]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - About to invoke write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setConfigOverrideMap(java.util.Map)] on object of class [com.salesforce.dataloader.process.ProcessRunner]
282 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - Invoked write method [public synchronized void com.salesforce.dataloader.process.ProcessRunner.setConfigOverrideMap(java.util.Map)] with value of type [java.util.Map]
282 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invoking BeanPostProcessors before initialization of bean 'StuPeriodExportProcess'
282 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invoking afterPropertiesSet() on bean with name 'StuPeriodExportProcess'
282 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invoking BeanPostProcessors after initialization of bean 'StuPeriodExportProcess'


I'm using the log-conf and config.properties files that come with as samples.  Specifically, my log-conf is as follows:

 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration>
    <appender name="fileAppender" class="org.apache.log4j.RollingFileAppender">
        <param name="File"   value="${java.io.tmpdir}/sdl.log" />
        <param name="Append" value="true" />
        <param name="MaxFileSize" value="100KB" />
        <param name="MaxBackupIndex" value="1" />
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>       
    </appender>
    <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern"
                   value="%d %-5p [%t] %C{2} %M (%F:%L) - %m%n"/>
        </layout>       
    </appender>
   
    <category name="org.apache.log4j.xml">
        <priority value="warn" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </category>
   
    <logger name="org.apache" >
            <level value ="warn" />
    </logger>
   
    <root>
        <priority value ="info" />
        <appender-ref ref="fileAppender" />
        <appender-ref ref="STDOUT" />
    </root>
</log4j:configuration>


and my config.properties file is:

 

#Loader Config
#Thu Sep 10 09:37:47 PDT 2009
sfdc.endpoint=https://login.salesforce.com


 

Can anyone tell me how to get rid of these?

 

 

Best Answer chosen by Admin (Salesforce Developers) 
DSIDSI

Figured it out... I failed to copy the sample log-conf to the same directory as process-conf.  The log-conf file is where log4j parameter is set to "warn".