Missing Tables from WebCenter Analytics Schema (Doc ID 1457633.1)

Last updated on NOVEMBER 19, 2016

Applies to:

Oracle WebCenter Portal - Version 11.1.1.5.0 and later
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: 7d34e1a14a6dea71:-705b74a7:150013374a4:-8000-0000000000000003,1:20926] [APP: analytics-collector#11.1.1.4.0] Partition Manager Error. Skipping view for event {HTTP://WWW.ORACLE.COM/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

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