DPA doesn't work after failing over from one replica to another in an Availability Group

chinesinho

Hi there,

We are currently running DPA version 10.1.313.  The DPA ignite repository database sits on a two-replica availability group.  When we attempt to simply fail over from the primary replica to the other, the DPA application (hosted on a separate application server) doesn't come online.  Is there some kind of configuration that needs to be changed on the newly assigned primary replica post-failover?

Does this have anything to do with the jTDS JDBC driver?

Error message we're seeing is:

A connection to the Repository IGNITE@<SQL Instance> using the URL [<LISTENER>:1433/ignite_repository] could not be established. This typically occurs if the host or port is temporarily or permanently unavailable. If the host or port has permanently changed, edit host/port parameters in <DPA Home>/iwc/tomcat/ignite_config/idc/repo.properties.

Connection failure due to: Invalid Database [caused by java.sql.SQLException: Cannot open database "ignite_repository" requested by the login. The login failed.]

jaminsql

I had a case the other day here where we were not able to get the login to connect on to the repository on an AG group from one node and could from the other. In that case the login was a windows authentication account and from one node it was working to login and from the other it would not without adding a JDBC property for useNTLMv2=true to the repo.properties file.

I would say to try adding this property to the file listed <DPA Home>/iwc/tomcat/ignite_config/idc/repo.properties

repo.jdbcDriverProperties=useNTLMv2\=true

Here is a good link on understanding this item.

Understanding Kerberos and NTLM authentication in SQL Server Connections | SQL Protocols

I am not sure but, perhaps the from the one replica you are needing NTLM auth and we are not trying that with out this setting. If this doesn't work please turn in a support case and reference this discussion and if we find the solution we can update this item.