My Oracle Support Banner

Webcenter Analytics Storing Records With Different Date/Time That the Local Time (Doc ID 1584112.1)

Last updated on AUGUST 05, 2019

Applies to:

Oracle WebCenter Portal - Version 11.1.1.6.0 to 11.1.1.6.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

In the ACTIVITIES scheme ANALYTICS records are stored in GMT and not the actual local time.

Example:
Clicking around a webcenter portal application at 13:51 hours where the weblogic managed server is running with this option: -Duser.timezone=Europe/Amsterdam.  Then doing this query :

Get this output :

NAME TO_CHAR(MAX(FACT.OC
----------- -------------------
Spaces
Pages 2013-10-09 11:51:42
Portlets
Logins 2013-10-09 11:51:48
Searches
Wikis/Blogs 2013-10-09 11:51:47
Discussions

The  "select sysdate from dual"on the database returns the correct time.

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
Symptoms
Cause
Solution


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