The $NX_ROOT\pdm_tomcat_cawf.log file is filling up with the message:
AbandonedObjectPool is used (org.apache.commons.dbcp.AbandonedObjectPool@1a80 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:
- Stop Workflow by issuing:
pdm_tomcat_nxd -d STOP -t CAWF
- Browse $NX_ROOT\bopcfg\www\CATALINA_BASE_WF\conf\Catalina\localhost and open both pm.xml and wl.xml in a text editor.
- Locate the "<Resource auth" line in both xml files near the end of the file and scroll over until you find maxActive="100". Increase the value to 200. That is, maxActive="200". Save and close each file.
- Navigate to the $NX_ROOT\bopcfg\www\CATALINA_BASE_WF\webapps\ folder and delete the \pm\ and \wl\ folders.
- Navigate to $NX_ROOT\bopcfg\www\CATALINA_BASE_WF\ and delete the \Work\ directory.
PLEASE NOTE: Do not retain copies of the folders from the above two steps. Doing so causes additional problems with CA Workflow. If you feel that you must retain copies of these folders, please make sure that you move them to a share or other directory that is not under the $NX_ROOT structure.
- Restart Workflow by issuing:
pdm_tomcat_nxd -d START -t CAWF
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.