Topic
  • 2 replies
  • Latest Post - ‏2012-10-23T18:39:57Z by SystemAdmin
SystemAdmin
SystemAdmin
849 Posts

Pinned topic Inconsistent status

‏2012-10-23T15:44:45Z |
This looks like a problem. The following SQL gives a count of 6653

select count(*)
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.
Updated on 2012-10-23T18:39:57Z at 2012-10-23T18:39:57Z by SystemAdmin
  • jcdelmo
    jcdelmo
    347 Posts

    Re: Inconsistent status

    ‏2012-10-23T17:00:51Z  
    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' ?
  • SystemAdmin
    SystemAdmin
    849 Posts

    Re: Inconsistent status

    ‏2012-10-23T18:39:57Z  
    • jcdelmo
    • ‏2012-10-23T17:00:51Z
    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' ?
    I have asked to open PMR. They will pass the messages related to the query.

    Thank you again