Usage Note 70640: SAS® Infrastructure for Risk Management enables the use of PooledConnectionProvider
SAS Infrastructure for Risk Management introduced the following configurable properties in SAS® Management Console. These properties enable the use of PooledConnectionProvider, ensuring that multiple threads do not share and use the same Multi Vendor Architecture connection simultaneously. By default, these properties are disabled.
SAS Management Console properties:
Property
|
Old Default
|
New Default
|
com.sas.solutions.risk.irm.server.platform.platformConnection.usePooledConnectionProvider
|
YES
|
NO
|
com.sas.solutions.risk.irm.server.platform.platformConnection.pooledConnectionProvider.maxSize
|
5
|
5
|
Here is a sample screenshot to configure the above properties in SAS Management Console:
Note that errors similar to the following can occur in the SASIRMServer.log file:
- Cannot create instance
- Cannot find
- Cannot save system_option in…
- Loaded 0 values from…
If these errors occur, you can enable the PooledConnectionProvider feature by setting the following properties to YES:
com.sas.solutions.risk.irm.server.platform.platformConnection.usePooledConnectionProvider=YES
If you do not add that property, the max pool size will use a default value of PooledConnectionProvider set to 5. However, this value can be customized using the following property in SAS Management Console:
com.sas.solutions.risk.irm.server.platform.platformConnection.pooledConnectionProvider.maxSize= 1 to 10
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Infrastructure for Risk Management | Microsoft® Windows® for x64 | 3.7 | | 9.4 TS1M8 | |
Linux for x64 | 3.7 | | 9.4 TS1M8 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Date Modified: | 2024-03-28 10:49:36 |
Date Created: | 2024-02-02 14:15:08 |