IBM Support

PI52918: JAVA.SQL.SQLEXCEPTION: ORA-02449 WHEN STARTING DATABASE STUB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • E java.sql.SQLException: ORA-02449
    
    STEPS TO REPRODUCE
    
    1. Create a database stub using the Recording Studio method
    2. Use your own database instead of the integration database
    3. Record the events
    4. End the recording to create the stub
    5. In Test Factory start the newly created stub
    
    EXPECTED RESULTS
    
    The database should start normally
    
    ACTUAL RESULTS
    
    An error message similar to this appears
    
    [11/19/2015 10:54:36.641 AM] Nov 19, 2015 10:54:36 AM
    com.ghc.ghTester.testexecution.model.DatabaseStubLaunch startup
                              SEVERE: Caught exception while
    starting stub.
                              java.sql.SQLException: ORA-02449:
    unique/primary keys in table referenced by foreign keys
    
                                      at
    oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    
    WORKAROUND
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of IBM Rational Integration Tester                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Attempts to start a database stub containing foreign keys    *
    * resulted in the following error:                             *
    *                                                              *
    * java.sql.SQLException: ORA-02449: unique/primary keys in     *
    * table referenced by foreign keys                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to the JDBC Proxy version 9.0.                        *
    * The JDBC Proxy is found on the Tools page of Rational Test   *
    * Control Panel (RTCP)                                         *
    ****************************************************************
    

Problem conclusion

  • This problem is fixed in version 9.0 of the JDBC Proxy.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI52918

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    870

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-11-20

  • Closed date

    2016-04-14

  • Last modified date

    2016-04-14

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

       UP

  • R871 PSN

       UP

  • R900 PSY

       UP



Document information

More support for: Rational Test Workbench

Software version: 8.7

Reference #: PI52918

Modified date: 14 April 2016