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.
jcdelmo 0600012HN8369 Posts
Re: Inconsistent status2012-10-23T17:00:51ZThis is the accepted answer. This is the accepted answer.Would you be able to give a (complete) list of the 'red' messages, so analysis can be done on which are not properly setting the analysis_status_cd to 'E' ?