Datasourcer didn't collect data

NICE CXone API & Integrations
1

Dear All,

I’ve found the problem about datasourcer.
In DMA, there are many layout such as Agent, AgentGroup, RoutingPoint.
I’ve found the problem when I create the new AgentGroup or edit the AgentGroup.
In DMA, all AgentGroup Layout won’t transfer data to Datamart and othere Layout they are tranaffed data but they didn’t delete data from ODS.
So, I just deactive and active on AgentGroup Layout and restart ODS that is my work around.

What log file i shoud get it datasourcer and etl right?
Have some one use to face like this problem?

Thank you in advance,
Lek

2

Hi, SHOULD review etl_runtime logs

can u post a piece of log?

i guess about problem

MAYBE, if u create a new layout u name some parameter/statistic with the same name of a old statistic. There is a DMA client version that can fix it if reinstall it also thsi client prevent make the same mistake again.

u should look 2 the rigth the DMA version, i GUESS IS THE 7.2.003.

REMEMBER VALIDATE ALL BEFORE DOING ANYTHING!

1 Like
3

Hi,

I am not sure about the time but I just check in log file as below

ETL_Trans_Only*:* 18:01:05.122 Src.ChunkLog.id0 dropped table ‘OL_DATA3066’ and marked all chunk log records as deleted.
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager caught an exception. Monitor: LayoutFolderMonitor Message: LayoutFolderMonitor: unable to execute command: UPDATE
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager SQLState: 08S01
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager Vendor: 0
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager Stack Trace:
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager java.sql.BatchUpdateException: I/O Error: Connection reset by peer: socket write error
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:966)
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at DataMart.SqlMacro$PreparedMacro.executeBatch(SqlMacro.java:481)
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at DataMart.SqlMacro$PreparedMacro.executeAndCommitBatchEvery(SqlMacro.java:508)
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at ETL.LFolder.LayoutFolderFactory.updateObjs(LayoutFolderFactory.java:161)
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at ETL.LFolder.LayoutFolderMonitor.update(LayoutFolderMonitor.java:117)
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at ETL.LFolder.LayoutFolderMonitor.executeCommand(LayoutFolderMonitor.java:82)
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at ETL.Threads.BasicMonitor.run(BasicMonitor.java:64)
ETL_Trans_Only*:* 18:01:05.778 Thread.DstManager at java.lang.Thread.run(Unknown Source)
ETL_Trans_Only*:* 18:01:05.809 Main TRANSFORM finished

Thank you in advance,
Lek

1 Like
4

It seems you are experiencing some issues on the connection with the database:

I/O Error: Connection reset by peer: socket write error

Fra

5

check ur dma client version, to correct the isuue.

1 Like
6

The user you are using has permissions to update on the DB?

1 Like