Post upgrade to UIM 20.4 AC loads slowly, or times out, nas crashes and data_engine queues

book

Article ID: 241739

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM) DX Unified Infrastructure Management (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM) Unified Infrastructure Management for Mainframe

Issue/Introduction

Upgraded UIM/Nimsoft from version 9.0.2 to 20.4.

- After upgrade, Admin Console page loads very slowly and gives request timeout most of the time.

We have also increased java initial time but page still loads slowly. Load page time: 50 sec.

- NAS is crashing over and over.

- data_engine messages remain queued:

May 14 14:20:37:627 [14168] 1 de: Creating bulk object - table: RN_QOS_DATA_0048 for qos: QOS_ORACLE_SORT_RATIO 
May 14 14:20:38:084 [4580] 3 de: Database_global_lock LOCK 
May 14 14:20:38:084 [4580] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:084 [4580] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:087 [15148] 3 de: Database_global_lock LOCK 
May 14 14:20:38:087 [12724] 3 de: Database_global_lock LOCK 
May 14 14:20:38:087 [13632] 3 de: Database_global_lock LOCK 
May 14 14:20:38:087 [15148] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:087 [15948] 3 de: Database_global_lock LOCK 
May 14 14:20:38:087 [4784] 3 de: Database_global_lock LOCK 
May 14 14:20:38:087 [4068] 3 de: Database_global_lock LOCK 
May 14 14:20:38:087 [7580] 3 de: Database_global_lock LOCK 
May 14 14:20:38:087 [15148] 1 de: monitor_thread - exit worker thread 
May 14 14:20:38:087 [12724] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:089 [12724] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:089 [13632] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:089 [13632] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:089 [15948] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:089 [15948] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:089 [4784] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:089 [4784] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:089 [4068] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:089 [4068] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:089 [7580] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:089 [7580] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:111 [9856] 3 de: Database_global_lock LOCK 
May 14 14:20:38:111 [9856] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:111 [9856] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:112 [14172] 3 de: Database_global_lock LOCK 
May 14 14:20:38:112 [14172] 3 de: Database_global_lock UNLOCK 
May 14 14:20:38:112 [14172] 1 de: commit_thread - exit worker thread 
May 14 14:20:38:161 [11876] 0 de: qos_data_thread - stop received ... 
May 14 14:20:38:161 [11876] 3 de: Before WaitForSingleObject 
May 14 14:20:38:290 [3424] 3 de: [LSV] has disconnected from database

Cause

- data_engine restarting/connectivity intermittent, plus leftover webapp artifacts

Environment

Release : 20.4

Component : UIM NAS

wasp 20.40

Resolution

1. Admin Console slowness

- Resolved as a result of the resolution for the data_engine which was frequently restarting as well as deleting leftover webapps from the Primary hub wasp which are no longer used/valid.

2. NAS crashing

- This is a known issue with LUA scripts in nas v9.34 which is resolved in nas v9.34HF1. Once this was applied the nas crashing subsided.

  Release notes:
  Fixed the crash issue due to Lua Script  (Upgrade on probe version 9.34)
  Removed the 'override' from cfx which can be seen in fresh installation only

3. data_engine

data_engine queueing messages was resolved by manually running the data_engine sqlserver_update_qos_type.sql script in MS SQL Server Studio so we could see a successful result, since based on the data_engine log entries, the data_engine seemed to stall when running that specific script but would finish without error after some time.