Problem

-- B2Bi using MSSQL Server

-- getting this error in the cn log :

2019-04-29 13:25:55,657 - WARN [qtp981054057-7385] (AxwayBoneCPDataSource.getConnection:62) - Got SQL Exception with state: 08001
java.sql.SQLException: Timed out waiting for a free available connection.
at com.jolbox.bonecp.DefaultConnectionStrategy.getConnectionInternal(DefaultConnectionStrategy.java:88)
at com.jolbox.bonecp.AbstractConnectionStrategy.getConnection(AbstractConnectionStrategy.java:90)
at com.jolbox.bonecp.BoneCP.getConnection(BoneCP.java:553)
at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:131)

-- B2Bi looses the connection with the database, and triggers a restart

Resolution

* the socket timeout is reached, breaking the connection with the database

* might be caused by an increase of load, or when Integrator reports errors to Interchange using Integrator REST clients overloading the database access

* update the b2bi_install/Interchange/conf/datastoreconfig.xml file.

For the connection info related to MSSQLServer, update the ConnectionURL element and change the socketTimeout from 600 to a higher value, like it appears bellow (value is in seconds, here is an example with 1800):

<ConnectionInfo id="MSSQLServer">

[...]

<ConnectionURL>[...]socketTimeout=1800[...]</ConnectionURL>

[...]