Values shown in the database tab are not updating correctly

Products

• CA Automic One Automation

Issue/Introduction

When looking at the contents of the database tab in the Automic Web Interface, the values present do not reflect what you see within the database directly or what load you expect on your system.

Cause

Artifacts left over from a ZDU (Zero Downtime Upgrade)

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

The database tab generates its values from the following SQL:

SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ1PWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ2PWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ1WP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ2WP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ1RWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ2RWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ1OWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ2OWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ1JWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ2JWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ1DWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQ2DWP 
SELECT COUNT(*)    DIVDB_Int4 FROM                  MQMEM
 
You'll note that both the MQ1 and MQ2 are queried and added together; if values are shown in both MQSets and you are not currently in a mixed mode, please review and plan with Support to remove the values from the non active MQSet.