PI85835: CQ Reporitng Driver fails to connect to Crystal Reports Change Management (CM) Data Source

Rational ClearQuest Fix Pack 2 (9.0.1.2) for 9.0.1
Rational ClearQuest Fix Pack 6 (9.0.0.6) for 9.0
Rational ClearQuest Fix Pack 3 (9.0.1.3) for 9.0.1
Rational ClearQuest Fix Pack 4 (9.0.1.4) for 9.0.1
Rational ClearQuest Fix Pack 5 (9.0.1.5) for 9.0.1
Rational ClearQuest Fix Pack 6 (9.0.1.6) for 9.0.1
Rational ClearQuest Fix Pack 7 (9.0.1.7) for 9.0.1
Rational ClearQuest Fix Pack 8 (9.0.1.8) for 9.0.1
Rational ClearQuest Fix Pack 9 (9.0.1.9) for 9.0.1

APAR status

• Closed as program error.

Error description

• When trying to create a JDBC connection using the ClearQuest
  Reporting Driver for Change Mangaement (CM) data sources
  example:
  jdbc:cq:9.0.1/SAMPL@http://ServerName:12080/TeamWeb/services/Tea
  m
  
  error:
  "Failed to open the connection"
  
  No packets are created on the network interface either.
  
  Versions affected:
  ClearQuest 9.0.0.4 and ClearQuest 9.0.1
  

Local fix

• Temporary consider using JNI data sources:
  example:
  jdbc:cq:9.0.1/SAMPL
  
  Temporarily design Crystal reports using CQ 8.0.1.x.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ClearQuest Reporting                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Attempting to connect to ClearQuest from Crystal Report will *
  * fail.                                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A technote has been published on how to fix the issue by adding
  missing JAR files to your Crystal Reports configuration.  The
  technote ID is 2008801 and the link to the technote is:
  http://www-01.ibm.com/support/docview.wss?uid=swg22008801
  

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

  CLEARQUEST WIN

• Fixed component ID

  5724G3600

Applicable component levels

• R900 PSY

     UP