function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lakshmi PalnatiLakshmi Palnati 

Data Loader Error

Hi,
I am tryinng to use Data Loader command line via Server . 

But getting the below error: 

2015-10-05 15:09:33,868 ERROR [userUpsertProcess] action.AbstractAction handleEx
ception (AbstractAction.java:199) - Exception occured during loading
com.salesforce.dataloader.exception.LoadException: !DAORowUtil.errorLastRun!
        at com.salesforce.dataloader.util.DAORowUtil.handleError(DAORowUtil.java
:148)
        at com.salesforce.dataloader.util.DAORowUtil.skipRowToStartOffset(DAORow
Util.java:141)
        at com.salesforce.dataloader.action.AbstractLoadAction.initOperation(Abs
tractLoadAction.java:96)
        at com.salesforce.dataloader.action.AbstractAction.execute(AbstractActio
n.java:117)
        at com.salesforce.dataloader.controller.Controller.executeAction(Control
ler.java:120)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:149)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: java.io.FileNotFoundException: C:\VXConnectADPLoaderProd\conf\userUps
ertProcess_lastRun.properties (Access is denied)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at com.salesforce.dataloader.config.LastRun.save(LastRun.java:116)
        at com.salesforce.dataloader.config.Config.saveLastRun(Config.java:792)
        at com.salesforce.dataloader.util.DAORowUtil.skipRowToStartOffset(DAORow
Util.java:136)
        ... 6 more
2015-10-05 15:09:33,868 ERROR [userUpsertProcess] progress.NihilistProgressAdapt
er doneError (NihilistProgressAdapter.java:58) - !DAORowUtil.errorLastRun!
2015-10-05 15:09:33,868 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Unable to run process userUpsertProcess
java.lang.RuntimeException: java.io.FileNotFoundException: C:\VXConnectADPLoader
Prod\conf\userUpsertProcess_lastRun.properties (Access is denied)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:162)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: java.io.FileNotFoundException: C:\VXConnectADPLoaderProd\conf\userUps
ertProcess_lastRun.properties (Access is denied)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at java.io.FileOutputStream.<init>(Unknown Source)
        at com.salesforce.dataloader.config.LastRun.save(LastRun.java:116)
        at com.salesforce.dataloader.config.Config.saveLastRun(Config.java:792)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:154)
        ... 2 more
Press any key to continue . . .

Any suggestions?


 
dougmcintyredougmcintyre
Hi Lakshmi,

So this file named "userUpsertProcess_lastRun.properties" is either not available to be read or created which makes the entire process fail.

First question: In the file directory, can you find "C:\VXConnectADPLoader\Prod\conf\userUpsertProcess_lastRun.properties" and can the running user access this file on that server?

Second question:  is this the first time you have run this job? If so does the running user have access to write to this directory?

This is where I would start to double check that the running user has read/write access to the directory that is on the DataLoader is running from.

Hope this helps!
Doug