Analytics Dashboard in AWI is ignoring the Timezone (TZ) that is set in the AWI Settings

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Introduction

To display the correct Start and End times of Tasks in Analytics Dashboard, you have to set a Timezone (TZ) in the AWI Settings of the user or in the client.

This is done according to the explanation in this page:

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Dashboards/awi_dashboards_widgets_analytics.htm

However, even with the correct TZ object set, the Dashboard shows UTC times for Start and End times.

 

Investigation:

• In <Tomcat>/webapps/awi/config/logback.xml set change <root level="INFO">  to <root level="DEBUG"> and restart Tomcat
• Log in to AWI and open a Analytics Dashboard of type Table Chart
• Open <Tomcat>/logs/<server>_awi_LOG01.txt and search (from the bottom up) for 'defaulting to UTC'

You will find a line like this:

2021-03-12 14:50:23,287 pool-2-thread-210      [WARN ] <SYSTEM>@<server>:<client>/<USER>/<DEPARTMENT 727 0000000006166215 +214 [cs.ui.entrypoint.AnalyticsPluginInstance] - Non-standard time zone '???' configured, defaulting to UTC.

For instance on a system called AUTOMIC on server servername.example with user AUTOMIC and department UC4:

2021-03-12 14:50:23,287 pool-2-thread-210      [WARN ] [email protected]:22/AUTOMIC/UC4 727 0000000006166215 +214 [cs.ui.entrypoint.AnalyticsPluginInstance] - Non-standard time zone 'TZ.FRANCE' configured, defaulting to UTC.

 

Environment

Release : 12.3

Component : ANALYTICS ON PREMISE

Cause

In the case of the TZ object the Title field of the object has an additional function:

When adding the name of your time zone (according to the format explained below) it will be used for as the time zone in the Analytics Dashboard instead of the name of the TZ object.

However, if the Title has any other format, it will be rejected and the Dashboard will default to UTC.

Resolution

Make sure that the General > Title of the Timezone (TZ) object is empty or contains a timezone from this list:

https://www.geeksforgeeks.org/timezone-getavailableids-method-in-java-with-examples/

(Or see attached file)

Any other values for the Title field will result in UTC time.

 

So, for instance, to get the right time zone in the Analytics Dashboard for time zone Singapore, the options are:

• Setting object name PRC (as indicated in the doc) with the Title field <empty>
• Setting object name to anything but with Title field 'Asia/Singapore'
• Of course setting object name PRC (as indicated in the doc) with the Title field 'Asia/Singapore' will also work.