Error when deleting a user in Talend Administration Center

[Platform_support]

Hi,

We tried to delete a particular user in Talend. But we got an error " Delete Failed:!!! Cannot flush and commit transaction!!!". Details below.

Deleting the user from the table [dbo].[user] where id = 86. We found the user is in lock status in [dbo].[locks] itseems. Kindly help us to resolve this issue. Attached logfile for reference.

Regards.

[prg]

Hello,

Could you please try the below workaround;

1) log in to the TAC database

2) Take a backup of the 'locks' table (ex: CREATE TABLE LOCKS_BACKUP AS SELECT * FROM LOCKS)

3) Truncate 'locks' table

TRUNCATE TABLE LOCKS;

Thanks!!