IBM Support

JR50863: RUNNING A MIGRATED PROCESS INSTANCE CAUSES A CWLLG0181E TO BE LOGGED WITH A TeamWorksRuntimeException

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When you migrate from IBM Business Process Manager V8.5.0.0, and
    a process applica-tion contains instances, an exception such as
     the following can occur when the instances are run after the
    migration:
    
    CWLLG0181E: The following error occurred in the 1,476 task:
    Runtime error in script ("Process: 'Update All SLA Statuses'
    ProcessItem: 'Update Statuses' Type: 'ITEM'" 1:0).Internal
    Script error:
    com.lombardisoftware.core.TeamWorksRuntimeException:
    com.lombardisoftware.client.delegate.BusinessDelegateException:
    PreparedStatement-Callback; uncategorized SQLException for SQL
    [select reference_id, dep_path_id, tar-get_type, target_id,
    target_summary_data from lsw_po_reference where branch_id = ?
    and start_seq_num <= ? and end_seq_num > ?]; SQL state [null];
    error code [-4470]; [jcc][t4][10120][10898][4.11.69] Invalid
    operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null;
    nested exception is com.ibm.db2.jcc.am.SqlException:
    [jcc][t4][10120][10898][4.11.69] Invalid operation: result set
    is closed. ERRORCODE=-4470, SQLSTATE=null
    Script (line 1):
    <B>   1 :
    Packages.com.lombardisoftware.core.sla.SLATracking.updateAllSLAs
    ();</B>
    
    t<B>   1 :
    Packages.com.lombardisoftware.core.sla.SLAT6updateAllSLAs();</B>
    
    
    at
    com.lombardisoftware.client.delegate.BusinessDelegateException.a
    sBusinessDelegateException(BusinessDelegateException.java:46)
    at
    com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
    per.doAsCurrentSubjectContextSensitive(WebsphereDelegateHelper.j
    ava:199)
    at
    com.lombardisoftware.client.delegate.EventMgrDelegateDefault.exe
    cuteUCA(EventMgrDelegateDefault.java:153)
    at
    com.lombardisoftware.server.scheduler.tasks.UcaExecutorTask.exec
    ute(UcaExecutorTask.java:39)
    at
    com.lombardisoftware.server.scheduler.Engine.execute(Engine.java
    :918)
    at
    com.lombardisoftware.server.scheduler.Engine.executeThreadTasks(
    Engine.java:643)
    at
    com.lombardisoftware.server.scheduler.Engine$1.run(Engine.java:5
    90)
    at
    com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
    per$3$1.run(WebsphereDelegateHelper.java:100)
    at
    java.security.AccessController.doPrivileged(AccessController.jav
    a:362)
    at javax.security.auth.Subject.doAs(Subject.java:573)
    at
    com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:19
    5)
    at
    com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:15
    2)
    at
    com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
    per.doAs(WebsphereDelegateHelper.java:172)
    at
    com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
    per$3.run(WebsphereDelegateHelper.java:96)
    at
    com.lombardisoftware.server.scheduler.ThreadPool$MyWork.run(Thre
    adPool.java:296)
    at
    com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java
    :269)
    at
    java.security.AccessController.doPrivileged(AccessController.jav
    a:298)
    at javax.security.auth.Subject.doAs(Subject.java:495)
    at
    com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:13
    2)
    at
    com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:90
    )
    at
    com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.jav
    a:336)
    at
    java.security.AccessController.doPrivileged(AccessController.jav
    a:327)
    at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:804)
    at
    com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithE
    xecutionContextImpl.java:222)
    at
    com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:20
    6)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1864)
    Caused by: com.lombardisoftware.core.TeamWorksException: Runtime
    error in script ("Process: 'Update All SLA Statuses'
    ProcessItem: 'Update Statuses' Type: 'ITEM'" 1:0).Internal
    Script error:
    com.lombardisoftware.core.TeamWorksRuntimeException:
    com.lombardisoftware.client.delegate.BusinessDelegateException:
    PreparedStatement-Callback; uncategorized SQLException for SQL
    [select reference_id, dep_path_id, tar-get_type, target_id,
    target_summary_data from lsw_po_reference where branch_id = ?
    and start_seq_num <= ? and end_seq_num > ?]; SQL state [null];
    error code [-4470]; [jcc][t4][10120][10898][4.11.69] Invalid
    operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null;
    nested exception is com.ibm.db2.jcc.am.SqlException:
    [jcc][t4][10120][10898][4.11.69] Invalid operation: result set
    is closed. ERRORCODE=-4470, SQLSTATE=null
    Script (line 1):
    <B>   1 :
    Packages.com.lombardisoftware.core.sla.SLATracking.updateAllSLAs
    ();</B>
    
    
    PRODUCTS AFFECTED:
    IBM Business Process Manager (BPM) Advanced
    IBM BPM Standard
    IBM BPM Express
    

Local fix

Problem summary

  • First time running upon server startup caused transaction to
    close before data is completely read from database.
    

Problem conclusion

  • A fix is available for IBM BPM V8.5.5.0 that ensures an explicit
     transaction would be used.  Transaction would only be closed
    after data is completely read from database.
    
    
    On Fix Central (http://www.ibm.com/support/fixcentral), and
    search for JR50863:
    
    1. Select IBM Business Process Manager with your edition from
    the product selec-tor, the installed version to the fix pack
    level, and your platform, and then click Continue.
    2. Select APAR or SPR, enter JR50863, and click Continue.
    
    When you download fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR50863

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-07-24

  • Closed date

    2014-08-20

  • Last modified date

    2016-04-20

  • 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

  • R855 PSY

       UP



Document information

More support for: IBM Business Process Manager Standard

Software version: 8.5

Reference #: JR50863

Modified date: 20 April 2016