to use tMySQLCDC component - does a CDC db need to be installed?
Hello, I am new to Talend Enterprise Data Integration. I get an error msg: "Unknown column 'TALEND_CDC_STATE' in 'where clause' " when trying to use tMySQLCDC component in a job. I do not see TALEND_CDC_STATE column anywhere in the tables that I want to capture CDC. Does a CDC database need to be installed prior to using tMySQLCDC component in jobs? If yes, please point me to documentation describing how to install the CDC database on MySQL. Is it easy to install and to configure?
Does a CDC database need to be installed prior to using tMySQLCDC component in jobs?
You don't need to install a CDC db. please give us your job flow and the related screenshot. Maybe something wrong with your setting. Best regards Sabrina
When I hit 'Log In' at the top right hand corner of Talendforge page, it then shows my userID - lenfinkel (View/Edit mode). But when I go to view posts, do a search, etc... the msg at the top (right under Index, Tags, Timeline, etc... says "You are not logged in'. Is this a bug? What is the next step to be able to upload images?
Please advise. Thank you.
When I hit 'Log In' at the top right hand corner of Talendforge page, it then shows my userID - lenfinkel (View/Edit mode). But when I go to view posts, do a search, etc... the msg at the top (right under Index, Tags, Timeline, etc... says "You are not logged in'. Is this a bug? What is the next step to be able to upload images? Please advise. Thank you.
It was a bug right now. This could be a solution, it works for other users who have same login issue.
Don't use IE to open Talend, go to Talendforge page
http://www.talendforge.org/ and login, then open Exchange page.
http://www.talendforge.org/exchange/index.php return back to Talendforge page, and then Talend forum.
Sabrina,
Here are the snapshots of the CDC job flow, including error messages. Another question - does a "TCDC_" table need to be created prior to executing the job? Please see error msgs in the attached screenshots. Please let me know as soon as you can if you have enough information in attached screenshots to assist me so that I will be able to run CDC jobflows successfully. I would like to be able to execute this job today.
The error msg in the snapshot is:
2012-11-05 10:24:23|wegvks|wegvks|wegvks|ANALYTICS|Lenny_LoadStagingCurrency_Today2012Oct25_WithCDCs|Default|6|Java Exception|tMysqlCDC_7|com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:Table 'tca_staging.TCDC_stagingcurrency' doesn't exist|1
disconnected
Job Lenny_LoadStagingCurrency_Today2012Oct25_WithCDCs ended at 10:24 05/11/2012.
