WebCenter Analytics Storing Records with Different Date/Time than the Local Time
(Doc ID 1584112.1)
Last updated on SEPTEMBER 26, 2023
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 |