Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
2

Questions
6

Replies

Data loader using command line- password issue

Hi Folks,

I'm trying to run an insert using Data loader with command line interface. Below is my command:

C:\Program Files\salesforce.com\Data Loader\bin>process.bat "C:\Program Files\Salesforce.com" accountInsert

Below is the output:

2013-08-22 12:45:14,402 INFO [main] controller.Controller initLog (Controller.java:382) - Reading log-conf.xml in C:\Program Files\salesforce.com\Data Loader\bin\log-conf.xml
2013-08-22 12:45:15,651 INFO [main] controller.Controller initLog (Controller.java:391) - The log has been initialized
2013-08-22 12:45:15,687 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: C:\program files\salesforce.com\process-conf.xml
2013-08-22 12:45:16,506 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [C:\program files\salesforce.com\process-conf.xml]
2013-08-22 12:45:16,708 INFO [accountInsert] controller.Controller initConfig (Controller.java:327) - config dir created at C:\program files\salesforce.com
2013-08-22 12:45:17,117 INFO [accountInsert] controller.Controller initConfig (Controller.java:355) - The controller config has been initialized
2013-08-22 12:45:17,150 INFO [accountInsert] process.ProcessRunner run (ProcessRunner.java:116) - Initializing process engine
2013-08-22 12:45:17,150 INFO [accountInsert] process.ProcessRunner run (ProcessRunner.java:119) - Loading parameters
2013-08-22 12:45:19,342 ERROR [accountInsert] config.Config decryptProperty (Config.java:692) - Error loading parameter: sfdc.password of type: java.lang.String
javax.crypto.BadPaddingException: Given final block not properly padded
at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA13*..)
at javax.crypto.Cipher.doFinal(DashoA13*..)
at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:210)
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:686)
at com.salesforce.dataloader.config.Config.postLoad(Config.java:638)
at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:664)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
2013-08-22 12:45:19,344 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process accountInsert
java.lang.RuntimeException: com.salesforce.dataloader.exception.ParameterLoadException: Error loading parameter: sfdc.password of type: java.lang.String
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:162)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.salesforce.dataloader.exception.ParameterLoadException: Error loading parameter: sfdc.password of type: java.lang.String
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:693)
at com.salesforce.dataloader.config.Config.postLoad(Config.java:638)
at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:664)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
... 2 more
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded
at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA13*..)
at javax.crypto.Cipher.doFinal(DashoA13*..)
at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:210)
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:686)
... 5 more

I first need to figure out the sfdc.password error. I am encrypting with encrypt.bat, and it is a concatenated value of my salesforce password + salesforce security token. I am under the impression this is how it should be encrypted.

Any advice would be greatly appreciated!

Thanks,

JR1204
August 22, 2013
Like
0

4 replies

Data Loader using command line password error

Hi Folks,

I'm trying to run an insert using Data loader with command line interface. Below is my command:

C:\Program Files\salesforce.com\Data Loader\bin>process.bat "C:\Program Files\Salesforce.com" accountInsert

JR1204
August 22, 2013
Like
0

4 replies

Data loader using command line- password issue

Hi Folks,

I'm trying to run an insert using Data loader with command line interface. Below is my command:

C:\Program Files\salesforce.com\Data Loader\bin>process.bat "C:\Program Files\Salesforce.com" accountInsert

Below is the output:

Any advice would be greatly appreciated!

Thanks,

JR1204
August 22, 2013
Like
0

4 replies

Data Loader using command line password error

Hi Folks,

I'm trying to run an insert using Data loader with command line interface. Below is my command:

C:\Program Files\salesforce.com\Data Loader\bin>process.bat "C:\Program Files\Salesforce.com" accountInsert

JR1204
August 22, 2013
Like
0

2 replies

Apex Data Loader Command Line Interface Problem

Hi,

I'm trying to setup a Apex Data Loader Command Line Interface process to extract data from the Lead object in Salesforce.com to a CSV file. I've created the process.config.xml file. When I run the command:

C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\bin>process "C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf" csvLeadExtract

I'm getting the following error: "No enum const class com.salesforce.dataloader.action.OperationInfo"

Here's my process.config bean:

<bean id="csvLeadExtract"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
      <description>csvLeadExtract job gets lead info from salesforce and saves info into a CSV file."</description>
        <property name="name" value="csvLeadExtract"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.debugMessagesFile" value="c:\dataloader\status\sfdcSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://test.salesforce.com"/>
                <entry key="sfdc.username" value="myadmin@mycompany.com"/>
                
                <entry key="sfdc.password" value="XXX_MY_ENCODED_PASSWORD_XXX"/>
  
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Lead"/>
                <entry key="sfdc.extractionRequestSize" value="500"/>
                <entry key="sfdc.extractionSOQL" value="Select Id, LastName, FirstName, XXXLOTS_OF_OTHER_FIELDSXXX FROM Lead WHERE CreatedDate >= 2011-08-01T01:02:03Z"/>
                <entry key="process.operation" value="extract"/>
                <entry key="process.mappingFile" value="c:\dataloader\conf\leadsExtractMap.sdl"/>
                <entry key="dataAccess.type" value="csvWrite"/>
                <entry key="dataAccess.name" value="c:\dataloader\data\leads.csv"/>
            </map>
        </property>
    </bean>

The full error reads:

2011-09-08 01:06:16,119 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:211) - Unable to run process null
java.lang.RuntimeException: java.lang.IllegalArgumentException: No enum const cl
ass com.salesforce.dataloader.action.OperationInfo.
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:136)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:74)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:226)
Caused by: java.lang.IllegalArgumentException: No enum const class com.salesforc
e.dataloader.action.OperationInfo.
        at java.lang.Enum.valueOf(Enum.java:192)
        at com.salesforce.dataloader.config.Config.getEnum(Config.java:441)
        at com.salesforce.dataloader.config.Config.getOperationInfo(Config.java:
981)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:97)

If anyone has input on this, or examples that I can follow, I'd much appreciate that! I'm a new at this so I'm probably doing something wrong.

Thanks!

Frank

Frankenstein
September 08, 2011
Like
0

4 replies

Error regarding Accounts extraction using CommandLine Data loader

Hello,

Can anyone of you please help me in resolving this issue.

When iam running a commandline dataloader to extract the Accounts iam getting the following error.

C:\Program Files\salesforce.com\Apex Data Loader 18.0\bin>process.bat "c:\progra
m files\salesforce.com\apex data loader 18.0\test\" csvAccountExtractProcess

Usage: java [-options] class [args...]
           (to execute a class)
   or java [-options] -jar jarfile [args...]
           (to execute a jar file)

where options include:
    -client       to select the "client" VM
    -server       to select the "server" VM
    -hotspot      is a synonym for the "client" VM [deprecated]
                  The default VM is client.

    -cp <class search path of directories and zip/jar files>
    -classpath <class search path of directories and zip/jar files>
                  A ; separated list of directories, JAR archives,
                  and ZIP archives to search for class files.
    -D<name>=<value>
                  set a system property
    -verbose[:class|gc|jni]
                  enable verbose output
    -version      print product version and exit
    -version:<value>
                  require the specified version to run
    -showversion print product version and continue
    -jre-restrict-search | -jre-no-restrict-search
                  include/exclude user private JREs in the version search
    -? -help      print this help message
    -X            print help on non-standard options
    -ea[:<packagename>...|:<classname>]
    -enableassertions[:<packagename>...|:<classname>]
                  enable assertions
    -da[:<packagename>...|:<classname>]
    -disableassertions[:<packagename>...|:<classname>]
                  disable assertions
    -esa | -enablesystemassertions
                  enable system assertions
    -dsa | -disablesystemassertions
                  disable system assertions
    -agentlib:<libname>[=<options>]
                  load native agent library <libname>, e.g. -agentlib:hprof
                    see also, -agentlib:jdwp=help and -agentlib:hprof=help
    -agentpath:<pathname>[=<options>]
                  load native agent library by full pathname
    -javaagent:<jarpath>[=<options>]
                  load Java programming language agent, see java.lang.instrument

Iam having Apex dataLoader of 18.0 version and JRE SE v1.4.2_19.

Can any one of you know how to resolve this issue.

Thankyou ..

Carol

lovecrm
April 07, 2010
Like
0