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

book

Article ID: 50890

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER Activator eTrust CA-ALERT eTrust CA-ALERT for CICS ALERT CA-Archiver ASM/ARCHIVE VSE-ESA OPTION CA ASM/Archive CA AutoAction AutoSys Job Management Adapter for AutoXfer Process Automation Manager Portal ARCserve Backup Client CA-CICSORT CA-Clipper COBOLVISION Analyzer CA CTO Distributed CA-Dart CA-Datesolver/2000 CA Distribulink EUREKA:Object EPIC VM CA Enterprise Endevor Change Manager for Unix CA-Archiver Disk Option CA-EPIC Backup CA-EPIC Access Option CA-EPIC SUPER SYS CA CA-EPIC for CMS System CA CA-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 CA FAQS Automated Systems Operation CA Global Subsystem (CA-GSS) ANDYNE MAINFRAME MISCELLANEOUS CA-Inventory Discovery Server CA-JARS Resource Management CA-JARS Resource Management ACC Option CA-JOBDOC JOBWATCH CA-Look CA-MAZDAMON CA Service Management Affiliate Technology Partner Fee CA Service Management Basic Technology Partner Fee CA-Metanet MF - MISC OLD CODES CA-Omniguard for CICS CA-Omniguard CA Opera CA Connect PREVAIL CA-Paramount XP CAM FOR DIST SYS CA-Paramount FOR NAVIGRAPH/HOST Research Planmacs Unlimited Project Planner CA Remote Console PREVAIL/XP-AUTOMATION PHASE 1 CA-Remote Console PREVAIL/XP AUTOMATION-RDF/SSM CA Raps Research Raveler SOLVE:EPS Unicenter NetMaster Network Management for SNA CA Alexandria CA Sort System CA-Sort System CA-SPOOLMAN CA Storage Mainframe SYSTEM/SCHEDULER SYSTEM/SCHEDULER VSE-ESA OPTION CA-System/Manager CA-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 CA Opera CA-VM:DBA CA-VM:DB Admin CA-VM:DB Center CA-VM:DB Developer CA-VM:DB Editor CA-VM:DB Monitor CA-VM:DB Reorganizer CA-VM:DB Reporter CA-VM:DB Restore CA-VM:DB REXX CA-VM:DB SQLMAP CA-VM:DB Suite CA VM:Migrate CA-VM:Monitor CA-VM:Notekeeper V/Solver CA-VM:Webserver for Officevision CA-VM:Webserver Secure CA VM:Webgateway CA-VM:Webserver CA XMENU for z/VM VISION:COMBO for TSO VISION:DAGER VISION:ELEVEN VISION:EIGHTY VISION:Online VISION:IQ for Informix CA Automate CA Service Catalog SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS 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:

  1. Stop Workflow by issuing:

    pdm_tomcat_nxd -d STOP -t CAWF

  2. Browse $NX_ROOT\bopcfg\www\CATALINA_BASE_WF\conf\Catalina\localhost and open both pm.xml and wl.xml in a text editor.

  3. 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.

  4. Navigate to the $NX_ROOT\bopcfg\www\CATALINA_BASE_WF\webapps\ folder and delete the \pm\ and \wl\ folders.

  5. 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.

  6. 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