Increase in ARCHIVELOG Growth When Resource and Role Data Publication is Enabled

(Doc ID 2308441.1)

Last updated on NOVEMBER 28, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.3.0 to 16.2.9.2 [Release 16.2]
Primavera P6 Enterprise Project Portfolio Management - Version 17.7 to 17.9.0.0 [Release 17.7 to 17.9]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Transaction growth is out of control and has to be monitored daily due to the daily growth.

EXPECTED BEHAVIOR
-----------------------
Transaction logs to not grow out of control.

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

  1. Enable 'Resource and Role Data' publication in P6 EPPM.
  2. Enable ARCHIVELOG mode on the database.
  3. Observe that the database transaction logs will grow at a high rate.

Changes

 

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