Exception in component talendStats_DB with Oracle 11gR2
Hi,
I'm using TOS v5.2.0 on Windows 2008 Server R2 with Oracle 11g R2.
I have create TALN_STAT_CATC2 table to save the statcatcher information in Oracle (see attachment).
I'm describe in project configuration the 'stats and logs' configuration (see attachement).
(It's the same without pojectconfiguration...).
I have create a simple job with tMsgBox using project parameter for 'stats and logs' and I have NullPointerException (see attachment).
I don't understand the reason.
I can read data on TALN_STAT_CATC2 from TALEND with my connection, but when I using this connection to write (stat & logs) I have this error.
If you have an idea :-(
Thank's in advance.
Regards
One often happened reason for NullPointerException is:
A table column is configured as not nullable and the input value is nullable. That cause an automatic unboxing of an object wrapper (e.g. Integer) to the simple data type int. But if the input value is null this unboxing failed with an NullPointerException. You can experience this also in the tMap component.
Thanks for your reply.
All columns of my table are nullable (see last attachment).
Since I have modify my metadata (oracle 11) for using SID in place of service name => As the same result.
I have testing whith the latest version of TOS (v5.1.2r90681) an recreate all of parts of my project with "Stat's & log" parameter => And It's work perfectly if I testing many times until I restart TOS.
Since I have restarting, I have the same problem when I'm using "Stat's & log" parameter:
"Exception in component talendStats_DB
java.lang.NullPointerException
at sidarrg.job_squelette_source_0_1.job_squelette_source.talendStats_STATSProcess(job_squelette_source.java:1654)
at sidarrg.job_squelette_source_0_1.job_squelette_source.runJobInTOS(job_squelette_source.java:2927)
at sidarrg.job_squelette_source_0_1.job_squelette_source.main(job_squelette_source.java:2797)
connecting to socket on port 3731
connected
Exception in component talendStats_DB
java.lang.NullPointerException
at sidarrg.job_squelette_source_0_1.job_squelette_source.talendStats_STATSProcess(job_squelette_source.java:1654)
at sidarrg.job_squelette_source_0_1.job_squelette_source.runJobInTOS(job_squelette_source.java:2966)
at sidarrg.job_squelette_source_0_1.job_squelette_source.main(job_squelette_source.java:2797)
disconnected"
My job is a simple job with only one tMsgBox component.
I have create another job with tMsgBox and StatCatcher component without using "Stat's & log" parameter.
And It work perfectly.
My jobs:
tMsgBox
tStatCatcher -> tMap -> tOracleOutput
It's very very strange.
To resums, It's work perfectly when using catcher components (stat, log, flowmeter) in my job without "Stat's & log" parameter...
I don't understand where is the problem.
If you have an idea... :-((
Hi
This problem caused by the settings of this panel, to confirm our guess, uncheck these box 'Use statistics (tstatcatcher)' and 'Use logs' ..., and execute the job again, check the problem still exists.
To resolve the problem, check the setting of DB parameters, the tables already exist?
Hi,
I have no problem when I'm uncheck these box to execut my job. It's the same when desactivate catcher.
When I'm using these tables with component tStatCatcher, tMap and tOracleOutput in place of "Stats & logs" parameter it's work perfectly (see attachment).
What do you mean by "check the setting of DB parameters" ?
All tables exists. I can read and write on these tables with the connection describe in the screnshot on my last post (cnx_DEV_SUPR).
The problem is only appear when using "Stats & log" parameter (in a job or in the project parameter)...
Do you have an idea?
Hi,
I'll confirm you it's a bug.
I'm thinks that, because, if I using TOS v4.1.2r53616 with exactly the same job and configuration ("Stats & log" parameter projects and Oracle 11 with SID configuration) It's working without error.
Even after restart TOS and server.
It's not the case with TOS v5.1.2r90681. I have my error after restart TOS...
It's to strange. Very strange.
I do open a ticket on BugTracker?
