My Oracle Support Banner

Missing Tables from WebCenter Analytics Schema (Doc ID 1457633.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle WebCenter Portal - Version to [Release 11g]
Information in this document applies to any platform.



Symptom 1 Symptom 2
Analytics for WebCenter reports the error:

(collector.trc file)

"Analytics Service is not available: database schema is incomplete, please check Collector component has run successfully."

When attempting to use Analytics Collector, get errors:

[WC_Utilities] [ERROR] [] [] [tid: WebCenter Analytics Partition Manager] [ecid: <ECID>] [APP: analytics-collector#] Partition Manager Error. Skipping view for event {HTTP://<HOST>/ANALYTICS/WC}PAGEVIEWS and continuing...[[
java.sql.SQLSyntaxErrorException: ORA-04045: errors during recompilation/revalidation of PRD_ACTIVITIES.ASVFACT_WC_PAGEVIE_0
ORA-00955: name is already used by an existing object




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.