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

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
    341 Posts
    ACCEPTED ANSWER

    Re: Inconsistent status

    ‏2012-10-23T17:00:51Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: Inconsistent status

      ‏2012-10-23T18:39:57Z  in response to jcdelmo
      I have asked to open PMR. They will pass the messages related to the query.

      Thank you again