Problem Note 52684: SAS® Forecast Analyst Workbench stored processes might fail with a too many connections error
 |  |  |  |  |
The details of SAS® Financial Management form sets are displayed in the SAS Forecast Analyst Workbench Consensus Planning workspace. The process to display the form details is completely automated.
A problem has been identified that might cause multiple SAS® sessions to query for form details. This might lead to failures in publishing form sets or in running a consensus because too many connections to the database are open. In this case, an error similar to the following is displayed in the SAS log:
ERROR: Error trying to establish connection: Too many connections ERROR: Error in the LIBNAME statement.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Forecast Analyst Workbench | Linux for x64 | 5.1 | 5.2 | 9.3 TS1M1 | 9.4 TS1M0 |
| 64-bit Enabled AIX | 5.1 | 5.2 | 9.3 TS1M1 | 9.4 TS1M0 | ||
| Microsoft® Windows® for x64 | 5.1 | 5.2 | 9.3 TS1M1 | 9.4 TS1M0 | ||
A fix for this issue for Forecast Analyst Workbench 5.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J56.html#52684| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-12-19 11:05:09 |
| Date Created: | 2014-04-03 14:33:01 |