Fixes are available
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSBLQQ","label":"Rational Test Workbench"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.7","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
16 October 2021