SDM Application server does not start and fails with AHD50060 error message

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

When trying to start an application server, it does not respond and in the log it shows the following message.

sql_prov_nxd            8636 SIGNIFICANT  sql_prov.c             217 Started up SQL Server provider  NAME=_prov  DATABASE=mdb
confirm_db              8000 VERBOSE      confirm_db.c           548 Check command ("D:/APPS/CA/SDM/bin/sql_check_db"   -c -s <application server name>)
confirm_db              8000 SIGNIFICANT  ntservice.c            311 Command return non-zero exit code. Command: redirect -m "C:\Windows\TEMP\tmp186" "C:\Windows\TEMP\tmp187" "NX_ROOT/bin/sql_check_db"   -c -s <application server name> >"C:\Windows\TEMP\tmp186" 2> "C:\Windows\TEMP\tmp187" . Exit Code: 1
confirm_db              8000 MILESTONE    confirm_db.c           608 DB pointing to different server ()
sqlagt:Default          2308 SIGNIFICANT  sql_agent.c            245 STARTUP of sql_agent:mdb:key_prov_nxd:Default
confirm_db              8000 SIGNIFICANT  api_misc.c             585 Requesting shutdown of system. Reason (AHD50059:Nombre de servidor primario no válido. Ejecute pdm_configure. La base de datos está configurada actualmente en el servidor. ().)

(translated: AHD50059:Invalid primary server name. Run pdm_configure. The database is currently configured on the server. ())

Other errors that might appear in the stdlog:

AHD50060  AHD50050  such as

AHD50050:DB confirmation failed. Reason: AHD50060:Database check FAILED.

Environment

Release : 17.3.X/ 17.4.X

Component : SDM - Configuration

Cause

duplicate sql_check_db files in NX_ROOT\bin folder

 

NX_ROOT\bin\sql_check_db.exe

and

NX_ROOT\sql_check_db (no extension) 

Resolution

1. Remove the duplicate file with no extension (NX_ROOT\sql_check_db) and keep NX_ROOT\bin\sql_check_db.exe.

2. Start SDM Services in the Application server.