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

book

Article ID: 221064

calendar_today

Updated On:

Products

CA Unified Infrastructure Management On-Premise (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;

 

Cause

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

Environment

Release : 20.3

Component : UIM - INSTALL

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