JR57812: DOC - LIMITATION REGARDING STORING NAN AND INFINITY JAVASCRIPT VALUES IN SEARCHABLE PROCESS VARIABLES IS NOT DOCUMENTED

bpm.8570.cf2017.06.delta.repository

APAR status

• Closed as documentation error.

Error description

• When you assign the NaN or Infinity JavaScript value to an IBM
  Business Process Manager (BPM) variable of type Decimal that is
  marked as "Visible in Process Portal" in IBM Process Designer
  and IBM BPM tries to persist this variable in the database, you
  see the following exception in the log file:
  
  CWLLG0323E: An exception occurred in saveSearchableValues,
  reason:java.lang.NumberFormatException: Not a valid char
  constructor input: NaN.
  java.lang.NumberFormatException: Not a valid char constructor
  input: NaN
   at java.math.BigDecimal.bad(BigDecimal.java:1859)
   at java.math.BigDecimal.charParser(BigDecimal.java:1190)
   at java.math.BigDecimal.<init>(BigDecimal.java:922)
   at java.math.BigDecimal.<init>(BigDecimal.java:901)
   at com.ibm.db2.jcc.am.ic.a(ic.java:413)
   at com.ibm.db2.jcc.am.ic.a(ic.java:1200)
   at com.ibm.db2.jcc.am.ic.a(ic.java:1180)
   at com.ibm.db2.jcc.am.kn.a(kn.java:2007)
   at com.ibm.db2.jcc.am.kn.setObject(kn.java:1897)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJd
  bcPreparedStatement.java:2476)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.placeItem
  (BPDInstanceDAO.java:1384)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.placeItem
  InUpdateStatement(BPDInstanceDAO.java:1364)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.placeItem
  InStatement(BPDInstanceDAO.java:1319)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.updateExi
  stingBDVariables(BPDInstanceDAO.java:1235)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.saveSearc
  hableValues(BPDInstanceDAO.java:1012)
   at
  com.lombardisoftware.bpd.runtime.engine.BPDInstanceDAO.save(BPDI
  nstanceDAO.java:342)
  
  
  PRODUCTS AFFECTED
  IBM BPM Advanced
  IBM BPM Standard
  IBM BPM Express
  

Local fix

Problem summary

• The data type of the database column that holds searchable
  variable values of type Decimal cannot hold values that are not
  a number.
  

Problem conclusion

• The limitation will be added the next time the documentation is
  refreshed.
  

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 STANDARD

• Fixed component ID

  5725C9500

Applicable component levels