AnsweredAssumed Answered

ca sdm upgradation from 12.5 to 17.0

Question asked by EMSADMIN on Jun 16, 2017
Latest reply on Oct 5, 2017 by Anthony_L

Hi ,

 

we going to upgrade ca sdm from 12.5 to 17.0 .


1) install sql 2008 on both server node with cluster installation
2) after successful installation of sql both node install CA 12.5 MDB on DATA BAse after the ca mdb installation ServiceDesk user automattically created.

CA SDM APP SERVER
1) Now install CA sdm 12.5 application on app server node 1application successfully installed on node and SDM properly working.
Note installation path of ca sdm E:means cluster disk.
2) Restart node 1 now come to node 2 on app server with cluster disk
and install Ca sdm application and installation path same f drive cluster. Ca SDM App installtion successfully installed on node and SDM properly working.

Note configure all SDM services resource on cluster same as live production

But when we restart 1 node cluster disk and sdm services moved to node 2 both CA SDM odbc services coming online but CA SDM Manager services showing pending online and after some time failed.

 

Search in log file.
06/16 12:44:29.69 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT agent_os_if.c 1146 Terminating : (F:/PROGRA~1/CA/SERVIC~1/bin/ldap_virtdb) MPID: 25 PID: 1572
06/16 12:44:29.69 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 887 Process stopped (F:/PROGRA~1/CA/SERVIC~1/bin/ldap_virtdb return: 0
06/16 12:44:29.69 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 896 Stopped: F:/PROGRA~1/CA/SERVIC~1/bin/ldap_virtdb
06/16 12:44:30.69 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT agent_os_if.c 1146 Terminating : (F:/PROGRA~1/CA/SERVIC~1/bin/bpvirtdb_srvr -n 6 -x 6) MPID: 21 PID: 3572
06/16 12:44:30.69 delsdvipnew sqlagt:Act_Log 3064 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Act_Log
06/16 12:44:30.69 delsdvipnew sqlagt:Kpi_Ticket 3208 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Kpi_Ticket_Data Kpi_Data
06/16 12:44:30.69 delsdvipnew sqlagt:EBR_FULLTE 1372 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:EBR_FULLTEXT EBR_FULLTEXT_ADM EBR_KS_INDEXING_QUEUE
06/16 12:44:30.69 delsdvipnew sqlagt:Issue_Act_ 1824 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Issue_Act_Log
06/16 12:44:30.69 delsdvipnew sqlagt:CREATE_IND 2448 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:CREATE_INDEX
06/16 12:44:30.69 delsdvipnew sqlagt:Issue 3620 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Issue
06/16 12:44:30.69 delsdvipnew sqlagt:Change_Req 1708 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Change_Request
06/16 12:44:30.69 delsdvipnew sqlagt:Call_Req 3836 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Call_Req
06/16 12:44:30.69 delsdvipnew sqlagt:Change_Act 3080 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Change_Act_Log
06/16 12:44:30.69 delsdvipnew sqlagt:upinde 2696 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:upinde
06/16 12:44:30.69 delsdvipnew sqlagt:select5 3464 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:select5
06/16 12:44:30.69 delsdvipnew sqlagt:Audit_Log 3828 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:Audit_Log event_log session_log
06/16 12:44:30.69 delsdvipnew sqlagt:BU_TRANS 2200 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:BU_TRANS
06/16 12:44:30.69 delsdvipnew sqlagt:select0 2712 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:select0
06/16 12:44:30.69 delsdvipnew sqlagt:select4 3176 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:select4
06/16 12:44:30.69 delsdvipnew sqlagt:select2 1356 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:select2
06/16 12:44:30.69 delsdvipnew sqlagt:select3 1120 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:select3
06/16 12:44:30.69 delsdvipnew sqlagt:select1 3984 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:bpvirtdb_srvr:select1
06/16 12:44:30.69 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 887 Process stopped (F:/PROGRA~1/CA/SERVIC~1/bin/bpvirtdb_srvr -n 6 -x 6 return: 0
06/16 12:44:30.69 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 896 Stopped: F:/PROGRA~1/CA/SERVIC~1/bin/bpvirtdb_srvr -n 6 -x 6
06/16 12:44:31.70 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT agent_os_if.c 1146 Terminating : (F:/PROGRA~1/CA/SERVIC~1/bin/license_nxd) MPID: 10 PID: 3968
06/16 12:44:31.70 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 887 Process stopped (F:/PROGRA~1/CA/SERVIC~1/bin/license_nxd return: 0
06/16 12:44:31.70 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 896 Stopped: F:/PROGRA~1/CA/SERVIC~1/bin/license_nxd
06/16 12:44:32.71 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT agent_os_if.c 1146 Terminating : (F:/PROGRA~1/CA/SERVIC~1/bin/sql_prov_nxd _prov mdb) MPID: 18 PID: 3864
06/16 12:44:32.71 delsdvipnew sql_agent 4288 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:_prov:
06/16 12:44:32.71 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 887 Process stopped (F:/PROGRA~1/CA/SERVIC~1/bin/sql_prov_nxd _prov mdb return: 0
06/16 12:44:32.71 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT pdm_process.c 896 Stopped: F:/PROGRA~1/CA/SERVIC~1/bin/sql_prov_nxd _prov mdb
06/16 12:44:33.71 delsdvipnew proctor_delsdvipn 2452 SIGNIFICANT agt_slump_if.c 973 SHUTTING DOWN PROCTOR: proctor_delsdvipnew
06/16 12:44:38.75 delsdvipnew pdm_d_mgr 4036 SIGNIFICANT mgr_os_if.c 1891 >>>>>> Daemon Manager shutting down <<<<<<
06/16 12:44:34.08 delsdvipnew pdm_d_mgr 1488 SIGNIFICANT ntservice.c 311 Command return non-zero exit code. Command: sql_check_db -c. Exit Code: 99
06/16 12:44:34.08 delsdvipnew pdm_d_mgr 1488 SIGNIFICANT mgr_os_if.c 2834 Unable to connect to SQL Server database mdb on server del-sql-clus

Outcomes