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 to
Information in this document applies to any platform.
*** Checked for relevance 30-APR-2014 ***


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.


Install or upgrade to WebCenter Analytics for WebCenter Interaction.


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