PM77595: EGL Debugger throws NPE with foreach statement returning an empty Resultset

Rational Business Developer Fix Pack 5 (8.0.1.5) for 8.0.1
Rational Business Developer 9.0
Rational Business Developer Fix Pack (8.5.1.1) for 8.5.1
Rational Business Developer Fix Pack 2 (8.5.1.2) for 8.5.1

APAR status

• Closed as program error.

Error description

• Environment: windows
  Product name: IBM? Rational? Business Developer
  
  Program Version    :  8.0.1.4
  Description. Things that you have tried to resolve.
  The EGL debugger throws a NullPointerException when returning an
  empty Resultset via a 'foreach' statement.
  
  Stepping through the EGL source which calls the Stored Procedure
  when the resultset returns the applicable DB2 records this works
  as expected. However when the result set is empty the error is
  thrown ie Foreach failed: EGL0099E:java.lang.
  
  Using a ?get next? statement returns the correct output in the
  same scenario as does running the generated Java application
  directly so the problem resides only with the EGL debugger and a
  foreach.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In some cases, when iterating over a result set with the
  foreach statement, an unexpected NullPointerException
  occurs.
  

Problem conclusion

• The exception no longer occurs and the foreach statement
  correctly iterates over the result set.
  

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

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R801 PSN

     UP