Upgrading to CU6, PRD very slow and no data
search cancel

Upgrading to CU6, PRD very slow and no data

book

Article ID: 263817

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After we upgrade to 20.4 CU6, PRD show null. 

However, we still have OC 20.4 CU4, we can see both data and null for same host.

 

Environment

UIM : 20.4 CU6

OC : 20.4 CU6

Resolution

Apply the script ( Attached )  in the database and verify the PRD. 

  1. Connect to the Database using any Client Tool (Like SQL Server Management Studio)
  2. Backup the current stored procedure named - prdReportData_Raw
  3. Load and run the attached script 

    prdReportData_Raw-SQLServer.sql - For MS SQL Server

    prdReportData_Raw-Oracle.sql - For Oracle 

    prdReportData_Raw-MySql.sql - For MySql 

  4. Verify PRD rendering.

Note:-

PRD performance fixes for CU7

Attachments

prdReportData_Raw-SQLServer_1681294766054.sql get_app
prdReportData_Raw-Oracle_1681294757645.sql get_app
prdReportData_Raw-MySql_1681294744643.sql get_app