If you encounter lock issue of the taskexecutionhistory table in the database, follow these steps to resolve it.
About this task
configuration.propertiesfile to edit it.
lockTimeoutfor connection pool by URL, for example:
jdbc:sqlserver://localhost:1433/tac801;lockTimeout=1800In cluster mode, change this connection URL on all instances of Talend Administration Center.It is also recommended to enable the
ALTER DATABASE <database name> SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE;
- Save your changes and close the file.