Arcot Admin does not come up on restart when the Primary Principal DB is down and SQL mirror up

Issue/Introduction:

The Broadcom Admin Console cannot be restarted when the Principal DB is kept down and Mirror DB is up . The Admin restart fails with the following error calling for default Port 1433 even when the JDBC string did not specify port 1433.

"port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

Cause:

The cause is that that the JDBC string (in arcotcommon.ini) provided for the Mirror DB (via the parameter failoverPartner=) is found to be incorrect and need to be specified as such.

URL.1=jdbc:sqlserver://PRIMARY_DB_HOSTNAME;DatabaseName=DBNAME;port=PORTNUMBER;
failoverPartner=MIRROR_DB_HOSTNAME\\INSTANCE_NAME;selectMethod=cursor

Note:-please ensure that the "failoverPartner=" has the instance name and the escape character "\" is provided as in "\\INSTANCE_NAME"

This is indicative of the fact that when making an initial connection when Primary is found down or not reachable, the MS SQL JDBC Driver tries to connect to the Default MS SQL DB port 1433. Hence if the Port 1433 is not open when incorrect JDBC connection string provided (via arcotcommon.ini) for mirror DB, then arcotadmin will come up on a restart.

Environment:

CA Strong Authenticaton and CA Risk Authentication Admin Console

Resolution:

Provide the JDBC sting in arcotcommon.ini as

URL.1=jdbc:sqlserver://PRIMARY_DB_HOSTNAME;DatabaseName=DBNAME;port=PORTNUMBER;
failoverPartner=MIRROR_DB_HOSTNAME\\INSTANCE_NAME;selectMethod=cursor

Additional Information:

None.