Slow Performance When Running Project Summarize Job Caused by 'Enq: TX - Row Lock Contention' (Doc ID 2268607.1)

Last updated on JUNE 01, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.3.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 15.1.3.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Project Summarize job is taking around 10 minutes to complete

In AWR report, Below 2 queries in row lock `enq: TX - row lock contention
delete from sumtrsrc where proj_id is null and role_id = :1;
delete from sumtrsrc where proj_id is null and rsrc_id = :1;

EXPECTED BEHAVIOR

Each Project Summarize job should be completed quickly.

STEPS

The issue can be reproduced at will with the following steps:
1. Set up P6Service as separate JVM process
2. JT_SUM concurrent thread is 2 (default)
3. Observe Pending Summarize Job will be picked up and run

BUSINESS IMPACT

The issue has the following business impact:
Due to this issue, users cannot summarize project efficiently.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms