WebCenter Analytics Records No Visit Data And Reports "VisitManager - Error running sql: SELECT datediff" (Doc ID 1087361.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle WebCenter Analytics - Version 10.3.0.1 to 10.3.0.1
Information in this document applies to any platform.
*** Checked for relevance 30-APR-2014 ***

Symptoms

The WebCenter Analytics Collector stops recording visit information for events.

09 Apr 2010 10:12:54,050 ERROR VisitManager - Error running sql: SELECT datediff(millisecond,GETDATE(),STARTTIME) FROM ASSYS_VISITTAG WHERE ID=1
09 Apr 2010 10:12:54,050 WARN VisitManager - EXCEPTION LOG: shouldTag() [plumtree][SQLServer JDBC Driver][SQLServer]Difference of two datetime columns caused overflow at runtime.

Changes

Install or upgrade to WebCenter Analytics 10.3.0.1 for WebCenter Interaction.

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