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 : 10/01/2019
Show Technical Document Details
Introduction:

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   ...............  "

 

Instructions:

To solve the issue follow next instructions:

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 SKIP_USP_PREFERENCES_AT_STARTUP to the NX,ENV file  executing the follow command :

pdm_options_mgr -c -s SKIP_USP_PREFERENCES_AT_STARTUP -v Yes  -a pdm_option.inst

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:

pdm_options_mgr -c -s SKIP_USP_PREFERENCES_AT_STARTUP -v Yes  -a pdm_option.inst -t