Can't update Tc 10.1.0 -- list_users.exe hangs

Software Versions/Configuration:  ========================================  A customer's Development site was recently upgraded from Tc 9.1.2.5 to 10.1.0.  The configuration includes:  Content Migration Manager  Teamcenter Foundation  Web Tier for .NET  NX Integration  Online Help  .NET Based Server Manager  FMS Server Cache  Teamcenter Integration for I-deas - Database Extensions Description of Problem:  ========================================  When attempting to apply the 10.1.2.3 update to the server, TEM prompts for the infodba password and then runs list_users.exe in the background before applying the update. However, the list_users.exe process hangs - the process was left to run for over an hour, which slowly consumed over 500 MB of memory  before being killed. Killing the process prevents the update from proceeding.

Solution

Ran clearlocks -verbose and looked at the resulting .jnl file. It showed many 10's of thousands of stale locks in the database. They ran list_users again, but this time let it go for a couple hours. It eventually cleaned the locks, and they were able to run the 10.1.2.3 update successfully. Notes