Subversion error - Working copy of a particular job is locked

If you run into “subversion error.. working copy of /jobName is locked"..

You can unlock a job in two ways.

1. Execute the following command to unlock your job. (My TIS 4.2 is on Ubuntu)
   
   find /TalendWorkspaces/ -name lock |xargs rm
2. Open the TIS/TOS
   go to Navigator--->your project name folder--> Delete the two files of old version job: jobName_oldVersion.item, jobName_oldVersion.properties, then return back to repository viewer and click on 'refresh' button.
   

( If you cannot find Navigator, you can view it by going to Window--> Show view --> General --> Navigator. )

Happy Talending!!

java.lang.RuntimeException: For update, Schema must have a key

This is a famous Talend runtime Exception that a novice could run into several times especially when using an DBoutput component and updating the rows. Talend Forums are not quite helpful in resolving this issue. The fix is very straightforward but very unintuitive to know about it in the first attempt.

The fix involves checking the "Update-Key" found in the Advanced Settings of the Component view.

Above is the screenshot of how to fix the Exception. Go to the "Component" tab --> "Advanced Settings" --> Update Key

Check the appropriate column in the check boxes under the update key heading. You might have to scroll down the page to find this setting.

How to install MYSQL on ubuntu

Open a terminal window, and use the following command:

sudo apt-get install mysql-server

If you are running PHP you will also need to install the php module for mysql 5:

sudo apt-get install php5-mysql

Introduction to Talend

Talend is an open source software for Data Integration that is quickly becoming an alternative to expensive ETL tools in the BI space.

Talend has its presence in four areas especially, the Data Quality, Data Integration, Master Data Management and Application Integration.

Talend projects could be developed in Java or PERL. Talend has around 450 components currently and Talend's community has contributed many interesting components like tGoogleAnalytics.

TOS is the Talend's Open Studio for developing Talend jobs individually and TIS is the Integration Studio for collaboration.

Talend's version control is called SVN. TOS comes with a demo JAVA project that has sample jobs for quickly learning Talend in action.

I will try to post a sample job everyday in this blog of my-experiments-with-Talend.

Happy Talending!!