My Oracle Support Banner

Content Tracker Metadata Snapshot Post Process Takes A Long Time To Complete (Doc ID 1486785.1)

Last updated on MAY 22, 2020

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.
The Content Tracker data reduction process gathers and merges the data obtained from the four data recording sources.
Once the data is collected, Content Tracker combines, analyzes and synthesizes the event information and loads the
summarized activity into database tables.

If the snapshot function is activated, the values in the search relevance metadata fields are updated during a post-reduction step.
During this processing step, Content Tracker uses SQL queries to determine which content items have changed activity metrics values.
Content Tracker updates the applicable database tables with the new values and initiates a re-indexing cycle.

The post-reduction processing step is necessary to:
- Process and tabulate the activity metrics for each affected content item and load the data into the assigned custom metadata fields.
- Initiate a re-indexing cycle on the content items with changed activity metrics values.
This ensures that the data is part of the search index and, consequently, accessible for selecting and ordering search results.


On : version, Content Server


Performance Issue with Data Reduction Process and Activity Metrics. The post-reduction update process takes around 6 hours to finish. Example:

14/08/2012 3:00: ******************** Start Reduction ********************
14/08/2012 3:00: Log file integration started for the following date: 20120813
14/08/2012 3:07: Completed reading all Data Engine log entries.
14/08/2012 3:14: Completed reading all Data Engine log entries.
14/08/2012 3:14: Log file integration completed.
14/08/2012 3:14: About to gather user information.
14/08/2012 9:25: Metadata Snapshot phase completed.  10715 Document(s) updated.
14/08/2012 9:25: Data Engine data reduction complete.
14/08/2012 9:25: ******************** End of Reduction *******************

Snapshot processing takes long time to finish (10715 document takes 6 hours to complete)


The issue can be reproduced at will with the following steps:
1. Enable activity metrics via the Snapshot tab in Content Tracker Data Engine Control Center


There are no rows in the SCTACCESSLOGARCHIVE table.


To view full details, 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 a vibrant support community of peers and Oracle experts.