Skip Navigation
Expand
Missing KF_ANSWER_STATS before a specific date
Answer ID 5830   |   Last Review Date 08/16/2024

Why is there no KF_ANSWER_STATS data before a specific date?

Environment:

Oracle B2C Service

Resolution:

Note that portions of these tables are purged according to the KF_ACTIONABLE_DATA_PURGE_DAYS configuration setting. The default value for this setting is 45 days.  This value can be modified.

Cause:

The following tables were added in an earlier release (November 2011):

KF_ACTION_STATS
KF_ANSWER_STATS
KF_ERROR_STATS
KF_ESCALATION_SESSIONS
KF_ESCALATION_STATS
KF_REFERRER_STATS
KF_SA_LOG
KF_SEARCH_STATS
KF_SEARCHES
KF_SMARTASSISTANT_STATS
KF_TOP_ITEM_STATS

There is information on end user visits and answer views in the STATS and ANS_STATS tables.  Refer to the standard reports that reference these tables and the data dictionary for more information.