IBM Support

Enabling Workflow in IBM Business Glossary causes IBM Websphere Application Server (WAS) to crash

Troubleshooting


Problem

Enabling Workflow in IBM Business Glossary causes IBM Websphere Application Server (WAS) to crash

Symptom

Errors in WAS logs:
Error [ISF-SECURITY-AUTH] [0000] Session event repository notification failed for session id [].
com.ascential.acs.security.repository.ASBRepositoryException: Unable to begin a transaction: [Can't lookup a connection]
org.apache.ojb.broker.accesslayer.LookupException: Could not borrow connection from pool, seems ObjectPool is exhausted. Active/Idle instances in pool=21/0.

Resolving The Problem

Note that Enabling workflow can take a long time, even hours, depending on the size of the glossary and the hardware.

Workaround:

  1. Stop WAS
  2. Open the file in a text editor: <WAS HOME>/AppServer/profiles/InfoSphere/installedApps/<server>Node01Cell/GlossaryBrowser.ear.ear/BGNGWeb.war/WEB-INF/applicationContext-web.xml
  3. Change the value of "IntervalInMilis" (typically 45000) to -1
  4. Save and close the file
  5. Start WAS

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21620739