IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    PI14932

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-04-01

  • Closed date

    2015-05-21

  • Last modified date

    2015-05-21

  • 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



Document information

More support for: Rational Test Workbench

Software version: 8.5

Reference #: PI14932

Modified date: 21 May 2015