Automic Workload Automation

Expand all | Collapse all

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

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

    Posted 04-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 04-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 04-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 04-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 04-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 05-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 05-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..