IBM Support

PI12473: DB2 RESULTS DATABASE NPE / EXECUTION ID IS EMPTY WHEN SCHEMA != USERNAME

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A number of error have occurred and after consultation with the
    development team it would appear that these are caused because
    the username is (converted to upper case) and used as the schema
    in some queries, but that is not valid when the connection
    string supplied a connection name.
    

Local fix

  • Make the user name of the connecting user the same as the schema
    name.  (This is not possible at all client sites.)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of Rational Integration Tester to run tests        *
    * against DB2.                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Users could see null pointer exceptions in the Rational      *
    * Integration Tester tool when running tests against a DB2     *
    * schema with a lower case name where the schema name and user *
    * name are the same.                                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • This problem was caused by Rational Integration Tester
    upper-casing the username and using it as the schema name.  This
    problem has been fixed in version 8.6.0.1 of Rational
    Integration Tester.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI12473

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    851

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-02-25

  • Closed date

    2014-09-01

  • Last modified date

    2014-09-01

  • 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 PSY

       UP



Document information

More support for: Rational Test Workbench

Software version: 8.5.1

Reference #: PI12473

Modified date: 01 September 2014