webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  While Trading Network Deployment some tables locking

    Posted Mon March 28, 2022 05:11 AM

    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.

    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,


    #webMethods
    #deployment
    #trading-network
    #lock-table


  • 2.  RE: While Trading Network Deployment some tables locking

    Posted Mon March 28, 2022 02:30 PM

    Have you checked if enough connections persists.


    #deployment
    #trading-network
    #lock-table
    #webMethods


  • 3.  RE: While Trading Network Deployment some tables locking

    Posted Mon March 28, 2022 03:49 PM

    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 text**


    #webMethods
    #deployment
    #lock-table
    #trading-network


  • 4.  RE: While Trading Network Deployment some tables locking

    Posted Wed March 30, 2022 02:15 AM

    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.


    #trading-network
    #webMethods
    #deployment
    #lock-table


  • 5.  RE: While Trading Network Deployment some tables locking

    Posted Wed March 30, 2022 09:20 AM

    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.


    #webMethods
    #trading-network
    #lock-table
    #deployment