Getting a large number of messages in the pdm_tomcat_cawf.log file about AbandonedObjectPool, is this a problem?

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER Activator eTrust ALERT eTrust ALERT for CICS ALERT Archiver ASM/ARCHIVE VSE-ESA OPTION ASM/Archive AutoAction AutoSys Job Management Adapter for AutoXfer Process Automation Manager Portal ARCserve Backup Client CICSORT Clipper COBOLVISION Analyzer CTO Distributed Dart Datesolver/2000 Distribulink EUREKA:Object EPIC VM Enterprise Endevor for Unix Archiver Disk Option EPIC Backup EPIC Access Option EPIC SUPER SYS EPIC for CMS System EPIC TAPE MANAGEMENT eTrust Antivirus Gateway for CVP eTrust Content Inspection Gateway eTrust Content Inspection Gateway Option for MSP/ISA EE eTrust Antivirus Gateway for Netscape eTrust VPN Enterprise Edition FAQS VM FAQS Automated Systems Operation Global Subsystem (GSS) ANDYNE MAINFRAME MISCELLANEOUS Inventory Discovery Server ARS Resource Management JARS Resource Management ACC Option JOBDOC JOBWATCH Look MAZDAMON Service Management Affiliate Technology Partner Fee Service Management Basic Technology Partner Fee Metanet MF - MISC OLD CODES Omniguard for CICS Omniguard Opera Connect PREVAIL Paramount XP CAM FOR DIST SYS Paramount FOR NAVIGRAPH/HOST Research Planmacs Unlimited Project Planner Remote Console PREVAIL/XP-AUTOMATION PHASE 1 Remote Console PREVAIL/XP AUTOMATION-RDF/SSM Raps Research Raveler Generic Non Product SOLVE:EPS Unicenter NetMaster Network Management for SNA Alexandria Sort System SPOOLMAN Storage Mainframe SYSTEM/SCHEDULER SYSTEM/SCHEDULER VSE-ESA OPTION System/Manager Tape/Manager VSE-ESA OPTION Output Management Document Server TNG Network and Systems Management Agent for CA-Datacom DFSMShsm Workstation Network and Systems Management UNIX SMTP Unicenter Management for Microsoft Exchange SMTP Option UNICENTER II Unicenter Network and Systems Management Database Performance Monitor Option UNICENTER OSM Database Command Center Mnt VM:DBA VM:DB Admin VM:DB Center VM:DB Developer VM:DB Editor VM:DB Monitor VM:DB Reorganizer VM:DB Reporter VM:DB Restore VM:DB REXX VM:DB SQLMAP VM:DB Suite VM:Migrate VM:Monitor VM:Notekeeper V/Solver VM:Webserver for Officevision VM:Webserver Secure VM:Webgateway VM:Webserver XMENU for z/VM VISION:COMBO for TSO VISION:DAGER VISION:ELEVEN VISION:EIGHTY VISION:Online VISION:IQ for Informix Automate CA Service Catalog SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

The $NX_ROOT\pdm_tomcat_cawf.log file is filling up with the message:

AbandonedObjectPool is used ([email protected] area)
LogAbandoned: true
RemoveAbandoned: true
RemoveAbandonedTimeout: 60
- 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.

Solution:

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.

Environment

Release:
Component: ARGIS