WCI Analytics: Collector Service No Longer Updates the Back-End Oracle Database with New Events (Doc ID 1618185.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle WebCenter Analytics - Version 2.5 to 10.3.0.1
Information in this document applies to any platform.

Symptoms

In a WCI Analytics environment the collector service no longer updates the back-end Oracle database with new events. The collector service log contains errors like the following:

WARN JDBCExceptionReporter - SQL Error: 0, SQLState: HY000
ERROR JDBCExceptionReporter - [plumtree][Oracle JDBC Driver]Numeric overflow.
ERROR BasePersistableObject - Failed to store object: org.hibernate.exception.GenericJDBCException: could not get next sequence value
ERROR PageViewHandler - genPageViewEvent error:
java.lang.NullPointerException
at com.plumtree.analytics.collector.cache.ALICacheManager.getRefererId(ALICacheManager.java:211)
at com.plumtree.analytics.collector.eventhandler.PageViewHandler.handle(PageViewHandler.java:93)
at com.plumtree.analytics.collector.DataResolver.handleEvent(DataResolver.java:168)
at com.plumtree.analytics.collector.DataResolver.run(DataResolver.java:129)

 

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