We are having difficulty performing a fresh installation of a CA Service Desk Manager 17.3 Application Server. An error message appears indicating that install was not successful . We are using uncompressed DVD0000000002102.iso Media on disk C:\CA. We have already installed Background and Standby normally, but we were not able to evolve in the first Application Server.
Release : 17.3
Component : SDM - Install/Upgrade/Configuration
Log entry of interest from the install.log
20XX/06/27 08.43.45.919 DEBUG [DeployThread: Configurando o CA Service Desk Manager] [ConfigureSDM] configLogScanner errMsg : 06/27 08:43:26.002 WARN ConfigThread.java 582 Configuration task (Iniciar CA Service Desk Manager serviço(s) no modo admin do bd.) is failed in step : 15
Above indicates that "Start CA Service Desk Manager service(s) in db admin mode" is failing.
In the corresponding stdlogs at that time:
06/27 08:43:43.78 SDM-SERVER.DOMAIN.COM confirm_db 276 SIGNIFICANT ntservice.c 311 Command return non-zero exit code. Command: redirect -m "C:\Windows\TEMP\tmp64" "C:\Windows\TEMP\tmp65" "C:/PROGRA~2/CA/SERVIC~1/bin/sql_check_db" -R -s SDM-SERVER.DOMAIN.COM >"C:\Windows\TEMP\tmp64" 2> "C:\Windows\TEMP\tmp65" . Exit Code: 98
06/27 08:43:43.90 SDM-SERVER.DOMAIN.COM confirm_db 276 SIGNIFICANT api_misc.c 585 Requesting shutdown of system. Reason (AHD50060:FALHA na verificação do banco de dados. )
06/27 08:43:43.92 SDM-SERVER.DOMAIN.COM slump_nxd 4960 EXIT server.c 2856 Slump_nxd was requested to shutdown. Check Prior log information.
The above shows an attempt to run the sql_check_db command to verify the given application server was part of the usp_servers environment, which is part of starting up SDM Services in DB Admin mode, but failed to complete the run (error AHD50060: Database verification failed)
The main root cause here is that the original application server specification in the usp_servers table was listed as SDM-SERVER, but the given app server was issued the full FQDN of SDM-SERVER.DOMAIN.COM.
If one tries to run the above sql_check_db on the SDM-SERVER manually, depending on parameters:
sql_check_db -R -s SDM-SERVER.DOMAIN.COM
This is the original command that the installer tried to run. It will return a warning that there is no entry in the usp_servers table matching server name "SDM-SERVER.DOMAIN.COM"
sql_check_db -R -s SDM-SERVER
Assuming that the given SDM-SERVER is present in the usp_servers table, the SDM-SERVER entry will be detected with a server type of "104" (Application server)
One must do one of the following: