PI14932: SQL TOO COMPLEX TO RECORD FAILS TO CREATE ENTRY IN VIRTUALIZATION DATABASE SILENTLY!

Rational Integration Tester 8.7
Rational Test Virtualization Server 8.7
Rational Performance Test Server 8.7
Rational Test Virtualization Server Fix Pack 1 (8.7.0.1) for 8.7
Rational Integration Tester Fix Pack 1 (8.7.0.1) for 8.7
Rational Performance Test Server Fix Pack 2 (8.7.0.2) for 8.7
Rational Integration Tester Fix Pack 2 (8.7.0.2) for 8.7
Rational Test Virtualization Server Fix Pack 2 (8.7.0.2) for 8.7
Rational Test Virtualization Server Fix Pack 3 (8.7.0.3) for 8.7
Rational Integration Tester Fix Pack 3 (8.7.0.3) for 8.7
Rational Performance Test Server Fix Pack 1 (8.7.0.1) for 8.7
Rational Integration Tester Fix Pack 4 (8.7.0.4) for 8.7
Rational Test Virtualization Server Fix Pack 4 (8.7.0.4) for 8.7
Rational Performance Test Server Fix Pack 4 (8.7.0.4) for 8.7
Rational Performance Test Server Fix Pack 3 (8.7.0.3) for 8.7

APAR status

• Closed as program error.

Error description

• Any such failure should be reported to the user along with the
  SQL so they understand the limitations of the recorded data, and
  have the possibility to simplify the SQL.
  

Local fix

• Simplify SQL to be recorded.  Clearly this is not always
  possible.  Turning on the diagnostic log will show the SQL too
  complex to record if the diagnostic log is subsequently reviewed
  from RTCP.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of Rational Integration Tester working with SQL.   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When recording SQL statements by using the Rational          *
  * Integration Tester JDBC driver in "learn" mode, a user could *
  * not determine whether the driver actually learned anything   *
  * with each statement.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix for this issue was provided in version 8.7.0 of Rational
  Integration Tester. The user can now see a "Report" field in
  Recording Studio that shows which tables, rows, and stored
  procedures were learned or affected by each statement.  This
  feature is accessed by selecting an SQL Event in Recording
  Studio.  The detail panel under the event rows shows the SQL
  parameters and the new "Report" field.  This feature enables a
  user to see if the driver has been able to learn anything with
  each statement.
  

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 INTEGRA TE

• Fixed component ID

  5725G79IT

Applicable component levels

• R800 PSN

     UP

• R801 PSN

     UP

• R850 PSN

     UP

• R851 PSN

     UP

• R860 PSN

     UP

• R870 PSY

     UP