When CA Service Desk Manager (CA SDM) is started, the BOPLGIN process take a long time to complete/initialize.

Document ID : KB000056682
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When CA Service Desk Manager (CA SDM) is started, the BOPLGIN process take a long time to complete/initialize.  During this time, users are not able to log into CA SDM.

The following errors might be seen within the STDLOG:

"BOPLGIN not ready (status=xxxxx); request queued"

"SELECT USP_PREFERENCES.ANALYST_ID ,
USP_PREFERENCES.ARC_DOCS_TO_DISPLAY , USP_PREFERENCES.ASSIGNEE ,
USP_PREFERENCES.AUTHOR , USP_PREFERENCES.BU_RESULT ,
USP_PREFERENCES.CLASSIC_RESULTSET_CONTEXT , USP_PREFERENCES.CREATED_VIA ,
USP_PREFERENCES.CREATION_DATE , USP_PREFERENCES.CURRENT_ACTION ,
USP_PREFERENCES.CUSTOM1 , USP_PREFERENCES.CUSTOM2 , USP_PREFERENCES.CUSTOM3
, USP_PREFERENCES.CUSTOM4 , USP_PREFERENCES.CUSTOM5 ,
USP_PREFERENCES.CUSTOM_NUM1 , USP_PREFERENCES.CUSTOM_NUM2 ,
USP_PREFERENCES.DOC_ID , USP_PREFERENCES.DOC_TEMPLATE   ...............  "

Solution:

If there is a large amount of data within the MDB USP_PREFERENCES table, then the initialization of the CA SDM BOPLGIN process during startup may take a
long time to complete.

For this type of issue, you can introduce an NX variable in NX.ENV to alleviate the issue:

Add the following variable to the NX,ENV file:

@NX_SKIP_USP_PREFERENCES_AT_STARTUP=Yes

This variable will prevent the processing of USP_PREFERENCES entries by the BOPLGIN process during start-up.  As a result, users will always get the default web role instead of their last login role when they login to CA SDM after the CA SDM service is restarted.

Also ensure that this change is made to the NX_ROOT\PDMCONF\NX.env_nt.tpl file to ensure that the change is not removed the next time CA SDM Configuration is executed.