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

Rational Integration Tester 9.0
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

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