OC 20.3.3 July Patch - query in OC_JUL2021_ORACLE.sql returns ORA-00942: table or view does not exist

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Query in OC_JUL2021_ORACLE.sql returns "ORA-00942: table or view does not exist" for query below:

ALTER TABLE OCMETRICNAMEDVIEW
DROP CONSTRAINT UNQ_VIEW_ACCOUNT_IDX1;

 

Environment

Release : 20.3

Component : UIM - INSTALL

Cause

This issue is seen when UIM 20.3.0 is not at version 20.3.3

Resolution

Per Operator Console 20.3.3 July 2021 Patch documentation, UIM 20.3.3 must be installed in order to install OC 20.3.3 monthly patches

See the following statement in link below: Patches Included: These Hotfixes can be applied on Operator Console 20.3.3 or on top of patches released in April/June 2021.

https://support.broadcom.com/download-center/solution-detail.html?aparNo=LU02219&os=MULTI-PLATFORM