#1120 [HHQ-1759] Resource availability display randomly turns gray

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-1759
Availability indicator on resource indicator page is not reliable. The entire time line turns gray where it was green, and its seems to be doing this randomly (sometimes on page refresh or navigating to another page and then coming back to indicator charts page).

Database seems to be storing the availability values fine and once in a while I see green/red/yellow dots placed correctly. But at other times they are all gray. Here is a groovy script I am using to get RLE timestamps in readable formats and compare them with UI.

import groovy.sql.Sql


import java.sql.Timestamp

def sql = Sql.newInstance('jdbc:postgresql://10.0.0.5:9432/hqdb?protocolVersion=2', 'username', 'password', 'org.postgresql.Driver')

sql.eachRow('''select startime, endtime, availval, coll_interval, er.name from hq_avail_data_rle r, eam_measurement m, eam_resource er, eam_resource_type rt


    where r.measurement_id=m.id


    and m.resource_id=er.id


    and er.resource_type_id=rt.id


    and er.name like \'qa1%CPU%\'''') { row ->


        Timestamp start = new Timestamp(row.startime)


        Timestamp end = new Timestamp(row.endtime)


        println start.toString() + "\t" + end.toString() + "\t" + row.availval + "\t" + row.coll_interval + "\t" + row.name


}