User action logs LOGGED_TIME is getting logged in UTC regardless of the timezone set on TIBCO Spotfire Server.

User action logs LOGGED_TIME is getting logged in UTC regardless of the timezone set on TIBCO Spotfire Server.

book

Article ID: KB0075336

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

When user action logs are enabled on TIBCO Spotfire Server, it is observed that the value in "LOGGED_TIME" is logged in UTC timezone regardless of the timezone set on spotfire server and the "Log in Local time" configuration. This happens when the Spotfire database is hosted on AWS platform.
 

Resolution

The value in the LOGGED_TIME is never passed from the TIBCO Spotfire Server, it is calculated and inserted by the database itself, as a record of when the row actually got persisted. If the User Action database logger is set to log in local time, it is the local time of the database that gets logged.

In AWS, the default time zone for databases is UTC or may be set to a time zone different than the Spotfire Server machine time zone. To resolve, the time zone of the AWS database can be set to be in the same time zone as the Spotfire Server, according to this AWS article: https://aws.amazon.com/premiumsupport/knowledge-center/rds-change-time-zone

Issue/Introduction

Though "Log in Local time" is enabled on Spotfire server, LOGGED_TIME field is logged in UTC timezone where as ORIGINAl_TIME is logged based on the timezone set on Spotfire server. This article will give explain the reason behind the issue.

Additional Information

External: How do I change the time zone of my Amazon RDS DB instance? Doc: Action log generic entries