ETL Service stopped transfering chunks

NICE CXone API & Integrations
1

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: <>

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: <>

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

2

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

3

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