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

Last updated on JUNE 01, 2023

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)

Changes

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

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

Applies to:

Symptoms

Changes

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!