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

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.5.0 and later
Information in this document applies to any platform.
Overview
-----------
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.

Symptoms

On : 10.1.3.5.0 version, Content Server

ACTUAL BEHAVIOR

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

reduction-20120813.log
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)

STEPS

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

Changes

There are no rows in the SCTACCESSLOGARCHIVE table.

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