PM82711: EXECUTION OF STORED PROCEDURES FAILS WITH "INVALID COLUMN INDEX" ERROR

Rational Performance Test Server Fix Pack 3 (8.0.1.3) for 8.0.1
Rational Test Virtualization Server Fix Pack 3 (8.0.1.3) for 8.0.1
Rational Test Workbench Fix Pack 3 (8.0.1.3) for 8.0.1
Rational Integration Tester Fix Pack 6 (8.0.1.6) for 8.0.1
Rational Integration Tester Fix Pack 5 (8.0.1.5) for 8.0.1
Rational Performance Test Server Fix Pack 6 (8.0.1.6) for 8.0.1
Rational Test Virtualization Server Fix Pack 6 (8.0.1.6) for 8.0.1

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE<br/>1. Enable stored procedures in the
  physical database connection Advanced tab.<br/>2. Create a
  logical database connection and bind to the physical one.<br/>3.
  In your test add a stored procedure step.<br/>4. Select a stored
  procedure with multiple OUT parameters<br/>5. Run the
  test<br/><br/>EXPECTED RESULT<br/><br/>The stored procedure
  executes and returns data.<br/><br/>ACTUAL RESULT<br/><br/>An
  error message is returned such as &quot;Invalid column
  index&quot;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users who are creating tests that execute stored procedures  *
  * that have output parameters.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Tester does not correctly process output parameter ordering  *
  * where there are multiple output parameters.  This leads to a *
  * failure in RIT.  There is no workaround.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to a fix pack containing a fix.                      *
  ****************************************************************
  

Problem conclusion

• This problem was resolved in Rational Integration Tester fix
  pack 8.0.1.3.<br/><br/>This problem was also resolved in GH
  Tester 5.4.0.20.
  

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:

Modules/Macros

• Unknown
  

Fix information

• Fixed component name

  GREEN HAT TESTE

• Fixed component ID

  5725G79GT

Applicable component levels

• R540 PSY

     UP