Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: lekie on March 11, 2009, 04:02:39 PM

Title: Datasourcer didn't collect data
Post by: lekie on March 11, 2009, 04:02:39 PM

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

Title: Re: Datasourcer didn't collect data
Post by: GenesysNewbie on March 11, 2009, 07:42:02 PM

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!

Title: Re: Datasourcer didn't collect data
Post by: lekie on March 13, 2009, 10:38:20 AM

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

Title: Re: Datasourcer didn't collect data
Post by: Fra on March 13, 2009, 11:34:31 AM

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

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

Fra

Title: Re: Datasourcer didn't collect data
Post by: GenesysNewbie on March 13, 2009, 02:32:29 PM

check ur dma client version, to correct the isuue.

Title: Re: Datasourcer didn't collect data
Post by: cavagnaro on March 13, 2009, 02:37:17 PM

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