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 11.1.1.5.0 to 11.1.1.5.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

 

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] [] [com.plumtree.analytics.partition.AbstractPartitionManager] [tid: WebCenter Analytics Partition Manager] [ecid: <ECID>] [APP: analytics-collector#11.1.1.4.0] 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

 


 

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.