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

Version 8.0.1 Fix Pack 1 for the IBM Business Process Manager products
Download Version 8.0.1 Fix Pack 2 for the IBM Business Process Manager products

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 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