IBM Support

JR57786: YOU RECEIVE AN EXCEPTION WHEN UPDATING GROUP MEMBERSHIP AND FURTHER UPDATES ARE PREVENTED

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
02 June 2017