The $NX_ROOT\pdm_tomcat_cawf.log file is filling up with the message:
AbandonedObjectPool is used ([email protected] area)
- Cannot create PoolableConnectionFactory, cause: The connection to the named instance has failed. Error: java.net.UnknownHostException: . org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionF actory, cause: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the named instance has failed. Error: java.net.UnknownHostException: . at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError (Unknown Source)
These messages fill the log file very quickly. This document described steps you can take to reduce the number and frequency of these messages.
This is not an error message but rather an informational message. AbandonedObjectPool messages are only written when a database connection is reclaimed; and connections are only reclaimed when they are almost exhausted.
It is not necessarily advisable to remove these messages as they may be useful when troubleshooting some types of problems within Workflow. However, if the messages are not wanted, you can increase the number of available connections, which should cause the number of reclaimed connections to be reduced, which should, in turn, cause the number and frequency of the messages written to the log to be reduced.
To increase the number of available connections, follow these steps:
Restarting workflow will rebuild the deleted folder structures to include the changes made to the xml files. Workflow will have double the available connections resulting in a reduction of the number of times these connections must be reclaimed.