Cannot flush and commit transaction

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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

[DataEng]

Hi, 

have you found a solution for this problem? 

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

Regards, 

Sergio

[Anonymous]

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