User Creation throws Exception in WorkPoint IAMAPPROVERS

Document ID : KB000053814
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Environment:
Identity Manager r12 CR4
Weblogic 9.1.
SQL 2005

The Create User Task fails generating the following SQL Exception Error:

[ims.default] com.netegrity.portal.service.workflow.core.WorkflowException
com.workpoint.server.ejb.WorkPointEJBException: InvocationTargetException caught when executing Java class. Command = '#Mon Apr 28 00:41:46 EDT
2003Parameter3=ThisActivityInstDataParameter2=SymbolTableParameter1=ClientContext
Method=imApproversJavaClass=com.netegrity.ims.workflowCallbacks.WorkpointRules'; nested exception is:
java.sql.SQLException: Connection has already been created in this tx context for pool named Workflow. Illegal attempt to create connection from another pool: TaskPersistence

java.sql.SQLException: Connection has already been created in this tx context for pool named Workflow. Illegal attempt to create connection from another pool: TaskPersistence
at weblogic.jdbc.jts.Driver.getExistingConnection(Driver.java:613)
at weblogic.jdbc.jts.Driver.connect(Driver.java:140)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:359)
at com.netegrity.idmutils.DBConnectionUtil.getConnection(DBConnectionUtil.java:23)
at com.netegrity.ims.persistence.PersistenceProvider.getEvent(PersistenceProvider.java:281)
at com.netegrity.imapi.WorkflowCallbackHelper.generateWorkflowContext(WorkflowCallbackHelper.java:131)
at com.netegrity.ims.workflowCallbacks.WorkpointRules.imApprovers(WorkpointRules.java:182)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Solution:

This exception is caused by WebLogic's global transaction setting.
To resolve this issue Disable Global Transactions through WebLogic.

Note:
The JDBC Datasource creation steps must be in place.

Please review:
The Identity Manager r12 Configuration Guide: "Create a JDBC Datasource for WebLogic 9.2" and also, Page 85 of the r12 Implimentation Guide: "Tuning Identity Manager Databases"