function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Amit chaudharyAmit chaudhary 

Error :- "java.lang.OutOfMemoryError: Java heap space" in data loader CLI script

Hi

 

 

i am facing the following error when i am tryng to fetch data from the "sf_product" table.

 

C:\Program Files\salesforce.com\Apex Data Loader 19.0\bin\process.bat D:\SFDC_LANE7\conf UpsertMediaProduct 2012-11-02 02:30:13,124 INFO [main] controller.Controller initLog (Controller.java:391) - The log has been initialized 2012-11-02 02:30:13,139 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:78) - Loading process configuration from config file: D:\SFDC_LANE7\conf\process-conf.xml ........ 2012-11-02 02:30:19,124 INFO [UpsertMediaProduct] action.AbstractLoadAction execute (AbstractLoadAction.java:130) - Loading Using Bulk API: upsert 2012-11-02 02:30:19,124 INFO [UpsertMediaProduct] database.DatabaseContext setSqlParamValues (DatabaseContext.java:179) - SQL using parameter value process.lastRunDate = 2012-10-30 08:44:26.461 2012-11-02 02:30:19,233 INFO [UpsertMediaProduct] database.DatabaseContext setSqlParamValues (DatabaseContext.java:179) - SQL using parameter value process.lastRunDate = 2012-10-30 08:44:26.461 2012-11-02 02:30:19,327 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:214) - Unable to run process UpsertMediaProduct java.lang.OutOfMemoryError: Java heap space ECHO is off. ERRORLEVEL=-1

*******************************************************************

 

my query in database-conf.xml is following:- select column1,......,column N from SF_PRODUCTS WHERE ( ODS_CREATED_DATE > @process.lastRunDate@ OR ODS_LAST_UPDATED_DATE > @process.lastRunDate@ ) AND MATERIAL_TYPE LIKE'ZMF%'

*******************************************************************

Any one can help me how to solve this problem.