Failed to get one database error in the logs
Note: This applies to
customers that have SQL Express installed for the database.
<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
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
the SQL Express database pool size:
to DocuShare as Admin.
Admin Home. The Admin Home page will
the [+] sign next to Services and Components to expand.
on the Database link. The Database
Page will be displayed
the value for the Pool Size (if the
default is 5, try increasing to 15).
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
August 30th, 2016
Solution ID: 1810