You need to sign in to do that
Don't have an account?
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.