Calculated data locks and time zones

Products

• CA Business Service Insight

Issue/Introduction

Do calculated data locks take time zones into account and is it possible to see the date specified down to the hour?

Environment

CA Business Service Insight 8.3.5.x and 9.0

Resolution

CA Business Service Insight stores all dates in the database in GMT format.

In most places, the dates are adjusted to the user's time zone as needed.

However for calculated data locks, in order to keep things simple in the event that you are locking multiple contracts which could be in different time zones, the calculated data lock screen uses all dates in the GMT time zone. This means that when you specify a calculated data lock, your user time zone and the time zone of the contract are not taken into account. You are specifying a GMT time zone and this is stored directly to the database.

Before you specify a calculated data lock, you should make sure that the contract is fully calculated and do not specify the date up to such a recent period of the contract that the fact this is specified in GMT will cause problems. If you want to see the data locks down to the hour, you can run the following query against the database:

select SLA_NAME, to_char(CALCULATION_FREEZE_DATE,'mm/dd/yyyy hh24:mi:ss') from T_SLAS;