i am using Windows 7, 64 bit machine. I have increased the JRM paramters of memory space to **2046M**. Still after few hours, the system hangs alot.
Could anyone explain what is the reason?
(I am doing no database work, only reading from Excel files and string in Excel files.)
Any good suggestions, much appreciated! (Below is screenshot how clicking an icon make the whole tool stuck for minuetes 15 or 20)
There are many reasons, but one of most resent problems with studio - it is error log (tLogRow and other output)
like, if looking for Your picture:
possible to think - this is for each row in Your flow. If it true - it is exactly source of problem
Why - I can not answer, but can surely confirm - big number of output rows hang Talend always
hang - in best case, in worst it will be crashed
there 2 cases:
1) if it tLogRow and number of rows more than "few" - better to change tLogRow by tFileOutputDelimited - work fast and not eat memory
2) but if it result of errors - for example for each row return warning about wrong format or similar ... this is possible to fix only by resolving source of problem
Classic problem indeed, the "Console" in "Run job" view is a full memory component
WIth too much data it just died (and kill the whole studio)
You need to tick the "Line limit" and choose a max number of line during your test run
If you really need more data when you debug, you could try a new Log4j FILE appender to a file in "File / Edit Project Properties / Log4j"