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.

The publish process seems to be successful but the data loader hangs for a long period of time while the publishing process completes.  It also doesn't tell you the interim number of successes/failures so you can determine how well the upload is working.  I'm using v17 of the data loader.  Once you cancel the operation, control will eventually return to the hanging app and the results are presented