Page History

...

select host_id
from entity_latest_data_sample
where host_id not in (select entity_id from entity);

select host_id from entity_latest_data_sample where host_id not in (select entity_id from entity); For each ID that is listed from the above query, run the following two queries (replace , replacing <ID> with the ID number). The first query should return an empty set but the second should have one or more results.

select entity_id
from

...

 entity
where entity_id=<ID>;

select *

...

from entity_latest_data_sample
where host_id=<ID>;

To remove the erroneous performance data that is causing this issue, run the following delete statement.

delete from entity_latest_data_sample where host_id=<ID>;

Once the delete statement has been run runs for each of the ID's IDs from the first query, view the GlobalScan Global Scan page to verify that the issue has been is resolved.