Data Inetgration in TOS hangs alot?

[Anonymous]

Hi,

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)

[cterenzi]

Run Tab, Advanced Settings.

[vharcq]

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" 

[Anonymous]

My updated Log4j settings looks like below.

Just add a new file appender (i.e. with 'class' of 'org.apache.log4j.FileAppender'), add reference to it at bottom in 'root' section, and comment the 'CONSOLE' appender so it stops crashing Studio).

if on Windows, UnxUtils has a 'tail' command you can use: http://unxutils.sourceforge.net/

=======================================================

<!-- CONSOLE appender -->
<appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern"
value="[%-5p]: %c - %m%n" />
</layout>
</appender>

<appender name="FILE" class="org.apache.log4j.FileAppender">
<param name="file" value="c:/log/studiojob.log" />
<param name="append" value="false" />
<param name="threshold" value="trace" />
<layout class="org.apache.log4j.PatternLayout">
<param name="ConversionPattern" value="%d{ISO8601} %-5p [%c{1}] - %m%n" />
</layout>
</appender>

<!-- Root Logger -->
<root>
<priority value ="warn"/>
<appender-ref ref="FILE"/>
<!-- <appender-ref ref="CONSOLE"/> -->
<!-- <appender-ref ref="LOGSTASH"/> -->
</root>

=======================================================