Problem Note 64750: SASServer 8 start-up takes a long time to start in SAS® Infrastructure for Risk Management 3.6
 |  |  |  |  |
In SAS Infrastructure for Risk Management 3.6, SASServer8 might take a long time to start when thousands of instances exist on the system. Start-up can take up to several hours. This problem occurs because of an SQL query that is working in the background to clean up unused DATA_PATH table entries.
To work around this issue, disable the clean up of the DATA_PATH table entries that takes place upon start-up of SASServer8. To disable the clean up, set the following system property to true in SAS® Management Console:
Disabling the table clean-up during server start-up should not cause any side effects.
After you change this property in SAS Management Console, you must restart SASServer8.
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 Infrastructure for Risk Management | Microsoft® Windows® for x64 | 3.6 | 3.6 | 9.4 TS1M6 | 9.4 TS1M6 |
| Linux for x64 | 3.6 | 3.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
A fix for this issue for SAS Infrastructure for Risk Management 3.6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G2T.html#64750| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2019-12-16 11:44:18 |
| Date Created: | 2019-09-09 11:46:09 |