ZDU blocked with Error There are still messages waiting in 'MQ1CPXXX'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

While performing the upgrade in ZDU from version 21.0.4HF1 to 21.0.5HF2, we are blocked in the last step with the following message :

When checking the content of the impacted table, with this kind of query:

select utl_raw.cast_to_varchar2(dbms_lob.substr(MQCP_MSG, 150))  from MQ1CP007;

We find indeed a record:

"UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(MQCP_MSG,150))"
"?^CP_CLCON01^  DVN2OWS00B0000V^  1"

Please note that while the switch from the PWP to the newer version, the old processes from node 2 in the old version were not automatically stopped as expected and the user manually stopped them.

Environment

Release : 21.0.5 HF2

Component: Automation Engine

Area: ZDU

Resolution

Solution:

To fix the issue, please delete the records from the impacted MQXCPYYY tables.

Example for this case:

truncate table mq1cp007

This should fix most cases, but in case after step 6, when clicking on Next the following error appears:

The required process of type 'PWP' is not at least '0001' times connected to the system.

To fix this you need to click on Back until being able to click on Rollback and then start all over again the ZDU, this time it will work fine.

Additional Information

There was a correction of a bug that could explain why records on tables MQXCPYYY could remain in the tables during the ZDU that was solved in Automation Engine 21.0.6 and superior:

Defect ID: AE-31740

Public Description: An bug has been fixed when the user clicks on Disconnect All Users button in ZDU, the process writes to both MQSETs on this CP to which the user is connected.