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.
Kindly help me with your thoughts on resolution.
Is it a random case? On which talend build version you got this issue? Is your license Ok with you?
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.
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?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.