Configuring Rational Team Concert 3.0 with Oracle 11g - recommended driver and database version

Technote (troubleshooting)


Problem(Abstract)

This technote explains how to resolve Oracle ORA-03137 errors, that can occur when using IBM Rational Team Concert.

Symptom

When configuring Rational Team Concert 3.0 with Oracle 11g, the recommended driver and database version is 11.2.0.2.0 or higher, so as to avoid ORA-03137 errors.

The Rational Team Concert / CCM application may experience errors and/or warnings and the Oracle DB server may exhibit ORA-03137 errors, after the server has been under load for at least 10 hours.

CCM application errors and/or warnings (CRJAZ0368I) in the server log are caused by the following exception:


    java.sql. SQLException: No more data to read from socket

at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine
    .java:1142)

at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine
    .java:1099)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

.....

and Oracle reports ORA-03137: TTC protocol internal error

Cause

Oracle bug 8588311 - PREPAREDSTATEMENT.SETBINARYSTREAM() DOES NOT READ ALL THE DATA FROM THE STREAM

Oracle bug 9703463 - APPS_BM_WKLDSTS: APPS ENCOUNTERED ORA-03137 WHILE BENCHMARK REPLAY

Environment

Rational Team Concert 3.0

Oracle 11g R2 (11.2.0.1.0 driver and database)

Diagnosing the problem

  • Rational Team Concert version is 3.0
  • Repository database is Oracle
  • Oracle database and driver version is 11.2.0.1.0
  • CCM application errors and/or warnings (CRJAZ0368I) in the server log are caused by the following exception:

    java.sql.SQLException: No more data to read from socket


at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine
    .java:1142)

at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine
    .java:1099)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:288)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

.....

  • Oracle reports ORA-03137: TTC protocol internal error

Resolving the problem

To resolve the problem, use a 11.2.0.2.0 (or higher) Oracle driver (ojdbc5.jar or ojdbc6.jar) on the application server and a 11.2.0.2.0 (or higher) database on the database server.

Note: If using WebSphere Application Server 7 which is based on a 1.6 JVM, use the ojdbc6 driver.

Leverage the Jazz Community
Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

Related information

jazz.net work item 132612

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Team Concert
Repository

Software version:

3.0

Operating system(s):

Linux, Windows

Reference #:

1461402

Modified date:

2012-05-15

Translate my page

Machine Translation

Content navigation