JR42715: EXCEPTION WHEN USING PROCESS INSPECTOR IN PROCESS ADMIN CONSOLE IN RUNTIME ENV

Version 7.5.1 Fix Pack 1 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• Exception occurs when using Process Inspector web version via
  Process Admin console on Runtime env. The issue appeared to be
  related to DB2 9.5.7 version.
  

Local fix

• The error goes away if DB2 is upgraded to 9.7 release
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Users of BPM Express, Standard, and         *
  *                  Advanced.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Exception occurs when using Process     *
  *                      Inspector web version via Process Admin *
  *                      console on Runtime env. The issue       *
  *                      appeared to be related to DB2 9.5.7     *
  *                      version.                                *
  ****************************************************************
  * RECOMMENDATION:  Recommended fix.                            *
  ****************************************************************
  Using the web-based Process Inspector in 7.5.1 using DB2 9.5.7
  leads to a blank screen and ProcessAdminRestException in logs.
  Excerpt from stack trace:
  Caused by:
  com.ibm.processinspector.rest.ProcessAdminRestException:
  {"status":"error","Data":
  {"status":"error","exceptionType":"com.ibm.bpm.wle.api.Unexpecte
  dFailureException","errorNumber":"CWTBG0019E","errorMessage":"CW
  TBG0019E: Unexpected exception during
  execution.","errorMessageParameters":null,"programmersDetails":"
  none","responses":null}}
  at
  com.ibm.processinspector.rest.BaseProcessInspectorRestAPI.getRes
  ponseData(BaseProcessInspectorRestAPI.java:629)
  at
  com.ibm.processinspector.rest.ProcessInstanceSearchAPIImpl.getTa
  skSummaryDetailSortedByDateModified(ProcessInstanceSearchAPIImpl
  .java:1079)
  ... 37 more
  [2/10/12 10:53:40:622 CET] 00000067 srt           W
  com.ibm.ws.webcontainer.srt.SRTServletResponse setStatus
  WARNING: Cannot set status. Response already committed.
  [2/10/12 10:53:40:622 CET] 00000067 srt           W
  com.ibm.ws.webcontainer.srt.SRTServletResponse addHeader
  WARNING: Cannot set header. Response already committed.
  [2/10/12 10:56:21:614 CET] 00000062 wle_security  I
  CWLLG1088I: Initializing session is done for user admin
  [2/10/12 10:56:21:632 CET] 00000062 wle           W
  CWLLG2101W: Retries were explicitly requested in
  ProgrammaticTransactionSupport but no new transaction is started
  5 definition: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
  retryLimit:
  {2}
  [2/10/12 10:56:21:644 CET] 00000062 wle           E
  CWLLG2229E: An exception occurred in an EJB call.  Error:
  ConnectionCallback; bad SQL grammar []; nested exception is
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
  SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.61.65
  com.lombardisoftware.client.delegate.BusinessDelegateException:
  ConnectionCallback; bad SQL grammar []; nested exception is
  com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
  SQLCODE=-401, SQLSTATE=42818, SQLERRMC==, DRIVER=3.61.65
  The issue was incorrect SQL syntax related to using quotation
  marks in decimal comparisons which newer versions of DB2 auto-
  correct.
  

Problem conclusion

• Replace incorrect decimal comparison syntax with the correct
  usage by removing unnecessary quotation marks from the query
  used to populate Process Inspector.
  
  Problem is fixed in interim fix available in Fix Central.
  Problem is also fixed in future releases.
  

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

• R750 PSY

     UP