IBM Support

JR51869: RESPONSE TIME IS LONG WHEN YOU SELECT AN EXPOSED PROCESS VARIABLE (EPV) IN THE PROCESS ADMIN CONSOLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In the Process Admin Console, when you modify the values of
    exposed process variables (EPV) for a given snapshot and you
    have a large number of snapshots installed, the list of EPVs for
    a selected snapshot might not populate. You see a warning that
    is similar to the following warning from the WebSphere Thread
    monitor in the log files, alike the following:
    
    ThreadMonitor W   WSVR0605W: Thread "WebContainer : 10"
    (00000342) has been active for 609683 milliseconds and may be
    hung.  There is/are 1 thread(s) in total in the server that may
    be hung.
     at
    oracle.jdbc.driver.OracleResultSetImpl.getInt
    (OracleResultSetImp
    l.java:896)
     at oracle.jdbc.driver.OracleResultSet.getInt
      (OracleResultSet.java:434)
     at com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getInt
      (WSJdbcResultSet.java:1503)
     at com.lombardisoftware.utility.db.QueryHelper.
      extractInteger(QueryHelper.java:412)
     at com.lombardisoftware.utility.db.QueryUtil.
      extractInteger(QueryUtil.java:285)
     at com.lombardisoftware.server.ejb.persistence.dao.autogen.
      FavoriteDAOAutoGen.readRow(FavoriteDAOAutoGen.java:113)
     at com.lombardisoftware.server.ejb.persistence.dao.
      FavoriteDAO.access$000(FavoriteDAO.java:41)
     at com.lombardisoftware.server.ejb.persistence.dao.
      FavoriteDAO$1.mapRow(FavoriteDAO.java:132)
     at com.lombardisoftware.server.ejb.persistence.dao.
      FavoriteDAO$1.mapRow(FavoriteDAO.java:128)
     at org.springframework.jdbc.core.RowMapperResultSetExtractor.
      extractData(RowMapperResultSetExtractor.java:92)
     at org.springframework.jdbc.core.JdbcTemplate$1.
      doInPreparedStatement(JdbcTemplate.java:653)
     at org.springframework.jdbc.core.JdbcTemplate.execute
      (JdbcTemplate.java:591)
     at org.springframework.jdbc.core.JdbcTemplate.query
      (JdbcTemplate.java:641)
     at org.springframework.jdbc.core.JdbcTemplate.query
      (JdbcTemplate.java:670)
     at org.springframework.jdbc.core.JdbcTemplate.query
      (JdbcTemplate.java:678)
     at org.springframework.jdbc.core.JdbcTemplate.query
      (JdbcTemplate.java:710)
     at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.
      query(SimpleJdbcTemplate.java:187)
     at com.lombardisoftware.server.ejb.persistence.dao.
      FavoriteDAO.findFavoritesExposedToUser(FavoriteDAO.java:128)
     at com.lombardisoftware.server.ejb.persistence.dao.FavoriteDAO.
      findFavoritesExposedToUser(FavoriteDAO.java:109)
     at com.lombardisoftware.server.ejb.runtime.RuntimeServicesCore.
      getFavoritesWithFilter(RuntimeServicesCore.java:394)
     at com.lombardisoftware.server.ejb.runtime.RuntimeServicesCore.
      itemIsExposedToUser(RuntimeServicesCore.java:646)
     at sun.reflect.GeneratedMethodAccessor604.invoke(Unknown
      Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke
      (DelegatingMethodAccessorImpl.java:37)
     at java.lang.reflect.Method.invoke(Method.java:611)
     at org.springframework.aop.support.AopUtils.
      invokeJoinpointUsingReflection(AopUtils.java:310)
     at org.springframework.aop.framework.
      ReflectiveMethodInvocation.invokeJoinpoint
      (ReflectiveMethodInvocation.java:182)
     at org.springframework.aop.framework.
      ReflectiveMethodInvocation.proceed
      (ReflectiveMethodInvocation.java:149)
     at com.lombardisoftware.utility.spring.
      TransactionInterceptor$1.call(TransactionInterceptor.java:46)
     at com.lombardisoftware.utility.spring.
      ProgrammaticTransactionSupport.executeWithNoTransaction
      (ProgrammaticTransactionSupport.java:585)
     at com.lombardisoftware.utility.spring.
      ProgrammaticTransactionSupport.execute
      (ProgrammaticTransactionSupport.java:312)
     at com.lombardisoftware.utility.spring.
      TransactionInterceptor.invoke(TransactionInterceptor.java:44)
     at org.springframework.aop.framework.
      ReflectiveMethodInvocation.proceed
      (ReflectiveMethodInvocation.java:171)
     at com.lombardisoftware.utility.spring.
      CoreEntryInterceptor.invoke(CoreEntryInterceptor.java:44)
     at com.lombardisoftware.utility.spring.
      PSCoreEntryInterceptor.invoke(PSCoreEntryInterceptor.java:14)
     at org.springframework.aop.framework.
      ReflectiveMethodInvocation.proceed
      (ReflectiveMethodInvocation.java:171)
     at org.springframework.aop.framework.JdkDynamicAopProxy.
      invoke(JdkDynamicAopProxy.java:204)
     at com.sun.proxy.$Proxy87.itemIsExposedToUser(Unknown Source)
     at com.lombardisoftware.server.ejb.runtime.
      RuntimeServicesBean$16.execute(RuntimeServicesBean.java:253)
     at com.lombardisoftware.server.ejb.runtime.
      RuntimeServicesBean$16.execute(RuntimeServicesBean.java:251)
     at com.lombardisoftware.server.ejb.EjbServerUtils.
      handleEjbCall(EjbServerUtils.java:86)
     at com.lombardisoftware.server.ejb.runtime.
      RuntimeServicesBean.handleEjbCall
      (RuntimeServicesBean.java:50)
     at com.lombardisoftware.server.ejb.runtime.
      RuntimeServicesBean.itemIsExposedToUser(RuntimeServicesBean.
      java:251)
     at com.lombardisoftware.server.ejb.runtime.
      EJSRemoteStatelessRuntimeServices_56b342c9.
      itemIsExposedToUser(Unknown Source)
     at com.lombardisoftware.server.ejb.runtime.
      _RuntimeServices_Stub.itemIsExposedToUser
      (_RuntimeServices_Stub.java:2330)
     at com.lombardisoftware.client.delegate.
      RuntimeServicesDelegateDefault$42.run
      (RuntimeServicesDelegateDefault.java:955)
     at java.security.AccessController.doPrivileged
      (AccessController.java:280)
     at com.lombardisoftware.client.delegate.common.
      WebsphereDelegateHelper.doAsCurrentSubjectContextSensitive
      (WebsphereDelegateHelper.java:197)
     at com.lombardisoftware.client.delegate.
      RuntimeServicesDelegateDefault.itemIsExposedToUser
      (RuntimeServicesDelegateDefault.java:952)
     at com.lombardisoftware.servlet.jsptags.epv.EpvListTag$1.
      visit(EpvListTag.java:118)
     at com.lombardisoftware.client.persistence.common.versioning.
      ReferenceHelper.breadthFirstVisit(ReferenceHelper.java:685)
     at com.lombardisoftware.client.persistence.common.versioning.
      ReferenceHelper.breadthFirstVisit(ReferenceHelper.java:669)
     at com.lombardisoftware.servlet.jsptags.epv.EpvListTag.
      doStartTag(EpvListTag.java:111)
     at com.ibm._jsp._cs_5F_epv._jspx_meth_lsw_EpvList_0
      (_cs_5F_epv.java:1085)
     at com.ibm._jsp._cs_5F_epv._jspService(_cs_5F_epv.java:351)
     at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.
      java:99)
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
    [...]
    

Local fix

Problem summary

  • When IBM BPM checks whether a EPV is exposed to the calling
    user, all favorites are queried for the given user for each EPV.
    When there the number of snapshots in the system is large,
    execution times for the various queries add up to a long overall
    response time.
    

Problem conclusion

  • A fix is/wil be available for IBM BPM V8.5.0.0 that improves the
    efficiency of the EPV query.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR51869:
    
    1. Select IBM Business Process Manager with your edition from
      the product selector, the installed version to the fix pack
      level, and your platform, and then click Continue.
    
    2. Select APAR or SPR, enter JR51869 , 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

  • Not applicable
    

Comments

APAR Information

  • APAR number

    JR51869

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-25

  • Closed date

    2015-01-28

  • Last modified date

    2015-01-28

  • 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

  • R850 PSY

       UP

[{"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":"8.5","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
28 January 2015