IBM Support

High CPU usage and database transaction errors on FileNet Content Engine server

Troubleshooting


Problem

FileNet Content Engine server CPU usage reach 100% during failover or due to database connection failure

Symptom

Cause

Datasource connection threads to the database consuming resources and are not terminated or reused.

Environment

Diagnosing The Problem

.

Resolving The Problem

Login to WebSphere console and proceed with the steps outlined:

1. Resources

2. JDBC

3. Data sources

4. Objectstore data_source name

5. WebSphere Application Server data source properties.

Enable "Validate new connection" with Number of retries [100] and Retry interval [3] seconds
Enable "Validate Existing pooled connections" with "Retry interval" of 0 seconds

Configure these settings for both XA and non-XA datasources created for the objecstore..

[{"Product":{"code":"SSNW2F","label":"FileNet P8 Platform"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF010","label":"HP-UX"},{"code":"PF002","label":"AIX"}],"Version":"5.2;5.1;5.0;4.5;4.5.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

https://ibm.biz/BdRZZP

Document Information

Modified date:
17 June 2018

UID

swg21451557

Page Feedback