Automic Workload Automation

  • 1.  Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted Apr 22, 2019 11:15 AM

    We need to install high availability for the UC4 database servers.
    Is anyone aware about what configuration setting need to be done on UC4 side.
    The database we are using is SQL Server 2014
    Automation Engine Version: 12.1.0



  • 2.  Re: Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted Apr 25, 2019 04:17 PM

    We use a cname for the SQL availablity group(s). 

    Point the ODBC connection on the Automation Engine to the Cname. 

    Use the cname in the SQLDRIVERCONNECT Statement 

    SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,DSN=<Cname>;UID=<SqlServiceAccount>;PWD=<--encryptedpassword>



  • 3.  Re: Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted Apr 30, 2019 10:16 AM

    Cname means Cluster Name ?
    And what about the jdbc connection string . Will we not require to update that?



  • 4.  Re: Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted Apr 30, 2019 10:32 AM

    CNAME records can be used to alias one name to another.   

    EVERY config file that utilizes an SQLDRIVERCONNECT statement will need to have the statement updated with the cname. The cname is the name assigned to the SQL high availability group.



  • 5.  Re: Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted Apr 30, 2019 10:38 AM

    Yes, we have tried using that earlier , but the application doesn't seem to come up when SQL team switches to the secondary node.
    I was suspecting if we were missing on some other setting.
    AE is unable to find the tables on the secondary node as per the WP logs.
    And we are unable to login to AE.



  • 6.  Re: Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted May 03, 2019 09:52 AM

    We performed the below steps while working on Testing HA Configuration.

    1. Modified ODBC connection 
    2. Modified .ini config file - all SQLDRIVERCONNECT statements
    3. Shutdown UC4 application
    4. Stopped DB Services on both SQL nodes.
    5. Rebooted node 1
    6. Rebooted node 2
    7. started DB services on both servers
    8. Rebooted application server
    9. Failover to secondary node 
    10. Tried starting UC4 application - We were unable to start any of the WP's and CP's.

     

    The WP logs showed the below error:

     

    20190502/182848.814 - U00003526 UCUDB: Database version ('0.0.0') does not match your program version ('12.1.0').

    20190502/182848.814 - U00003611 DB OPEN executed. Return Code = '0000003526'

    20190502/182848.814 - U00003620 Routine 'UCMAIN_R' forces trace because of error.

    20190502/182848.814 - U00003526 UCUDB: Database version ('0.0.0') does not match your program version ('12.1.0').

    20190502/182848.881 - U00003449 Output to the TRACE file is finished.

    20190502/182848.883 - U00003450 The TRACE file was opened with the switches '0000000000000000'.

    20190502/182848.884 - U00003380 Server 'UC4Q#WP' version '12.1.0+hf.1.build.1342' (Runtime '0/00:00:00', Log# '1', Trc# '1').

    20190502/182848.884 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.

    20190502/182848.884 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.

    20190502/182848.886 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: ca7000  DB-HDBC: ca70e0

    20190502/182848.886 - U00003591 UCUDB - DB error info: OPC: 'SQLNumResultCols' Return code: 'ERROR'

    20190502/182848.886 - U00003592 UCUDB - Status: '42S02' Native error: '208' Msg: 'Invalid object name 'ABLOB'.'

    20190502/182848.886 - U00003592 UCUDB - Status: '42000' Native error: '8180' Msg: 'Statement(s) could not be prepared.'

    20190502/182848.886 - U00003620 Routine 'UCMAIN_R' forces trace because of error.

    20190502/182848.886 - U00003590 UCUDB - DB error: 'SQLNumResultCols', 'ERROR   ', '42000', 'Statement(s) could not be prepared.'

    20190502/182849.097 - U00003449 Output to the TRACE file is finished.

    20190502/182849.099 - U00003450 The TRACE file was opened with the switches '0000000000000000'.

    20190502/182849.099 - U00003380 Server 'UC4Q#WP' version '12.1.0+hf.1.build.1342' (Runtime '0/00:00:01', Log# '1', Trc# '2').

    20190502/182849.099 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.

    20190502/182849.099 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.

    20190502/182849.100 - U00003590 UCUDB - DB error: 'SQLNumResultCols', 'ERROR   ', '42000', 'Statement(s) could not be prepared.'

    20190502/182849.103 - U00003408 Library 'UCSJ.DLL' was successfully unloaded.

    20190502/182849.103 - U00003410 Server 'UC4Q#WP' version '12.1.0+hf.1.build.1342' ended abnormally.

     

    Could someone please provide an insight or any solution on the above.



  • 7.  Re: Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted May 03, 2019 12:03 PM

    Is it required to build the Database on secondary node via Automic Utility UCYBDBld.ini , only then AE would be able to recognize the database on secondary node.
    Please suggest..



  • 8.  RE: Re: Has anyone worked on setting high availability for SQL UC4 Database servers? What should be the configurations on UC4 side?

    Posted Mar 18, 2021 08:06 AM
    Hello Expert, 

    We are also facing similar issue . Whenever SQL team switch to secondary DB node application is not available. We have to perform manual cold restart to make application available. 

    We have also raised the Case 32575673 with Broadcom support team but no update.
    Does Automic application support MS SQL DB ​HA (high availability) setup ? 

    Can someone please share their experience on database high availability setup with Automic ?

    Thanks in advance. 

    Regards,
    Viral