Set Custom Properties for Repository Data Source

While creating a data source for repository, use the following custom settings to set properties for a connection pool.

encrypt=true; nableltm=true; connectionretrywaittime=30; maxconnectionretries=10; sqlcommandtimeout=300;

encrypt: Ensures secure communication between AVEVA Work Tasks Server and SQL Server when a certificate is installed on the SQL Server for SSL encryption.

enableltm: AVEVA Work Tasks internally implements lightweight transaction mode by reusing the connection which is already open within the same transaction. With this implementation, a connection which is used from a transaction is returned back to connection pool only when the transaction is completed. Since the same connection is used within the transaction, the transaction becoming distributed is reduced to a great extent. With this feature AVEVA Work Tasks control the transaction from escalating to a distributed transaction which is very expensive.

The enableltm property can be used to turn off this feature. The default value is set as 'True'.

connectionretrywaittime: While opening a new connection, if the database server is not available, the default behavior is to retry for the connection. This setting can be used to set the wait time to retry for a new connection. The default value is set as 30 seconds.

maxconnectionretries: While opening a new connection, if the database server is not available, the default behavior is set to retry for a new connection. This setting can be used to set the retry count. The default value is set infinite.

sqlcommandtimeout: Sets the wait time before terminating the attempt to execute a SQL command and generating an error. The default value is set as 300.

Note: These settings are case sensitive and should be mentioned only in lower case.