Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: klee09 on July 10, 2009, 10:08:10 AM

Title: ETL Agg is not working
Post by: klee09 on July 10, 2009, 10:08:10 AM

Hi to all,

I'm encounter the ETL AGG error and not Aggregation for Hourly, Daily, Weekly, Monthly and etc except 15minutes interval.
The following is the Java exception that captured from ETL log file.

ETL_Agg_Only*:* 01:10:12.303 Write.Job.Agg.105 finished aggregation
ETL_Agg_Only*:* 01:10:12.373 Write.Job.Agg.106 finished aggregation
ETL_Agg_Only*:* 01:10:12.546 Write.Job.Agg.107 finished aggregation
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager caught an exception. Monitor: Writer#2 Message: Writer#2: unable to execute command: AGG
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager Stack Trace:
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager java.lang.NullPointerException
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager at DataMart.NextId.get(NextId.java:54)
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager at ETL.Writer.AbstractJob.fillPendingList(AbstractJob.java:134)
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager at ETL.Writer.AbstractJob.insertPending(AbstractJob.java:111)
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager at ETL.Writer.AggJob.perform(AggJob.java:111)
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager at ETL.Writer.WriterMonitor.executeCommand(WriterMonitor.java:46)
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager at ETL.Threads.BasicMonitor.run(BasicMonitor.java:64)
ETL_Agg_Only*:* 01:10:12.644 Thread.DstChunkWritersManager at java.lang.Thread.run(Thread.java:536)
ETL_Agg_Only*:* 01:10:12.672 Main TRANSFORM finished

Please help....