domsrvr takes a long time to start up.

Products

CA Service Desk Manager CA Service Management - Service Desk Manager

Issue/Introduction

The Service Desk object manager, or domsrvr, is responsible for building the object repository for Service Desk to use. As such, it's the Service Desk process which will most likely take the long to start up, and Service Desk will not be usable until this start up is complete.

There may also be reports in the stdlog of messages, suggesting heavy logging against the SQL Server. Such log entry examples:

sql_agent          6072 SIGNIFICANT  prov_base.c  717 
SQL Query has returned (275000) rows for (domsrvr/).  
SQL Statement (SELECT .., .., .., .. FROM <custom_table> ORDER BY .. )

Environment

Release: All releases of Service Desk

Cause

The problem could be due to MLIST and RLIST set to ON for the specific, often custom, table.

Resolution

If the domsrvr start up is slow, you should first of all check if MLISTS/RLISTS are turned on for any customised tables.

MLIST - A Master list containing an in-ram references to all of the objects in the factory. This list is kept in sync with the data repository.
RLIST - A Restricted Master list containing a subset of the objects in the factory. The subset is defined by a where clause. Other than this where clause, the RLIST is the same as the MLIST.

MLISTS and RLISTS are defined in majic files:

FACTORY {
  STANDARD_LISTS {
    SORT_BY "sym,code";
    MLIST ON | OFF ;   
    RLIST ON | OFF ;
    };
  REL_ATTR code ;
  COMMON_NAME sym ;
  FUNCTION_GROUP "admin" ;
} ;

and part of tuning the domsrvr is deciding whether to have MLISTS and RLISTS or not. If they are defined, they can speed application access and display, but they can also use up lots of domsrvr resources. The start up time of the domsrvr has known to be severely reduced by disabling MLISTS and RLISTS for custom tables.

Additional Information

For custom tables, check the definition of the appropriate object, defined in the .mod file or wsp.mods file (both files usually located in NX_ROOT\site\mods\majic).

Refer to ‘STANDARD_LISTS Optional Statement’ available at the link:

STANDARD_LISTS Optional Statement

MLIST ON|OFF Indicates whether to produce a master list, which includes all objects, using one of the following values:

Value Description:

ON Produces a master list (default if SORT_BY is specified)
OFF Does not produce a master list (default if SORT_BY is not specified or has no value defined)

RLIST ON|OFF Indicates whether to also produce a restricted list, which includes only the objects that meet the criteria in the WHERE clause, using one of the following values:

Value Description

ON Produces a restricted list (default if WHERE is specified)
OFF Does not produce a restricted list (default if WHERE is not specified or has no value defined.)

Set appropriately the MLIST and RLIST

RLISTs can speed up access and display but they use memory.
They are usually used in select windows.
Important! MLIST OFF must be specified if you specify RLIST OFF.