Need Help in Stats & Logs Settings

[Anonymous]

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

[Anonymous]

Hi,

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

[Anonymous]

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

[Anonymous]

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


Regards,
Siva

[Anonymous]

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. 

[Anonymous]

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.