IBM Support

IBM FileNet P8 Content Engine (CE) is slow, sometimes hangs, and produces datasource errors

Troubleshooting


Problem

Attempting to save or search in IBM FileNet P8 Content Engine (CE) is slow and sometimes hangs.

Symptom

CE exhibits slow performance and hangs. Datasource errors appear in the logs, but the database is fine and the datasources test out ok in the WAS console.

Cause

Too few connections in the datasource connection pool

Environment

WebSphere Application Server

Diagnosing The Problem

Errors such as this appear in the logs:
2015-05-19T08:12:21.412 1F7122D0 CSTG FNRCE0024E - ERROR
executeRollFwdCommand threw an exception
com.filenet.api.exception.EngineRuntimeException: FNRCE0024E:
E_FAILED_TO_GET_DATASOURCE: The server cannot get the data source
<name>. Message was: CWTE_NORMAL_J2CA1009

Resolving The Problem

Increase the number of connections in the Connection pool:

  1. Access the WebSphere Integrated Console:
    2. http://server_name:9060/ibm/console (default) where server_name is the name of your CE server.
  2. Navigate to Resources -> JDBC -> Data sources.
  3. Click each data source and check the Connection pool properties value,
    which is on the right side of the page.
  4. Increase the Connection pool based on your system resources and needs. A suggested maximum value is 100.
  5. Click OK.
  6. Click Save directly to the master configuration.
  7. Restart WebSphere

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

Document Information

Modified date:
17 June 2018

UID

swg21903591

Page Feedback