IBM Support

JR46249: A BATCHED DATABASE UPDATE IS EXECUTED IN AN INCOMPLETE FASHION CAUSINGTASKS NOT TO GET SCHEDULED IN PROCESS SERVER

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When trying to schedule tasks for time-elapsed UCAs, a Process
    Server running on an Oracle database emits the following error:
    
     CWLLG0188E: An exception occurred scheduling the next
    execution for
    task 218,355  with description ''Execute UCA Periodic SLA
    Update, on set
    schedule''.  Error: error occurred during batching: batch must
    be either
    executed or cleared
    
    com.lombardisoftware.core.TeamWorksException: error occurred
    during
    batching: batch must be either executed or cleared
     at
     com.lombardisoftware.core.TeamWorksException.asTeamWorksExcepti
    on(TeamW
    orksException.java:136)
     at
     com.lombardisoftware.utility.db.DbUtils$1.doInTransaction(DbUti
    ls.java:
    77)
     at
    com.lombardisoftware.server.core.TXCommand$3.call(TXCommand.java
    :96)
     at
     com.lombardisoftware.utility.spring.ProgrammaticTransactionSupp
    ort$1.do
    InTransaction(ProgrammaticTransactionSupport.java:400)
     at
     org.springframework.transaction.jta.WebSphereUowTransactionMana
    ger$UOWA
    ctionAdapter.run(WebSphereUowTransactionManager.java:306)
     at
     com.ibm.ws.uow.EmbeddableUOWManagerImpl.runUnderNewUOW(Embeddab
    leUOWMan
    agerImpl.java:786)
     at
     com.ibm.ws.uow.EmbeddableUOWManagerImpl.runUnderUOW(EmbeddableU
    OWManage
    rImpl.java:365)
     at
     org.springframework.transaction.jta.WebSphereUowTransactionMana
    ger.exec
    ute(WebSphereUowTransactionManager.java:252)
     at
     com.lombardisoftware.utility.spring.ProgrammaticTransactionSupp
    ort.exec
    uteInNewTransaction(ProgrammaticTransactionSupport.java:395)
     at
     com.lombardisoftware.utility.spring.ProgrammaticTransactionSupp
    ort.exec
    ute(ProgrammaticTransactionSupport.java:264)
     at
     com.lombardisoftware.server.core.TXCommand.executeInDeadlockRet
    ryLoop(T
    XCommand.java:94)
     at
     com.lombardisoftware.utility.db.DbUtils.executeInTransaction(Db
    Utils.ja
    va:72)
     at
     com.lombardisoftware.server.scheduler.Engine.scheduleNextExecut
    ion(Engi
    ne.java:963)
     at
     com.lombardisoftware.server.scheduler.Engine.executeTasks(Engin
    e.java:4
    76)
     at
     com.lombardisoftware.server.scheduler.Timer.executeTasks(Timer.
    java:136
    )
     at
     com.lombardisoftware.server.scheduler.Timer.access$400(Timer.ja
    va:31)
     at
     com.lombardisoftware.server.scheduler.Timer$TimerRunnable.run(T
    imer.jav
    a:115)
     at
     com.lombardisoftware.client.delegate.common.WebsphereDelegateHe
    lper$2$1
    .run(WebsphereDelegateHelper.java:78)
     at
     java.security.AccessController.doPrivileged(AccessController.ja
    va:314)
     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.WebsphereDelegateHe
    lper.doA
    s(WebsphereDelegateHelper.java:150)
     at
     com.lombardisoftware.client.delegate.common.WebsphereDelegateHe
    lper$2.r
    un(WebsphereDelegateHelper.java:74)
     at java.lang.Thread.run(Thread.java:772)
    Caused by: java.sql.SQLException: error occurred during
    batching: batch
    must be either executed or cleared
     at
     oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Orac
    lePrepar
    edStatement.java:3435)
     at
     oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(Oracle
    Prepared
    Statement.java:3530)
     at
     oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate
    (OracleP
    reparedStatementWrapper.java:1350)
     at
     com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpd
    ate(WSJd
    bcPreparedStatement.java:1185)
     at
     com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate
    (WSJdbcP
    reparedStatement.java:802)
     at
     com.lombardisoftware.server.scheduler.Engine.scheduleNextExecut
    ion(Engi
    ne.java:1039)
     at
     com.lombardisoftware.server.scheduler.Engine.scheduleNextExecut
    ion(Engi
    ne.java:987)
     at
     com.lombardisoftware.server.scheduler.Engine.access$1800(Engine
    .java:78
    )
     at
     com.lombardisoftware.server.scheduler.Engine$9.execute(Engine.j
    ava:965)
     at
     com.lombardisoftware.server.scheduler.Engine$9.execute(Engine.j
    ava:963)
     at
     com.lombardisoftware.utility.db.DbUtils.executeWithConnection(D
    bUtils.j
    ava:36)
     at
     com.lombardisoftware.utility.db.DbUtils$1.doInTransaction(DbUti
    ls.java:
    75)
     ... 23 more
    

Local fix

  • N/A
    

Problem summary

  • A batched database update is executed in an incomplete fashion
    on a Process Server running against Oracle.
    

Problem conclusion

  • The update call is modified to execute the full batch.
    
    
    FIX AVAILABILITY:
    iFix on top of BPM V8.0.1.1 is available on Fix Central,
    search for APAR JR46249 at
    http://www.ibm.com/support/fixcentral/
    
    Fix is also targetted for inclusion in next fixpack for BPM
    V8.0.1.2
    
    When obtaining any of the above fixes, be sure to download the
    accompanying readme, for itself and any prerequisite fixes, and
    review them thorougly
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR46249

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-04

  • Closed date

    2013-08-29

  • Last modified date

    2013-08-29

  • 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

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
07 January 2022