How to configure iXP to work with Autosys database hosted on Microsoft sql server failover clusters
Article ID: 248493
Updated On:
Products
Issue/Introduction
Autosys server's database is hosted on Microsoft sql server failover clusters. Which is working fine. However, The iXP fails to establish connection along with the SQL server database failover.
Environment
Release : 11.4 and later
Component : CA Workload Automation iXP
Cause
This is due to the jTDS connection library. It is a generic library supplied to establish a connection with the SQL server database.
It might not support all the featured-failover configurations in the database
Resolution
Microsoft has the SQL server JDBC driver (sqljdbc) that supports all the database failover features.
The sqljdbc driver can be downloaded directly from the Microsoft portal. If needed help, contact the SQL server database administrator to have it downloaded.
Ensure the driver is for the current database release and is compatible with the Jre 8.
Stop Tomcat for the iXP.
Place the downloaded sqljdbc*jre8.jar file under "lib" directory of the tomcat install location.
Restart iXp.
Login to iXpAdmin console and navigate to Instance and database section.
Select the database Vendor from the drop down: "SQL server"
JDBC Driver: Place the cursor and append it to be: "com.microsoft.sqlserver.jdbc.SQLServerDriver"
(The aforementioned driver class is not part of the drop down list. However, can be edited)
URL: Compose the URL as required to support all the failover features configured on the database. For example, if the database configured with Always on availability groups (AGs) or failover cluster instances(FCIs), the multiSubnetFailover needs to be enabled.
jdbc:sqlserver://”database server”:”port number”;databasename=”DBname”;MultiSubnetFailover=true;TrustServerCertificate=True
Update the db connection user/password and other necessary details.
Save and restart the iXp and run the DB failover test.
The iXp would resume processing the user requests as soon as both the DB and Autosys are available.
Additional Information
Feedback
