Cannot flush and commit transaction

Four Stars

Cannot flush and commit transaction

Hello Experts,

We have built an HA Architecture (2 TAC + 3 Job Server) and we have execution plan that consists of 100 tasks running in parallel.

When we are trying to run that execution plan , our TAC gets hanged and we could see that hardly 1 or 2 job makes entry to target database and rest all job looks like stuck.

After checking technical log on TAC server I found below error:

2017-08-23 11:47:49 ERROR ConductorService - java.lang.RuntimeException: org.talend.administrator.common.exception.ProcessedException: !!!Cannot flush and commit transaction.!!!

DB string in configuration.properties file is set to something like this for mysql DB.

database.url=jdbc:mysql://<DB URL>?useSSL=false

 

Kindly help me with your thoughts on resolution.

 

Thanks,

Sachin

 

Moderator

Re: Cannot flush and commit transaction

Hello,

Is it a random case? On which talend build version you got this issue? Is your license Ok with you?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Cannot flush and commit transaction

Hello Sabrina,

 

This has been noticed quite often on technical.log files. We are using talend 6.3.1 and there is no issue with license.

 

Ticket #00080502 has been raised for this issue and I am still waiting for a solution on this.

 

Thanks,

Sachin

Highlighted
Four Stars

Re: Cannot flush and commit transaction

Hi, 

have you found a solution for this problem? 

We're experiencing the same issue with the same TAC version. 

 

Regards, 

Sergio

Moderator

Re: Cannot flush and commit transaction

Hello Sergio,

Could you please clarify in which Talend version/edition you are? Have you already created a case on talend support portal with your subscription solution?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

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

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch