Why Is The Oracle Knowledge Analytics DW_STG_DATA Table Populated With Many Unused Events? (Doc ID 1667341.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Knowledge - Version 8.5.1 and later
Information in this document applies to any platform.

Symptoms

The Oracle Knowledge Analytics DW_STG_DATA table is populated with unused events.  These events have already been coded into the product code for future reports that could be added.

FacetEvent
ConceptEvent
UserSegmentEvent
AuthenticationTimedOut

ForumTopicDelete
ForumMessageDelete
ForumMessageUpdate message published and unpublished.
ForumTopicUpdate topic published and unpublished

AuthenticationAccountLockout
AuthenticationPasswordResetProcessed
UserReputationEvent
PortletEvent

These events can be disabled so as to not take up space in the dw_stg_data table.  They can also be deleted from the dw_stg_data 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