My Oracle Support Banner

The unifier_admin_job Table is Locked Frequency After Upgrade to 21.12.4 (Doc ID 2891151.1)

Last updated on AUGUST 25, 2022

Applies to:

Primavera Unifier - Version 21.12.4.0 and later
Primavera Unifier Cloud Service - Version 21.12.4.0 and later
Information in this document applies to any platform.

Symptoms

 An table lock occurs on the unifier once patch to 21.12.4. The locked table is "unifier_admin_job". This error occurs very frequently.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Patch Unifier to 21.12.4
  2. Monitor database performance
  3. Notice the reported issue

Note:
The same issue does not observe before

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.