IBM Support

JR45807: BHVC: UPGRADING TO BPM 8.0.1.0 THE EXPOSED UCA TAB NO LONGER RENDERS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • BPM 8.0.1.0 introduced a new column in LSW_UCA,
    UCA_EVENT_TYPE_REF.  Upon grading existing table values are
    empty (null). The value is required in the exposing console.
    The upgrade script does not update the existing rows to a valid
    number.
    
    Functionality broken from v8.0.0.0 and prior versions
    
    Start of Error Stack.
     00000033 wle           E   CWLLG1274E: An exception occurred.
    
    com.lombardisoftware.client.delegate.BusinessDelegateException:
    Name is null
     at
    com.lombardisoftware.client.delegate.BusinessDelegateException.a
    sBusinessDelegateException(BusinessDelegateException.java:41)
     at
    com.lombardisoftware.client.delegate.common.WebsphereDelegateHel
    per.doAsCurrentSubjectContextSensitive(WebsphereDelegateHelper.j
    ava:177)
     at
    com.lombardisoftware.client.delegate.RuntimeServicesDelegateDefa
    ult.getExposedItems(RuntimeServicesDelegateDefault.java:713)
     at
    com.lombardisoftware.processadmin.server.ProcessAdminServiceImpl
    .getExposedItems(ProcessAdminServiceImpl.java:726)
     at
    com.lombardisoftware.processadmin.server.ProcessAdminServiceImpl
    .getData(ProcessAdminServiceImpl.java:285)
     at
    com.lombardisoftware.processadmin.server.ProcessAdminServiceImpl
    .getData(ProcessAdminServiceImpl.java:193)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
    Method)
     at
    sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
    Impl.java:60)
     at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:37)
     at java.lang.reflect.Method.invoke(Method.java:611)
     at
    com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.j
    ava:569)
     at
    com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(
    RemoteServiceServlet.java:208)
     at
    com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(
    RemoteServiceServlet.java:248)
     at
    com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPo
    st(AbstractRemoteServiceServlet.java:62)
     at
    javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
     at
    javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
     at
    com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWr
    apper.java:1224)
     at
    com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser
    vletWrapper.java:774)
     at
    com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(Ser
    vletWrapper.java:456)
     at
    com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest
    (ServletWrapperImpl.java:178)
     at
    com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(We
    bAppFilterChain.java:136)
     at
    com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebApp
    FilterChain.java:97)
    

Local fix

  • Manually update column UCA_EVENT_TYPE_REF for rows where the
    value is null to the integer value 1.
    

Problem summary

  • When upgrading to 8.0.1 and trying to view the Exposing Tab in
    Process Admin Console, nothing displays.
    
    USER AFFECTED:
    Business Process Manager Advanced, Standard and Express users
    who have upgraded to 8.0.1 (with UCAs created in the older
    version) and try to view the exposing tab in Process Admin
    Console.
    
    PROBLEM DETAILED DESCRIPTION:
    The root cause here was when an upgrade was made to 8.0.1, a
    couple of columns were added to the UCA table (ie.
    UCA_EVENT_TYPE_REF) which are required to support the new
    functionality. During the upgrade procedure, a value was not
    populated in these columns. The code assumed that this value
    exists and does not handle the null value. This could have been
    prevented by having code that does not assume that the
    UCA_EVENT_TYPE_REF value will be null and also testing around
    the migration path.
    
    PROBLEM CONCLUSION:
    Code changes were made to set the UCA_EVENT_TYPE_REF to
    message/timer depending on the schedule type. In other words the
    code was made more robust to handle null values for
    UCA_EVENT_TYPE_REF.
    
    FIX AVAILABILITY:
    For 8.0.1 the fix was included with 8.0.1 Fixpack 1 (8.0.1.1)
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR45807

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-20

  • Closed date

    2013-04-23

  • Last modified date

    2013-04-23

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R801 PSY

       UP

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

Document Information

Modified date:
08 January 2022