Missing Tables from WebCenter Analytics Schema

(Doc ID 1457633.1)

Last updated on NOVEMBER 19, 2016

Applies to:

Oracle WebCenter Portal - Version and later
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] [] [com.plumtree.analytics.partition.AbstractPartitionManager] [tid: WebCenter Analytics Partition Manager] [ecid: 7d34e1a14a6dea71:-705b74a7:150013374a4:-8000-0000000000000003,1:20926] [APP: analytics-collector#] 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




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