Direct links to fixes
APAR status
Closed as program error.
Error description
If an exception occurs while you update group memberships, an invalid entry might be committed to the LSW_LOCK table, causing a DuplicateKeyException the next time this group membership is updated. As a result, the memberships of this group can no longer be update. The following example is of a typical exception stack trace: [17/04/23 23:10:21:966 JST] 00012b87 ParticipantGr E CWLLG1082E: ã?¡ã?³ã?ã?¼ hj121003 ã¯ã?ã?¼ã? GIQã?ã?¼ã? _S_111bbc7f-d217-4a5f-809b-e84bccdf3b32.d921b493-5b5 b-4bf3-93aa-46af60f9fd49 ã«è¿½å? ã?ã??ã¾ã?ã??ã§ã?ãYã??ã?¨ã?©ã?¼: PreparedStatementCallback; SQL [INSERT INTO LSW_LOCK (LOCK_ID, DESCRIPTION) VALUES (?,?)]; ORA-00001: ä¸?æ?å?¶ç´?(BPMBPMDB.LSWC_LOCK) ; nested exception is com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: ä¸?æ?å?¶ç´?(BPMBPMDB.LSWC_LOCK) com.lombardisoftware.client.delegate.BusinessDelegateException: PreparedStatementCallback; SQL [INSERT INTO LSW_LOCK (LOCK_ID, DESCRIPTION) VALUES (?,?)]; ORA-00001: ä¸?æ?å?¶ç´?(BPMBPMDB.LSWC_LOCK) ; nested exception is com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: ä¸?æ?å?¶ç´?(BPMBPMDB.LSWC_LOCK) at com.lombardisoftware.client.delegate.BusinessDelegateException.a sBusinessDelegateException(BusinessDelegateException.java:46) at com.lombardisoftware.client.delegate.InternalGroupsDelegateDefau lt.addUserToInternalGroup(InternalGroupsDelegateDefault.java:267 ) at com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.u pdateMembershipSorted(ParticipantGroupsCore.java:1580) at com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.u pdateMembership(ParticipantGroupsCore.java:1453) at com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.r esolveAddressForRetrievalService(ParticipantGroupsCore.java:611) at com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.r esolveAddressInternal(ParticipantGroupsCore.java:502) at com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.r esolveAddress(ParticipantGroupsCore.java:411) at com.lombardisoftware.server.ejb.security.ParticipantGroupsCore.u pdateParticipantGroupMembership(ParticipantGroupsCore.java:1380) at sun.reflect.GeneratedMethodAccessor398.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:56) at java.lang.reflect.Method.invoke(Method.java:620) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingRef lection(AopUtils.java:310) at org.springframework.aop.framework.ReflectiveMethodInvocation.inv okeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.pro ceed(ReflectiveMethodInvocation.java:149) at com.lombardisoftware.utility.spring.TransactionInterceptor$2.cal l(TransactionInterceptor.java:70) at com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo rt$3.doInTransaction(ProgrammaticTransactionSupport.java:500) at org.springframework.transaction.jta.WebSphereUowTransactionManag er$UOWActionAdapter.run(WebSphereUowTransactionManager.java:306) at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUO W(EmbeddableUOWManagerImpl.java:791) at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(E mbeddableUOWManagerImpl.java:370) at org.springframework.transaction.jta.WebSphereUowTransactionManag er.execute(WebSphereUowTransactionManager.java:252) at com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo rt.executeInNewTransaction(ProgrammaticTransactionSupport.java:4 88) at com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo rt.execute(ProgrammaticTransactionSupport.java:349) at com.lombardisoftware.utility.spring.TransactionInterceptor.invok e(TransactionInterceptor.java:68) at org.springframework.aop.framework.ReflectiveMethodInvocation.pro ceed(ReflectiveMethodInvocation.java:171) at com.lombardisoftware.utility.spring.CoreEntryInterceptor.invoke( CoreEntryInterceptor.java:44) at com.lombardisoftware.utility.spring.PSCoreEntryInterceptor.invok e(PSCoreEntryInterceptor.java:14) at org.springframework.aop.framework.ReflectiveMethodInvocation.pro ceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkD ynamicAopProxy.java:204) at com.sun.proxy.$Proxy77.updateParticipantGroupMembership(Unknown Source) at com.lombardisoftware.client.delegate.ParticipantGroupsDelegateDe fault.updateParticipantGroupMembership(ParticipantGroupsDelegate Default.java:558) at com.lombardisoftware.core.script.js.objects.TeamScriptable.jsFun ction_refresh(TeamScriptable.java:821) at sun.reflect.GeneratedMethodAccessor397.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:56) at java.lang.reflect.Method.invoke(Method.java:620) at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:161) at org.mozilla.javascript.FunctionObject.call(FunctionObject.java:4 67) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.jav a:3330) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:24 87) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunct ion.java:164) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.j ava:398) at com.lombardisoftware.core.script.JavaScriptContextFactory.doTopC all(JavaScriptContextFactory.java:192) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.jav a:3070) at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunct ion.java:175) at com.lombardisoftware.core.script.js.JSScript.exec(JSScript.java: 78) at com.lombardisoftware.core.script.js.JavaScriptRunner$2.execute(J avaScriptRunner.java:287) at com.lombardisoftware.core.script.js.PreparedScope.executeWithSco pe(PreparedScope.java:224) at com.lombardisoftware.core.script.js.JavaScriptRunner.execute(Jav aScriptRunner.java:285) at com.lombardisoftware.core.script.js.JavaScriptRunner.evalScript( JavaScriptRunner.java:392) at com.lombardisoftware.component.common.workflow.ExecutionContext$ 1.call(ExecutionContext.java:608) at com.lombardisoftware.component.common.workflow.ExecutionContext$ 1.call(ExecutionContext.java:606) at com.lombardisoftware.component.common.workflow.ExecutionContext. doWithParams(ExecutionContext.java:742) at com.lombardisoftware.component.common.workflow.ExecutionContext. evalScript(ExecutionContext.java:606) at com.lombardisoftware.component.common.workflow.ExecutionContext. evalScript(ExecutionContext.java:600) at com.lombardisoftware.component.twscript.worker.ScriptWorker.doJo b(ScriptWorker.java:73) at com.lombardisoftware.component.common.workflow.ExecutionJob.doJo b(ExecutionJob.java:461) at com.lombardisoftware.server.ejb.workflow.EJBWorkflowManagerBean. doResumeWorkflowEngine(EJBWorkflowManagerBean.java:1437) at com.lombardisoftware.server.ejb.workflow.EJBWorkflowManagerBean. executeProcessByUCA(EJBWorkflowManagerBean.java:520) at com.lombardisoftware.server.ejb.workflow.EJSRemoteStatefulEJBWor kflowManager_82478d70.executeProcessByUCA(Unknown Source) at com.lombardisoftware.server.ejb.workflow._EJBWorkflowManagerInte rface_Stub.executeProcessByUCA(_EJBWorkflowManagerInterface_Stub .java:623) at com.lombardisoftware.component.common.workflow.EJBWorkflowManage rDelegateDefault.executeProcessByUCA(EJBWorkflowManagerDelegateD efault.java:165) at com.lombardisoftware.component.common.workflow.EJBWorkflowManage rDelegateWebSphere$9.run(EJBWorkflowManagerDelegateWebSphere.jav a:108) at java.security.AccessController.doPrivileged(AccessController.jav a:416) at com.lombardisoftware.client.delegate.common.WebsphereDelegateHel per.doAsCurrentSubjectContextSensitive(WebsphereDelegateHelper.j ava:204) at com.lombardisoftware.client.delegate.common.WebsphereDelegateHel per.doAsCurrentSubjectContextSensitive(WebsphereDelegateHelper.j ava:188) at com.lombardisoftware.component.common.workflow.EJBWorkflowManage rDelegateWebSphere.executeProcessByUCA(EJBWorkflowManagerDelegat eWebSphere.java:106) at com.lombardisoftware.server.eventmgr.UnderCoverAgentExecutor.exe cute(UnderCoverAgentExecutor.java:298) at com.lombardisoftware.server.ejb.eventmgr.EventMgrCore.executeUCA (EventMgrCore.java:182) at sun.reflect.GeneratedMethodAccessor570.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:56) at java.lang.reflect.Method.invoke(Method.java:620) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingRef lection(AopUtils.java:310) at org.springframework.aop.framework.ReflectiveMethodInvocation.inv okeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.pro ceed(ReflectiveMethodInvocation.java:149) at com.lombardisoftware.utility.spring.TransactionInterceptor$2.cal l(TransactionInterceptor.java:70) at com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo rt$3.doInTransaction(ProgrammaticTransactionSupport.java:500) at org.springframework.transaction.jta.WebSphereUowTransactionManag er$UOWActionAdapter.run(WebSphereUowTransactionManager.java:306) at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderNewUO W(EmbeddableUOWManagerImpl.java:791) at com.ibm.ws.uow.embeddable.EmbeddableUOWManagerImpl.runUnderUOW(E mbeddableUOWManagerImpl.java:370) at org.springframework.transaction.jta.WebSphereUowTransactionManag er.execute(WebSphereUowTransactionManager.java:252) at com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo rt.executeInNewTransaction(ProgrammaticTransactionSupport.java:4 88) at com.lombardisoftware.utility.spring.ProgrammaticTransactionSuppo rt.execute(ProgrammaticTransactionSupport.java:349) at com.lombardisoftware.utility.spring.TransactionInterceptor.invok e(TransactionInterceptor.java:68) at org.springframework.aop.framework.ReflectiveMethodInvocation.pro ceed(ReflectiveMethodInvocation.java:171) at com.lombardisoftware.utility.spring.CoreEntryInterceptor.invoke( CoreEntryInterceptor.java:44) at com.lombardisoftware.utility.spring.PSCoreEntryInterceptor.invok e(PSCoreEntryInterceptor.java:14) at org.springframework.aop.framework.ReflectiveMethodInvocation.pro ceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkD ynamicAopProxy.java:204) at com.sun.proxy.$Proxy52.executeUCA(Unknown Source) at com.lombardisoftware.server.ejb.eventmgr.EventMgrBean$2.execute( EventMgrBean.java:72) ... 144 moremework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.
Local fix
Problem summary
No additional information is available. PRODUCT AFFECTED IBM Business Process Manager (BPM) Advanced IBM BPM Standard IBM BPM Express
Problem conclusion
A fix is available for IBM BPM V8.5.6 cumulative fix 2 (http://www.ibm.com/support/docview.wss?uid=swg24041303) and included in IBM BPM 857 2017.06 CF, that correctly rolls back the current transaction in case of an exception. This way, no invalid entry is committed to the LSW_LOCK table, and updating the group membership is again possible.
Temporary fix
Comments
APAR Information
APAR number
JR57786
Reported component name
BPM ADVANCED
Reported component ID
5725C9400
Reported release
856
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-04-28
Closed date
2017-06-02
Last modified date
2017-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
BPM STANDARD
Fixed component ID
5725C9500
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"856","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
02 June 2017