SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 70640: SAS® Infrastructure for Risk Management enables the use of PooledConnectionProvider

DetailsHotfixAboutRate It

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:

IRM Mid-Tier Server: Configure properties

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Infrastructure for Risk ManagementMicrosoft® Windows® for x643.79.4 TS1M8
Linux for x643.79.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.