ETL Service stopped transfering chunks

[LB]

My ETL Service stopped transfering chunks (data are still collected by DataSourcer which I can see in DMA). A piece of ETL Service log file is attached below:

ETL_Trans_Only: Stack Trace:
ETL_Trans_Only: java.lang.OutOfMemoryError
ETL_Trans_Only: <<no stack trace available>>
ETL_Trans_Only: 03/01/15 00:18:11.734 GMT+01:00 66846720 SrcChunkDataMonitor#0 for src#GENP@7905810 EXCEPT Exception happend: [ExcptMsg: null]
ETL_Trans_Only: Stack Trace:
ETL_Trans_Only: java.lang.OutOfMemoryError
ETL_Trans_Only: <<no stack trace available>>
ETL_Trans_Only: 03/01/15 00:18:11.734 GMT+01:00 66846720 SrcChunkDataMonitor#0 for src#GENP@7905810 EXCEPT SrcChunkDataMonitor#0 for src#GENP: unable to execute command: 5. Got message: SrcChunkDataMonitor#0 for src#GENP: unable to read chunk's data from: DatabaseAccessPoint[ name:src#GENP, ConnectObject[ url:jdbc:oracle:thin:@GENPRD01:1521:GENPRD01, user: genesys, pass: ***** ] ] (table: OL_DATA121) [null]. Will try againg after: 300000 millis.[ExcptMsg: SrcChunkDataMonitor#0 for src#GENP: unable to read chunk's data from: DatabaseAccessPoint[ name:src#GENP, ConnectObject[ url:jdbc:oracle:thin:@GENPRD01:1521:GENPRD01, user: genesys, pass: ***** ] ] (table: OL_DATA121) [null]]
ETL_Trans_Only: Stack Trace:
ETL_Trans_Only: TransformException: SrcChunkDataMonitor#0 for src#GENP: unable to read chunk's data from: DatabaseAccessPoint[ name:src#GENP, ConnectObject[ url:jdbc:oracle:thin:@GENPRD01:1521:GENPRD01, user: genesys, pass: ***** ] ] (table: OL_DATA121) [null]
ETL_Trans_Only: at SrcChunkDataMonitor.proceedRequests(SrcChunkDataMonitor.java:191)
ETL_Trans_Only: at SrcChunkDataMonitor.executeCommand(SrcChunkDataMonitor.java:116)
ETL_Trans_Only: at Monitor.run(Monitor.java:301)
ETL_Trans_Only: at java.lang.Thread.run(Unknown Source)
Process is still running, skipping the start point
'ETL_Trans_Only' will be started at 01/15/2003 00:20:00
Process is still running, skipping the start point
'ETL_Trans_Only' will be started at 01/15/2003 00:21:00
Process is still running, skipping the start point
'ETL_Trans_Only' will be started at 01/15/2003 00:22:00
Process is still running, skipping the start point
'ETL_Trans_Only' will be started at 01/15/2003 00:23:00
Process is still running, skipping the start point

[gauthier]

Could you post the command line you used to start your ETL Runtime application.

[JohnR]

Since you got: ETL_Trans_Only: java.lang.OutOfMemoryError, you may have to increase the amount of memory available to Java. Your "run_Trans_only.bat" looks something like this:"java Xmx256m jar transform.jar conf trans_only.properties" If you change the "Xmx256m" to "Xmx512m" you double the amount of memory available to Java