Sporadic database connection issues in Talend Cloud

Five Stars

Sporadic database connection issues in Talend Cloud

Jobs fail in Talend Cloud fairly regularly (a few times a week) and not the same jobs or databases, with database connection errors. Sometimes, they are Oracle reset errors (see below A.) This particular Oracle environment is on premise. Other times, they are Postgres errors (see below B). This Postgresql db is on AWS, and the error seems like the connection variables were not passed properly. Why does this happen? The databases are up and reachable, and if the job is rerun, it almost always is fine. However, it causes execution plans to fail and subsequent jobs not to run. It's a production support drain.

A) Exception in component tOracleInput_1 java.sql.SQLRecoverableException: IO Error: Connection reset at oracle.jdbc.driver.T4CConnection.logon

 

B) Exception in component tPostgresqlInput_1 (GL7113C_Flex_Values) java.sql.SQLException: No suitable driver found for jdbcSmiley Tongueostgresql://:/ at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:247) at financial.gl7113c_flex_values_0_1.GL7113C

 

 

Employee

Re: Sporadic database connection issues in Talend Cloud

Hello,

 

from first issue about Oracle connection is not clear what could be the problem. We need more info / logs if possible.

But second one is clear. We have known issue: sometimes during task execution context parameters from another context are taken (or just taken 'null' values). We are working now on the fix and expect to update production in comming days.

 

Thanks,

Yuri

Five Stars

Re: Sporadic database connection issues in Talend Cloud

Thank you. Actually, usually the Oracle connection error is a null pointer exception, so I think that may be the same problem as what we see with Postgresql. Will the update be cloud only and seamless to users or will there be a new remote engine version also?

 

How can we know when this has been put into production?

Highlighted
Employee

Re: Sporadic database connection issues in Talend Cloud

yes, looks like with Oracle also the same issue.

 

we are working on fix now. it's still not clear how to fix it but I think it will require new version of remote engine.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend Cloud Developer Series – Fetching Studio License

This video will help someone new to using Talend Studio get started by connecting to Talend Cloud and fetching the Studio License

Watch Now

Talend Cloud Developer Series - Introduction

The Talend Cloud Developer Series was created to give you a solid foundational understanding of Talend’s Cloud Integration Platform

Watch Now

Talend Cloud Available on Microsoft Azure

An integration platform-as-a-serviceto help enterprises collect, govern, transform, and share data from any data sources

Watch Now