We are seeing duplicate Model_Keys in our AlarmInfo table in our Reporting Database

book

Article ID: 211777

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

I have come across an issue which looks to be possible corruption in the alarminfo table.

If you look at the following query there are entries in the alarminfo table for the same model_key which have different model_h and landscape_h values. 

This is just one example, I have seen others.

 

mysql> select model_key, hex(model_h), hex(landscape_h), count(*) c from alarminfo where model_key = 6173602 group by model_h order by c desc limit 10;

+-----------+--------------+------------------+--------+

| model_key | hex(model_h) | hex(landscape_h) | c      |

+-----------+--------------+------------------+--------+

|   6173602 | 3639EA9      | 3600000          | 945401 |

|   6173602 | 2A39EA9      | 2A00000          |  12201 |

|   6173602 | A39EA9       | A00000           |   6984 |

|   6173602 | 939EA9       | 900000           |   5826 |

|   6173602 | 3439EA9      | 3400000          |   5486 |

|   6173602 | 1539EA9      | 1500000          |   5249 |

|   6173602 | 1039EA9      | 1000000          |   4843 |

|   6173602 | 1939EA9      | 1900000          |   3496 |

|   6173602 | 1639EA9      | 1600000          |   1996 |

|   6173602 | 2039EA9      | 2000000          |   1976 |

+-----------+--------------+------------------+--------+

10 rows in set (2.53 sec)

 

mysql> 

 

Cause

Software bug allowed for the Model_Key to be duplicated in the Reporting Database on different landscapes.

Environment

Release : 10.4.2.1

Component : Spectrum Reporting

Resolution

For Spectrum 10.4.2.1 Please request patch 10.04.02.01.D110 that resolves the problem.  This will be addressed out of the box in future releases of Spectrum

Additional Information

This is fixed out of the box in Spectrum 21.2.1

 

Symptom: Model_key is duplicated in the alarminfo table.
Resolution: Code changes are made to retrieve the actual mode_h and corresponding key for the alarm. (DE490567, 32478017, 21.2.1)