My Oracle Support Banner

Damon or REFRDEL_CLEANUP Does Not Clean REFRDEL Table in P6 Database (Doc ID 2169221.1)

Last updated on OCTOBER 07, 2020

Applies to:

Primavera P6 Professional Project Management - Version 15.2.3.0 to 15.2.10.0 [Release 15.2]
Primavera P6 Enterprise Project Portfolio Management - Version 15.2.3.0 to 15.2.10.0 [Release 15.2]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Damon or REFRDEL_CLEANUP does not clean REFRDEL table

EXPECTED BEHAVIOR
-----------------------
Damon or REFRDEL_CLEANUP cleans up the REFRDEL table

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

  1. Run exec data_monitor with all settings on default
  2. Notice the output: (Example Bellow)

The run date was in 2016, so the default damon settings should delete the entries from 2014:

Oldest Refrdel: Jun 14 2014 12:03AM
Cleared: 0 records from Jun 14 2014 12:03AM to Jun 14 2014 12:03AM

Total Rows Deleted/Changed: 0

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.