Talend Open Studio Errors (Compile and Run)

This is Kailash Yadav currently working as a Talend Developer. As a Talend Developer I have spent around 5+ years and worked on different products of talend including Talend Data Integration, ESB, Talend big data platform, Talend MDM and Talend Data Fabric. Also in this journey with Talend I used to provide training on Talend Platform and faced different type of errors during compile or Run time. 

Today I am going to illustrate these two errors using Talend open studio with the steps toward solution.

Resolving Compile Errors in Talend Open Studio

Let’s look at a compile error.  When we execute any job in Talend Studio, it will first attempt to compile, however, the compile will fail with the below error.

You can review java error details within the log, which states that the "quantity cannot be resolved or is not a field". Conveniently, it also highlights the component the error is most closely associated to.

To locate the specific source of the problem within the tMap component, you can either dive into the tMap and search yourself OR you can switch to the Code view. Although you cannot directly edit the code here, you can select the red box highlighted on the right of the scroll bar to bring you straight to the source of the issue.

In this case, the arithmetic operator is missing from the Unit Price and Quantity equation.

Next, head into the tMap component and make the correction to the Unit Price and Quantity equation by adding a multiplication operator (*) between Transactions.Unit_Price and Transactions.qty. Click Ok and now run the job again.

And now you see the compile error has been resolved.

Resolving Runtime Errors in Talend Open Studio

Next, the job attempts to send data to database and a runtime error occurs. You can read the log and it says, "JDBC driver not able to connect to Snowflake" and "Incorrect username or password was specified".

To address this issue, we’ll head to the Snowflake component and review the credentials. It looks like the Snowflake password was incorrect, so re-enter the Snowflake password, and click run again to see if that resolved the issue.

And it did! This job has been successfully debugged and the customer data has been published to the Snowflake database.

Conclusion:

This is the starting of problems and also there might be lot of reasons for compiling time and run time error. In future we will discuss how to resolve memory related errors in Talend.