My Oracle Support Banner

12.6.0 Historian Default Settings - Losing Data (Doc ID 2674282.1)

Last updated on MAY 27, 2020

Applies to:

Oracle Documaker - Version 12.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.6 version, Enterprise Edition

ACTUAL BEHAVIOR
---------------

We are currently running the factory/system installed defaults for Historian in our ODEE version 12.6.00.32242 environment. Based on our understanding, the default settings should do the following:

1. Once per week (0 59 23 ? * SUN), Historian will move all 999 transactions older than 5 days to the TRNSHIST table.
2. Upon moving the transaction to the TRNSHIST table, the RETENTION date will be set to "Current Day + 1 Year".
3. The Purge Trns History TASK will remove any records from the the TRNSHIST table where RETENTION date is less than Current Date.

Our understanding is that successful/completed transactions will be saved for approximately 1 year on the TRNSHIST table, but we are seeing transactions purged well before their RETENTION date has passed. We are using the default settings in every test and production environment. We are seeing different results in each TRNSHIST table. It looks like data is being truncated well before its expiry date.

On 3/6/2020, we had TRNSHIST records with a RETENTION date of 12/02/2020. I would expect those transactions to not be purged before this December, but we saw a few weeks later the entire block of 12/02/2020 transactions were purged. As of now, we only have transactions going back to 12/09/2020.




EXPECTED BEHAVIOR
-----------------------
Move eligible transactions (999 and 5+ days old) to the TRNSHIST table and to never purge anything from the TRNSHIST table.

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.