Service Desk manager not getting started after pdm configure

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

After running pdm_configure on background server, the following errors appear on startup. 

12/06 07:56:24.24 hostname        bu_daemon           75421 SIGNIFICANT  BURate.c               754 KT bubble-up processing will start at 12/07/2021 00:00:00 and end at 12/07/2021 07:00:00
12/06 07:56:24.74 hostname        boplgin             74818 SIGNIFICANT  bplhndlr.c            2019 Restoring 0 sessions from domsrvr:wsp
12/06 07:56:24.76 hostname        boplgin             74818 SIGNIFICANT  bplhndlr.c            2019 Restoring 0 sessions from domsrvr
12/06 07:56:24.76 hostname        boplgin             74818 SIGNIFICANT  bplhndlr.c            1330 Boplgin initialization is complete
12/06 07:56:24.96 hostname        rep_daemon          75420 SIGNIFICANT  RepDaemon.c            408 Repository daemon is ready for action!
12/06 07:56:25.63 hostname        kt_daemon           75277 SIGNIFICANT  KTDaemon.c            1259 KT daemon ready for action!
12/06 07:56:25.65 hostname        domsrvr             75181 SIGNIFICANT  factory.c             1599 Factory grpmem has no last mod date attribute
12/06 07:56:25.69 hostname        bpvirtdb_srvr       74982 ERROR        vdbsql.c              5382 Process (domsrvr) already holds lock requested for Table (USP_PREFERENCES) Lock ID(1) on behalf of ((NULL))
12/06 07:56:25.69 hostname        kt_daemon           75277 ERROR        pref.c                 131 Cpref: sync_pref_usp_properties failed In method sync_pref_usp_properties_getData_mass_update. Error Message: Error 101 KT_CO_FAILRUE cnt_id 00 cnt_combo_name  cnt_phone_number
12/06 07:56:25.69 hostname        kt_daemon           75277 ERROR        MassUpdate.c           491 Unknown method:'CMassUpdate::Free_uncheck', when opcode: ' mass_update' passed to CMassUpdate


The login page is coming up but after login it is redirecting to the login page again and below errors are seen in the stdlog:

12/06 08:06:47.51 hostname        web:local           74821 SIGNIFICANT  session.c            11048 Session 1480216063:0x0xb2f6120 login by analyst 43995305 (cnt:E55BD6FF530E01F69AAC005056B80855); session count 1
12/06 08:06:47.52 hostname        boplgin             74818 SIGNIFICANT  bplaccess.c           5602 BOP Security timeout set to 30 seconds
12/06 08:06:47.52 hostname        web:local           74821 SIGNIFICANT  session.c             8370 Session 43995305-1480216063:0xb2f6120 redirected to another webengine; session count 0
12/06 08:06:48.96 hostname        bpvirtdb_srvr       74982 ERROR        vdbsql.c              5382 Process (domsrvr) already holds lock requested for Table (usp_bopsid) Lock ID(438452) on behalf of ((NULL))
12/06 08:06:48.96 hostname        boplgin             74818 ERROR        bplhndlr.c            2177 BOPSID_Handler error. Method:checkout_done Error:NO AHD04118:1 records didn't lock 00
12/06 08:06:48.98 hostname        boplgin             74818 SIGNIFICANT  bplaccess.c           5522 AHD04012:Security id () not found or has expired
12/06 08:06:48.98 hostname        web:primary:2       74886 SIGNIFICANT  session.c            20525 Unable to validate artifact/bopsid: AHD04012:Security id () not found or has expired

Environment

Release : 17.2

Component : SDM - Install/Upgrade/Configuration

Resolution

Problem was caused by old rows in USP_BOPSID table of the mdb. Stopped SDM cleanly, deleted all but the most recent rows from the table, and restarted. The datestamp in the database is in Unix format; delete all more than a day old.