SUPPORT / SAMPLES & SAS NOTES
Problem Note 63963: A database connection fails and a "Timeout: Pool empty" error occurs when you search for information in SAS® Visual Investigator
 |  |  |  |  |
When you use the search capability in SAS Visual Investigator, you might fail to get results. In your Search and Discovery (SAND) log, you see "Pool empty" error messages that are similar to the following:
2019-02-11 21:42:27.978 ERROR 12 — [o-8080-exec-171] o.h.engine.jdbc.spi.SqlExceptionHelper : sas.svi-datahub@@acme [271f5399ce537deb] [http-nio-8080-exec-171] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:100; busy:100; idle:0; lastwait:30000].
A potential workaround is to increase the number of connections in the connection pool for your application server. Eventually, however, the number of connections will be exhausted, and you might need to restart the application server to free up connections.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.4 | 10.5.1 | Viya | Viya |