Skip to main content Skip to complementary content

Clearing lock of taskexecutionhistory table

About this task

If you encounter lock issue of the taskexecutionhistory table in the database, follow these steps to resolve it.

Procedure

  1. Open the configuration.properties file to edit it.
  2. Set lockTimeout for connection pool by URL, for example: 
     jdbc:sqlserver://localhost:1433/tac801;lockTimeout=1800
    In cluster mode, change this connection URL on all instances of Talend Administration Center.
    It is also recommended to enable the READ_COMMITTED_SNAPSHOT option:
    ALTER DATABASE <database name>
 SET READ_COMMITTED_SNAPSHOT ON
 WITH ROLLBACK IMMEDIATE;
  3. Save your changes and close the file.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here