My Oracle Support Banner

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] [] [] [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




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.