JR58323: YOU SEE A NULLPOINTEREXCEPTION WHEN YOU START A PROCESS THAT HAS SEARCHABLE FIELD AND PIVOTTABLES ARE USED

bpm.8600.delta.repository

APAR status

• Closed as program error.

Error description

• When you try to start a process and the Saved Search
  acceleration tools are used, the process might fail. In the
  SystemOut.log file of the server, you find an exception like
  this exception:
  
  [8/22/17 15:58:55:684 CEST] 00000111 wle           E
  CWLLG2229E: An exception occurred in an EJB call.  Error:
  java.lang.NullPointerException
  
  com.lombardisoftware.core.TeamWorksException:
  java.lang.NullPointerException
   at
  com.lombardisoftware.core.TeamWorksException.asTeamWorksExceptio
  n(TeamWorksException.java:136)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.saveSearc
  hableValues(BPDInstanceDAO.java:1272)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.createBPD
  Instance(BPDInstanceDAO.java:216)
   at
  com.lombardisoftware.server.ejb.bpd.BPDEngineServicesCore.doStar
  tBPD(BPDEngineServicesCore.java:600)
  ...
  Caused by: java.lang.NullPointerException
   at
  com.lombardisoftware.server.core.pse.impl.PivotTableUtils.getCol
  umnNameFromMap(PivotTableUtils.java:466)
   at
  com.lombardisoftware.server.core.pse.impl.PivotTableUtils.pivotC
  olumnNameFromAlias(PivotTableUtils.java:237)
   at
  com.lombardisoftware.server.core.pse.impl.PivotTableUtils.pivotC
  olumnNameFromAlias(PivotTableUtils.java:196)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.updatePiv
  otTable(BPDInstanceDAO.java:1305)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.saveSearc
  hableValues(BPDInstanceDAO.java:1253)
  
  You see this exception either because your process model has a
  variable or business object property that is marked "Visible in
  Process Portal" and this variable or property uses a business
  object type that is a Selection simple type, or because you
  created a variable or business object property that is marked
  "Visible in Process Portal" and this variable or business object
  property used a business object type that was a simple type and
  later changed to a complex type.
  
  PRODUCTS AFFECTED
  IBM Business Process Manager (BPM) Advanced
  IBM BPM Standard
  IBM BPM Express
  

Local fix

Problem summary

• When the process instance data is saved, the variables and
  business object properties that are marked as "Visible in
  Process Portal" are stored in a separate database table to make
  them available for queries, such as saved searches. If you use
  Saved Search acceleration, IBM BPM must update another database
  table. The logic to prepare this database statement did not
  handle the case that the variable or business object property
  uses a Selection simple type or had been changed to a complex
  type in the meantime.
  

Problem conclusion

• A fix will be included in a future release of IBM BPM that
  correctly handles variable and business object properties that
  are marked as "Visible in Process Portal" and use a Selection
  simple type or a type that had been changed from a simple to a
  complex type.
  

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

• Fixed component name

  BPM ADVANCED

• Fixed component ID

  5725C9400

Applicable component levels

• R857 PSY

     UP