CA Service Management

  • 1.  ca sdm upgradation from 12.5 to 17.0

    Posted Jun 16, 2017 04:58 AM

    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



  • 2.  Re: ca sdm upgradation from 12.5 to 17.0

    Broadcom Employee
    Posted Jun 16, 2017 09:59 AM

    Check for existence of C:\NX.env on both machines and make sure they are in sync.  That file contains an encrypted password that the SDM daemons use to connect to the database. 

     

    Failure on the second box seems to indicate that the above file is different between the two servers.

     

    _R



  • 3.  Re: ca sdm upgradation from 12.5 to 17.0

    Broadcom Employee
    Posted Jun 16, 2017 10:51 AM

    what error you see if you manually run "sql_check_db -c" from command line on the server?



  • 4.  Re: ca sdm upgradation from 12.5 to 17.0

    Posted Jun 17, 2017 01:51 AM

    i have run sql_check_db -c on server  and its showing

    unable to log in to sql server so what i do now 

     

    Terminating : (F:/PROGRA~1/CA/SERVIC~1/bin/sql_prov_nxd _prov mdb) MPID: 18 PID: 4852
    06/17 09:47:00.02 delsdvipnew sql_agent 5856 SIGNIFICANT sql_agent.c 275 SHUTDOWN of sql_agent:mdb:_prov:
    06/17 09:47:00.02 delsdvipnew proctor_delsdvipn 3656 SIGNIFICANT pdm_process.c 887 Process stopped (F:/PROGRA~1/CA/SERVIC~1/bin/sql_prov_nxd _prov mdb return: 0
    06/17 09:47:00.02 delsdvipnew proctor_delsdvipn 3656 SIGNIFICANT pdm_process.c 896 Stopped: F:/PROGRA~1/CA/SERVIC~1/bin/sql_prov_nxd _prov mdb
    06/17 09:47:04.01 delsdvipnew proctor_delsdvipn 3656 SIGNIFICANT agt_slump_if.c 973 SHUTTING DOWN PROCTOR: proctor_delsdvipnew
    06/17 09:47:05.02 delsdvipnew pdm_d_mgr 5036 SIGNIFICANT daemon_obj.c 2985 ehc: waiting more than 120 seconds for agent to confirm. Marking as stopped.
    06/17 09:47:09.05 delsdvipnew pdm_d_mgr 5036 SIGNIFICANT mgr_os_if.c 1891 >>>>>> Daemon Manager shutting down <<<<<<
    06/17 09:47:03.52 delsdvipnew pdm_d_mgr 4300 SIGNIFICANT ntservice.c 311 Command return non-zero exit code. Command: sql_check_db -c. Exit Code: 99
    06/17 09:47:03.52 delsdvipnew pdm_d_mgr 4300 SIGNIFICANT mgr_os_if.c 2834 Unable to connect to SQL Server database mdb on server del-sql-clus
    06/17 10:32:46.17 delsdvipnew domsrvr 4700 SIGNIFICANT miscos.c 298 Multi-tenancy is OFF - single tenant environment
    06/17 10:32:46.17 delsdvipnew domsrvr 4700 SIGNIFICANT domsrvr.c 608 STARTUP of domsrvr in multi-process mode; Spel: spel_srvr; virtdb: bpvirtdb_srvr
    06/17 10:32:46.17 delsdvipnew domsrvr 4700 SIGNIFICANT api.c 986 Slump object hash created with 131072 entries (2**17)
    06/17 10:32:51.18 delsdvipnew domsrvr 4700 SIGNIFICANT api.c 850 SLUMP api: failed to make connection (Operation not permitted (1))
    06/17 10:32:51.18 delsdvipnew domsrvr 4700 SIGNIFICANT miscos.c 189 Exiting normally



  • 5.  Re: ca sdm upgradation from 12.5 to 17.0

    Broadcom Employee
    Posted Oct 05, 2017 02:44 PM

    Hello - 

    Please let us know if you have already created a support case for this question.   Our recommendation, if you having a problem with the upgrade, you should consult with CA support for assistance.  If you don't require additional help, please mark the answer correct.  

     

    Thank You,



  • 6.  Re: ca sdm upgradation from 12.5 to 17.0