ETL Service stopped transfering chunks

[Timur Karimov]

Hi All!

Hope that someone already solve such problem..ETL stopped transfer chunks. In log files i was found this error:

09:52:17.366 ERROR Exception happened:
09:52:17.366 ERROR Stack Trace:
09:52:17.366 ERROR java.lang.NullPointerException
09:52:17.366 ERROR at ETL.Statistic.<init>(Statistic.java:37)
09:52:17.366 ERROR at ETL.SrcScheyoutMonitor.readStatsForLayout(SrcScheyoutMonitor.java:178)
09:52:17.366 ERROR at ETL.SrcScheyoutMonitor.readAll(SrcScheyoutMonitor.java:127)
09:52:17.366 ERROR at ETL.SrcScheyoutMonitor.executeCommand(SrcScheyoutMonitor.java:42)
09:52:17.366 ERROR at ETL.Threads.BasicMonitor.run(BasicMonitor.java:64)
09:52:17.366 ERROR at java.lang.Thread.run(Thread.java:662)
09:52:17.366 Thread.SourceManager#1 caught an exception. Monitor: SrcScheyoutMonitor#1 Message: SrcScheyoutMonitor#1: unable to execute command: RELOAD
09:52:17.366 Thread.SourceManager#1 Stack Trace:
09:52:17.366 Thread.SourceManager#1 java.lang.NullPointerException
09:52:17.366 Thread.SourceManager#1 at ETL.Statistic.<init>(Statistic.java:37)
09:52:17.366 Thread.SourceManager#1 at ETL.SrcScheyoutMonitor.readStatsForLayout(SrcScheyoutMonitor.java:178)
09:52:17.366 Thread.SourceManager#1 at ETL.SrcScheyoutMonitor.readAll(SrcScheyoutMonitor.java:127)
09:52:17.366 Thread.SourceManager#1 at ETL.SrcScheyoutMonitor.executeCommand(SrcScheyoutMonitor.java:42)
09:52:17.366 Thread.SourceManager#1 at ETL.Threads.BasicMonitor.run(BasicMonitor.java:64)
09:52:17.366 Thread.SourceManager#1 at java.lang.Thread.run(Thread.java:662)
09:52:17.366 MGMT_EVENT 30002
09:52:17.366 ALARM 30002 Communication problem has been detected.
09:52:17.366 Source the only left source has caught an exception. Exiting...

And nothing more =( I of coz already made search against Genesys KB but with out any positive result =(

Fanx for any suggestion
Tim

[cavagnaro]

Hey Timur,
I'd try to stop ETL entirely and then start it over and see what happens then. You probably will get more details.

[Timur Karimov]

It's always first what we try - restart =)
I just post only error message - all other output don't have any clear info

[cavagnaro]

Can you post some of the previous logs? What does it does OK before that?
Any changes on DMA templates or Stats being used by ODS?

[Timur Karimov]

Well. With Genesys support found problem with deleted report layouts template which contain statistic parameters with unsuported type (javaUnknow). After delete  - it's doe't show in DMA but still exist in DB as "deleted". However ETL don't check deleted date and stop worked.
genesys provide to me some custom sql scripts to manual delete wrong data from ODS DB. After it- all works fine.
Sorry for waste you time.

WBR Tim.

[malhelo]

please to try to fill out the start date in SOURCE table in the Datamart

[raza990]

Dear Timur,

I'm experiencing the same issue.

Can you please share that SQL script with me ?

Thanks