Need Help in Stats & Logs Settings

Anonymous — Tue, 28 Jul 2015 12:33:03 GMT

Greetings,

I am capturing Statistics, Count and Log information of my jobs in a text file by using the Stats & Logs in Job Settings.Now my requirement is to Capture all these information in a table while the jobs are executing, So i have selected "On DataBases" option in Stats & Logs.To capture the information in table i have created a table in the below mentioned format.

create table TalendStatistics
(
Moment Date NULL,
PID VARCHAR(20) NULL,
Father_PID VARCHAR(20) NULL,
Root_PID VARCHAR(20) NULL,
System_PID Longint NULL,
Project VARCHAR(50) NULL,
Job Varchar(50) NULL,
Job_Repository_ID Varchar(255) NULL,
Job_Version Varchar(255) NULL,
Context Varchar(50) NULL,
Origin Varchar(255) NULL,
Message_Type Varchar(255) NULL,
"Message" Varchar(255) NULL,
Duration Longint NULL
)

I have given this table name as a value for "Stats Table" in Stats & Logs. When i execute a job i am facing error as given below

[statistics] connecting to socket on port 3583
[statistics] connected
Exception in component talendStats_DB
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:188)
at uaeexdw.queryinterval_ct_0_1.QueryInterval_CT.talendStats_STATSProcess(QueryInterval_CT.java:4668)
at uaeexdw.queryinterval_ct_0_1.QueryInterval_CT.runJobInTOS(QueryInterval_CT.java:6942)
at uaeexdw.queryinterval_ct_0_1.QueryInterval_CT.main(QueryInterval_CT.java:6774)
Exception in component talendStats_DB
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:188)
at PRJ.queryinterval_ct_0_1.QueryInterval_CT.talendStats_STATSProcess(QueryInterval_CT.java:4668)
at PRJ.queryinterval_ct_0_1.QueryInterval_CT.runJobInTOS(QueryInterval_CT.java:6979)
at PRJ.queryinterval_ct_0_1.QueryInterval_CT.main(QueryInterval_CT.java:6774)
[statistics] disconnected
Job QueryInterval_CT ended at 15:16 28/07/2015. [exit code=1]

In sybase IQ Message is a key word so i have created that with in Quotes "Message", if this is the reason for the error kindly advice in solving this issue.

Thanks in Advance,
Siva

Re: Need Help in Stats & Logs Settings

Anonymous — Wed, 29 Jul 2015 03:59:57 GMT

Hi,

Can you create a sybase IQ DB connection in DB metadata successfully?
Best regards
Sabrina

Re: Need Help in Stats & Logs Settings

Anonymous — Wed, 29 Jul 2015 07:27:47 GMT

Hi,
I am able to create a DB metadata connection but the objects are not gettings listed after

In my job i am using tsybaseconnection to establish connection with sybase IQ.

Regards,
Siva

Re: Need Help in Stats & Logs Settings

Anonymous — Thu, 30 Jul 2015 06:49:13 GMT

Hi,
Can anybody help me on this issue, Should i provide any other detail

Regards,
Siva

Re: Need Help in Stats & Logs Settings

Anonymous — Tue, 11 Aug 2015 09:34:03 GMT

Hi
I have this problem, you should just create the Table without any field and given this table name as a value for stats table in stats and logs .Talend will do create the differente fields try this.

Re: Need Help in Stats & Logs Settings

Anonymous — Tue, 11 Aug 2015 09:47:47 GMT

I have created a tutorial on the AMC and part of it includes a job that you can use to create your schema (the job I have put together is for a MySQL db, but can be converted easy enough). You can find it here. Search for "AMC" in the search box on my site to find other components to the tutorial.

topic Re: Need Help in Stats & Logs Settings in Talend Studio

Need Help in Stats & Logs Settings

Re: Need Help in Stats & Logs Settings

Re: Need Help in Stats & Logs Settings

Re: Need Help in Stats & Logs Settings

Re: Need Help in Stats & Logs Settings

Re: Need Help in Stats & Logs Settings