Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Out of Memory Error exporting to Excel - 8GB RAM

Hi,
We are experiencing problems to get to export a table from SQL Server to Excel 2007. Our table has about 40k rows and 8 columns and when we try to export to excel, always crash with error "Out of memory Error ".
Our machine has 8GB RAM; if we do it through SSIS (Sql Server Integration Services) the process run successfully in a few seconds, why we can't get it with Talend?
We're using the following config for Run/Debug (modified on Preferences > Talend > Run/Debug):
-Xms1024M
-Xmx6144M
Any idea?
Thanks
Labels (2)
13 Replies
Anonymous
Not applicable
Author

Which Release do you use?
The commandline is an "ongoing" problem child.
Please ensure the path you have given to the commandline contains the directories of the components.
Here the way to reset the commandline and force it to run correctly.
Please stop your commandline (and take care the commandline is REALLY stopped by checking the process list of your OS.
Now delete EVERYTHING in the commandline-workspace.
Start the commandline again.
The next generation run checks out the complete repository and recreates important - and often corrupted - directories (.JETEmitters and .Java).
I would love it to have a Java standard build system like Maven or ANT ! The crap commandline is always a reason for trouble and works never reliable.
Anonymous
Not applicable
Author

Hi jlolling, we're using 5.2.1
In our commandline's workspace only appears a folder named ".JETEmitters"; should we delete it to check your suggestion? (i think that its a system folder of talend)
Cheers
Anonymous
Not applicable
Author

Yes, with everything, I mean also this folder!
Anonymous
Not applicable
Author

HI jlolling, i got it!!
Thanks you very much. The solution was delete all content of the commandline's workspace.
Thanks again
Cheers