Exception in component talendStats_DB: java.lang.NullPointerException

[Anonymous]

Dears,
I'm getting the above exception, in every job while trying to run.
Please note, job is executing successfully but give me this exception.
No change happened in server environment or jobs (Till yesterday everything was ok). I have Talend 5.0 on Windows Server 2008.
Exception in component talendStats_DB
java.lang.NullPointerException
at dw_first_load.dw_barcode_vend_0_1.DW_BARCODE_VEND.talendStats_STATSProcess(DW_BARCODE_VEND.java:2243)
at dw_first_load.dw_barcode_vend_0_1.DW_BARCODE_VEND.runJobInTOS(DW_BARCODE_VEND.java:3604)
at dw_first_load.dw_barcode_vend_0_1.DW_BARCODE_VEND.main(DW_BARCODE_VEND.java:3474)
connected
Exception in component talendStats_DB
java.lang.NullPointerException
at dw_first_load.dw_barcode_vend_0_1.DW_BARCODE_VEND.talendStats_STATSProcess(DW_BARCODE_VEND.java:2243)
at dw_first_load.dw_barcode_vend_0_1.DW_BARCODE_VEND.runJobInTOS(DW_BARCODE_VEND.java:3642)
at d errw_first_load.dw_barcode_vend_0_1.DW_BARCODE_VEND.main(DW_BARCODE_VEND.java:3474)
But, if there is any error happened in a job. I can't check it from Log_Catcher any more
select *
from dbo.log_Catcher
where moment>='2016-06-20 00:00:55.940' 
order by moment desc
Please advice what could be the reason for this exception.

[Anonymous]

Hi,
Did you set any Stats&Logs in job review or project setting before? This issue repro on all your jobs?
Best regards
Sabrina

[Anonymous]

Hi,
Thanks for reply.
Yes, we have this option set in project setting. Since 5 years, and I would like to continue with it.
This is my first time to get this error, and yes this error is coming for all jobs.

[Anonymous]

Hi,
The stat log DB connection is Ok with you now? Could you please try to output your log info into a file instead of DB to see if it works?
Best regards
Sabrina

[Anonymous]

Hi,
I tried, file option is working without error only DB option throw NULL POINTER exception.
Also, I tried a new test project on the same Talend (I set projects  Stat&Logs setting to both Files & DB and in the Test project and it
is working ok, only production existing project corrupted). 
I'm looking to fix this exception ASAP, as we have scheduled job status emails, which checking Stat_Catcher & Log_Catcher tables in DB.
Please advice.

[Anonymous]

Hi,
From your investigation, this issue is probably caused by this DB connection. Have you tried to successfully connect to this DB directly?
Did you make any change for this stat log table? Are you using talend subscription version 5.0?
Best regards
Sabrina

[Anonymous]

Hi Sabrina, 
Nothing changed in Stat_Log tables, and please note the other TEST project, I created is inserting statistics data to the same  Stat_Catcher & Log_Catcher DB tables & same DB successfully.
I start to doubt may be libraries included in my production project got corrupted. I'm checking this function  talendStats_STATSProcess
which is throwing this exception, trying to get which library is calling but no success. 
Also, on same Talend and same DB & same tables other project is working ok!!!

[Anonymous]

Hi,
Are you trying to  execute your job from outside studio (probably on different machine)?
We suppose that it is failing due to invalid database connection details configured in the project settings section. Would you mind sharing your database connection details in projecting setting about  talendStats_DB?

Best regards
Sabrina