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
Plop.
It's not a bug. Sorry for the last post.
After working correctly one hour on Talend v4.1.2 the result as the same with Talend v5.1.2 (using simple job with a tMsgBox and "Stats & logs" project parameters) :
"Exception in component talendStats_DB
java.lang.NullPointerException
at sidarrg.job_squelette_source_0_1.job_squelette_source.talendStats_STATSProcess(job_squelette_source.java:1595)
at sidarrg.job_squelette_source_0_1.job_squelette_source.runJobInTOS(job_squelette_source.java:2843)
at sidarrg.job_squelette_source_0_1.job_squelette_source.main(job_squelette_source.java:2716)
connecting to socket on port 3525
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:1595)
at sidarrg.job_squelette_source_0_1.job_squelette_source.runJobInTOS(job_squelette_source.java:2880)
at sidarrg.job_squelette_source_0_1.job_squelette_source.main(job_squelette_source.java:2716)
disconnected"
It's very strange...
See my configuration : 2 Servers on Windows 2008 R2 64bits
* 1 server with :
Business Objects R3
Talend v4.1.2, v5.1.2
Java 1.6.0.34 (with environment variable JAVA_HOME : C:\Program Files (x86)\Java\jdk1.6.0_34 and Path : ...;C:\Program Files (x86)\Java\jre6\bin).
Oracle 11g R2 client 32Bits (32bits is necessary for Business Objects...).
SQLDevelopper
*1 Server with Oracle 11gR2.
On Talend I'm using Oracle 11 connection by SID (the result as the same with service name).
The connection working. I have only an error when using "Stats & logs" project parameter or "Stats & logs" job parameter (localy in job without using project parameter).
It's working when using component statcatcher and others directly in my job with tMap and tOracleOutput components...
I search since 3 days without solution. :-((
If you have an Idea.
