# While Trading Network Deployment some tables locking

**URL:** <https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302>\
**Category:** Forum\
**Tags:** trading-network, deployment, lock-table\
**Created:** [March 28, 2022, 9:10am UTC](https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302 "2022-03-28T09:10:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mursel.dogrusozlu](https://avatars.discourse-cdn.com/v4/letter/m/ba9def/32.png) [@mursel.dogrusozlu](https://techcommunity.softwareag.com/u/mursel.dogrusozlu)\
**Post date:** [March 28, 2022, 9:10am UTC](https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302/1 "2022-03-28T09:10:58Z")

</div>

Hello everyone,  
I am working on deploying trading network assets. All IS and TN composites are rendered successfully. However, I am getting a `Read timed out` error on TN composites while IS entities are deployed successfully during deployment. When I examine the source of the problem, I can see from the query below that the Contact, PartnerContact, Destination PartnerDestination tables are locked.

```auto
SELECT blocking_session_id AS BlockingSessionID, session_id AS VictimSessionID,    
[text] AS VictimQuery, wait_time/1000 AS WaitDurationSecond
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text([sql_handle])
WHERE blocking_session_id > 0

```

When I kill the locked queries, I get the

> [SoftwareAG][SQLServer JDBC Driver]Object has been closed

error on only Enterprise partner.

webMethods Version: 10.3  
SQL Server Database  
Windows Server 2019

what is your opinion about this issue?

Thanks,

---

<div class="post-metadata">

**Author:** ![Avik\_Dey1](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@Avik\_Dey1](https://techcommunity.softwareag.com/u/Avik_Dey1)\
**Post date:** [March 28, 2022, 6:30pm UTC](https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302/2 "2022-03-28T18:30:23Z")

</div>

Have you checked if enough connections persists.

---

<div class="post-metadata">

**Author:** ![Vivekanandhan\_DK](https://avatars.discourse-cdn.com/v4/letter/v/a183cd/32.png) [@Vivekanandhan\_DK](https://techcommunity.softwareag.com/u/Vivekanandhan_DK)\
**Post date:** [March 28, 2022, 7:49pm UTC](https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302/3 "2022-03-28T19:49:22Z")

</div>

I had repeated TN database lock issue for past few months. We implemented Transaction isolation at database level which resolved our problem.

[SET TRANSACTION ISOLATION LEVEL (Transact-SQL) - SQL Server | Microsoft Learn](https://docs.microsoft.com/en-us/sql/t-sql/statements/set-transaction-isolation-level-transact-sql?view=sql-server-ver15**strong) text\*\*

---

<div class="post-metadata">

**Author:** ![mursel.dogrusozlu](https://avatars.discourse-cdn.com/v4/letter/m/ba9def/32.png) [@mursel.dogrusozlu](https://techcommunity.softwareag.com/u/mursel.dogrusozlu)\
**Post date:** [March 30, 2022, 6:14am UTC](https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302/4 "2022-03-30T06:14:43Z")

</div>

Hi Vivek,  
Thank you for your reply. Please could you give me more detail which one level did you prefer and how to implement it?  
thanks.

---

<div class="post-metadata">

**Author:** ![Vivekanandhan\_DK](https://avatars.discourse-cdn.com/v4/letter/v/a183cd/32.png) [@Vivekanandhan\_DK](https://techcommunity.softwareag.com/u/Vivekanandhan_DK)\
**Post date:** [March 30, 2022, 1:19pm UTC](https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302/5 "2022-03-30T13:19:56Z")

</div>

We implemented transaction-isolation level on the database to READ\_COMMITTED\_SNAPSHOT

to find what snapshot is enabled , use the below query.

Change DB name according to your actual db in the below query and execute below query:

SELECT name,is\_read\_committed\_snapshot\_on, snapshot\_isolation\_state\_desc FROM sys.databases WHERE name= ‘\<TN\_DATABASE\_NAME\>’

To implement this , you need to work with your database administrator. This will need a outage.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [June 28, 2022, 1:20pm UTC](https://techcommunity.softwareag.com/t/while-trading-network-deployment-some-tables-locking/256302/6 "2022-06-28T13:20:00Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
