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.
USRD 17.3 RU1/Windows
-> 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>)"
Release : 17.3
Component : CA CMDB VISUALIZER
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.