Enabling Workflow in IBM Business Glossary causes IBM Websphere Application Server (WAS) to crash
Errors in WAS logs:
Error [ISF-SECURITY-AUTH]  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.
- Stop WAS
- 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
- Change the value of "IntervalInMilis" (typically 45000) to -1
- Save and close the file
- Start WAS