We have created MS SQL having 4 server in backend. All are in multiSubnetFailover.
We have updated the connection string in arcotcommon.ini file with required parameter and also odbc.ini file.
jdbc:sqlserver://xxx.qa.com:<port>;selectMethod=cursor;DatabaseName=XXXX;multiSubnetFailover=true
Below are the error
Tue Jan 18 15:49:14.298 2022 WARNING: pid 30558 tid 30558: 2: 0: ArDBConnection::connect: Connection to database [arcotdsn]. user [SVC.WAMATHOWNER] failed. Error detail [SQL State:08S01, Native Code: 0, ODBC code: [CA AA][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 9SQL State:HYT00, Native Code: 0, ODBC code: [CA AA][ODBC SQL Server Wire Protocol driver]Timeout expired.]
Tue Jan 18 15:49:14.298 2022 WARNING: pid 30558 tid 30558: 2: 0: ArDBPool::createNewConnections: Failed to grow the pool [(primary)] : Error [ArDBPool::createDBContextObjs: SQL State:08S01, Native Code: 0, ODBC code: [CA AA][ODBC SQL Server Wire Protocol driver]Unexpected Network Error. ErrNum = 9SQL State:HYT00, Native Code: 0, ODBC code: [CA AA][ODBC SQL Server Wire Protocol driver]Timeout expired.]
Release : 9.1
Component : AuthMinder (Arcot WebFort)
RiskMinder(Arcot RiskFort)
For the ODBC connection which is used by the Strong Auth and Risk Auth Server, odbc.ini file need to be updated. Below are the instructions listed in Progress Datadirect KB article which need to be used in odbc.ini file.
For JDBC components like the State Manager, Arcot Admin and Arcot UDS, the JDBC URL need to be updated in this format.
jdbc:sqlserver://xxx.qa.com:<port>;selectMethod=cursor;DatabaseName=XXXX;multiSubnetFailover=true