Skip to main content
4-Participant
May 20, 2025
Question

the QueueLock table is often locked in the system

  • May 20, 2025
  • 1 reply
  • 242 views
I am using Windchill PDMLink Release 12.1 and Datecode with CPS 12.1.1.2

Nowadays, the QueueLock table is often locked in the system, but its status is inactive. I want to know how this deadlock is caused and how to optimize it in the future to avoid this situation from happening。

1 reply

HelesicPetr
22-Sapphire II
22-Sapphire II
May 20, 2025

Hi @YP_10630130 

It is usually cased by performance issue and too much queue entries.

Always you should investigate the performance of the server. 

There can be some improvement by indexes or you can try to run a WindchillConfigAssistant tool

ant -f utilities/wca/WindchillConfigAssistant.xml configureCacheManagerSizes -Dpropagate=true

PetrH