SQL Type warning "Truncated incorrect time value" when querying the v_fact_alarm_info duration label field.
search cancel

SQL Type warning "Truncated incorrect time value" when querying the v_fact_alarm_info duration label field.

book

Article ID: 186112

calendar_today

Updated On:

Products

CA Spectrum CA eHealth

Issue/Introduction

When running the following query on the srmdbapi.v_fact_alarm_info the customer is seeing the following warning:

SELECT alarm_key, set_time, clear_time, duration_label, duration_seconds, from v_fact_alarm_info where alarm_key=60;

 "Truncated incorrect time value" 35684808" 

Environment

Release : 10.3

Component : ACTIVATOR VM

Cause

The duration_label Field in the srmdbapi.v_fact_alarm_info table on the Spectrum Report Manager has hit a Type limit and is truncated to 838:59:59 as defined in the following mysql link:

 https://dev.mysql.com/doc/refman/5.7/en/time.html

Resolution

This is a mysql limitation documented in the following link:  https://dev.mysql.com/doc/refman/5.7/en/time.html

The workaround is to query the v_fact_alarm_info duration_seconds field instead of the duration_label field.