My Oracle Support Banner

Project And Baseline Publication Job Taskpredx Update Statement Generating "Enq: Tm – Contention" Wait Event (Doc ID 2983698.1)

Last updated on OCTOBER 27, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 21.12.13.0 to 21.12.15.0 [Release 21.12]
Primavera P6 Enterprise Project Portfolio Management - Version 22.12 to 22.12.8.0 [Release 22.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 21.12.13.0 to 23.9 [Release 21.12 to 23.9]
Information in this document applies to any platform.

Symptoms

 When multiple sessions are executing Project/Baseline publication jobs at one time, it is possible for the ACTIVE database sessions across the jobs to be blocked/locked.

This can introduce unnecessary delay to overall publication of a single job.

The statements are not blocked for a long time (as the insert statement can run ~10 seconds max); it's just they can continually get into this state if many active jobs are running at one time and happen to hit the same step to trigger behavior.

This issue can be reproduced, as long as multiple publication jobs are running at one time.

Changes

 

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
Changes
Cause
Solution


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