My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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.