Failed to get one database error in the logs

Note: This applies to customers that have SQL Express installed for the database.

Issue

The <dshome>\logs\DSServer.stdError log displays a lost database connection:

11 Aug 2016 11:53:08 - [Thread[Thread-37,5,main]] - DatabaseJDBC.getConnection: Failed to get one.  ADDING TO LIST at 0 for thread Thread-40, waiting to do command getObject

Solution

If the database is SQL Express, try increasing the connection pool size. SQL Express has a smaller connection pool size and may be unable to keep up with batch scanning.

Increase the SQL Express database pool size:

1. Login to DocuShare as Admin.

2. Click Admin Home. The Admin Home page will be displayed.

3. Click the [+] sign next to Services and Components to expand.

4. Click on the Database link. The Database Page will be displayed

5. Change the value for the Pool Size (if the default is 5, try increasing to 15).

6. Click the [Apply] button at the bottom of the page to apply your settings.

Note: SQLExpress is limited to 1 CPU and a fixed amount of RAM depending on the version. Increasing the pool size may not resolve the issue depending on the volume being scanned. When dealing with large volumes, it is always best to use full version database such as SQL Standard \Enterprise or Oracle.

Note: For detailed information on the limitations of MSDE or SQL that is bundled with DocuShare click the solution link at the bottom of the page.

Solution Published: August 30^th, 2016

Solution ID: 1810