Cannot use DSM Explorer "Message timeout [AMM003004]"

Document ID : KB000004237
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Unable to open DSM Explorer . Error message: "Message timeout [AMM003004]".

Recycling AMManager will make DSM Explorer functional but after few hours timeout messages will re-appear.

Environment:
CA Client Automation - All Versions
Cause:

The problem could happen due to bad queries leading to timeouts as in GUI and AMManager crashes as shown in the AMManager log excerpt below:

00001124|AMManager |DbImpl_Ado |DbImpl_Ado |002311|NOTIFY | evalSQLInfo sqlstate: HYT00 native error: 0 0x0 
00001124|AMManager |CDb |DbImpl_Ado |002644|NOTIFY | Error Message: ADO Version 6.1 - COM Error:
ErrorCode:-2147217871,WordErrorCode:3121, IDispatch error #3121, Query timeout expired, Microsoft SQL Server Native Client 10.0, (null) 
00001124|AMManager | | |000000|ERROR | ################# HW Exception occurred [PID:7572] ################ 
Resolution:

The solution is to delete the bad queries.

1.   Get the list of bad queries. 

    use mdb
     select query_uuid,count(*) as cnt from ca_query_def_contents   
     group by query_uuid
     order by cnt desc

2.   Get the name of the specific bad query
   
    use mdb
     Select * from CA_QUERY_DEF where QUERY_UUID=SPECIFIC-UUID-FROM-ABOVE

 

3.    Remove the bad Queries. There are 2 ways to do this:

       A.  Thru SQL:

        use mdb
       Delete from CA_QUERY_DEF_CONTENTS WHERE QUERY_UUID=SPECIFIC-UUID-FROM-ABOVE
 
       B.  Thru the GUI
       
            Go to DSM Explorer and delete the Query manually
 
   *** If the Query is used by a Policy or Group, then you will need to delete the Policy or Group first ****
Additional Information:

These same Queries, if they are linked to a Dynamic Group or Policies can cause Performance issue even after the GUI is open.