This looks like a problem. The following SQL gives a count of 6653
from dmh.dmh_activity_log al
join dmh.dmh_member mem on mem.member_id = al.related_id_1 and al.cmpnt_type_id = 1 and mem.analysis_status_cd = 'C'
where al.rc >=8
There are compile units that have red messages but a complete status.
This topic has been locked.
2 replies Latest Post - 2012-10-23T18:39:57Z by SystemAdmin
Pinned topic Inconsistent status
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-23T18:39:57Z at 2012-10-23T18:39:57Z by SystemAdmin
jcdelmo 0600012HN8339 Posts