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.
Release : 17.3.X/ 17.4.X
Component : SDM - Configuration
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)
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.