book
Article ID: 186112
calendar_today
Updated On:
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"
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.