Hi Experts ,
I am extracting data from salesforce am getting virtual memory error and stops executing can you explian me what exactly it is and what i have to do to get rid of it thanks in advance
gsk1987 (BOB member since 2013-12-20)
Can you check whether the drives in the BODS server are full.
also can you provide the error screenshot.
pnr6kor (BOB member since 2014-05-14)
Hi Please see below
gsk1987 (BOB member since 2013-12-20)
Hi,
The Error shows that system is running low on virtual memory.
Then you need to check in your BODS server whether the logs(Drives) are full.
Contact your BODS Admin and ask him to check whether the Drives have enough space to load the jobserver logs.
Since, when the Logs are full the Server tries to use the systems virtual memory at that time.
so, it’s getting failed. Also check the logic of your code once. Since, if there are huge number of records in source how you are populating those records to the target i mean the logic that you have used from source to target.
go to below links for more inforamtion
Regards,
Prasna
pnr6kor (BOB member since 2014-05-14)
pnr6kor, I do not know about the issue you describe.
However, most of the time running out of memory is simply because of bad job design and not enough push down to the database.
Johannes Vink 
(BOB member since 2012-03-20)
okie… then you have to think of overcoming the Bad design(comples design) of job and also you have to optimize your job. 
pnr6kor (BOB member since 2014-05-14)
With SFDC you have to be really careful with the joins and WHERE clause expressions. Data Services can be very picky when it comes to pushing down the those items to SFDC. What is likely happening is that you aren’t pushing down enough of the expressions to SFDC so all the data is brought back to the job server when it is then joined/filtered.
eganjp 
(BOB member since 2007-09-12)