Reduce the visualizer startup time when many locations are defined

book

Article ID: 211487

calendar_today

Updated On:

Products

CA Service Desk Manager

Issue/Introduction

Issue:
======
In multi tenancy set up, with several locations defined the visualizer process is taking more time to start. It is scanning all the rows from ca_location.

Environmental Details:
====================
USRD 17.3 RU1/Windows

Steps:
======
-> If there are 32.215 locations defined then the Visualizer to start needs 3:30 minutes.  
   For testing reduced the locations to start with 504 locations and it needs about a minute.

-> stdlog is filled with below statements:
"SQL Query has returned (30000) rows for (domsrvr/). Clause (SELECT ca_location.location_name, ca_location.location_uuid FROM ca_location WHERE ( ca_location.inactive = 0 ) AND ( ca_location.parent_location_uuid IS NULL AND ca_location.location_type_id IS NULL ) ORDER BY ca_location.location_name ASC) Input (<None>)"

Environment

Release : 17.3

Component : CA CMDB VISUALIZER

Resolution

This is a known defect and is currently under investigation by Engineering team with defect id - DE58102.
Kindly raise a case with support to know the status of Defect.