RS03818: DECISION TABLE EXPORT TO EXCEL FAILS IF CELL CONTAINS AN OPERATOR AND NO VALUE

APAR status

• Closed as program error.

Error description

• In the Business Console, if a Decision Table cell has an
  operator defined but contains no value, the export to Excel
  fails for this cell and all subsequent cells or never completes.
  
  
  Below exception is thrown in server logs:
  com.ibm.rules.decisioncenter.dtx                             W
  Could not export decision table 'dt_error': null
  java.lang.NullPointerException
  at com.ibm.rules.bdsl.dtx.xl.DtxExcelWriter.addCell(DtxExcelWri
  ter.java:636)
  at com.ibm.rules.bdsl.dtx.xl.DtxExcelWriter.write(DtxExcelWrite
  r.java:421)
  at com.ibm.rules.decisioncenter.web.core.DecisionTableControlle
  r.exportToExcel(DecisionTableController.java:129)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
  ssorImpl.java:90)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
  thodAccessorImpl.java:55)
  at java.lang.reflect.Method.invoke(Method.java:508)
  at org.springframework.web.method.support.InvocableHandlerMetho
  d.doInvoke(InvocableHandlerMethod.java:209)
  

Local fix

• edit Decision Table, right click on cell > clear > save
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users exporting Decision Table to Excel from Business        *
  * Console.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In the Business Console, if a Decision Table cell has an     *
  * operator defined but contains no value, the export to Excel  *
  * fails for this cell and all subsequent cells or never        *
  * completes.                                                   *
  *                                                              *
  *                                                              *
  * Below exception is thrown in server logs:                    *
  * com.ibm.rules.decisioncenter.dtx                             *
  * W                                                            *
  * Could not export decision table 'dt_error': null             *
  * java.lang.NullPointerException                               *
  * at                                                           *
  * com.ibm.rules.bdsl.dtx.xl.DtxExcelWriter.addCell(DtxExcelWri *
  * ter.java:636)                                                *
  * at                                                           *
  * com.ibm.rules.bdsl.dtx.xl.DtxExcelWriter.write(DtxExcelWrite *
  * r.java:421)                                                  *
  * at                                                           *
  * com.ibm.rules.decisioncenter.web.core.DecisionTableControlle *
  * r.exportToExcel(DecisionTableController.java:129)            *
  * at sun.reflect.NativeMethodAccessorImpl.invoke0(Native       *
  * Method)                                                      *
  * at                                                           *
  * sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce *
  * ssorImpl.java:90)                                            *
  * at                                                           *
  * sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe *
  * thodAccessorImpl.java:55)                                    *
  * at java.lang.reflect.Method.invoke(Method.java:508)          *
  * at                                                           *
  * org.springframework.web.method.support.InvocableHandlerMetho *
  * d.doInvoke(InvocableHandlerMethod.java:209)                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Export to Excel now succeeds.
  

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

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels