Fixes are available
Rational ClearQuest Fix Pack (8.0.0.1) for version 8.0
Rational ClearQuest Fix Pack (7.1.2.5) for version 7.1.2
Rational ClearQuest Fix Pack 14 (7.1.2.14) for 7.1.2
Rational ClearQuest Fix Pack 11 (8.0.0.11) for 8.0
Rational ClearQuest Fix Pack 12 (8.0.0.12) for 8.0
Rational ClearQuest Fix Pack 15 (7.1.2.15) for 7.1.2
Rational ClearQuest Fix Pack 13 (8.0.0.13) for 8.0
Rational ClearQuest Fix Pack 16 (7.1.2.16) for 7.1.2
Rational ClearQuest Fix Pack 17 (7.1.2.17) for 7.1.2
Rational ClearQuest Fix Pack 14 (8.0.0.14) for 8.0
Rational ClearQuest Fix Pack 18 (7.1.2.18) for 7.1.2
Rational ClearQuest Fix Pack 15 (8.0.0.15) for 8.0
Rational ClearQuest Fix Pack 19 (7.1.2.19) for 7.1.2
Rational ClearQuest Fix Pack 16 (8.0.0.16) for 8.0
Rational ClearQuest Fix Pack 17 (8.0.0.17) for 8.0
Rational ClearQuest Fix Pack 18 (8.0.0.18) for 8.0
Rational ClearQuest Fix Pack 19 (8.0.0.19) for 8.0
Rational ClearQuest Fix Pack 20 (8.0.0.20) for 8.0
Rational ClearQuest Fix Pack 21 (8.0.0.21) for 8.0
APAR status
Closed as program error.
Error description
Setting up Full Text Search on a db2 9.7 FP3 database using default DataDirect drivers gives error 'No more available statements' at the initialization state. C:\Program Files\IBM\RationalSDLC\ClearQuest?cqperl cqtsadmin.pl --username admin n --password '' --dbset ibmdb2 --userdb vidya --ftshome C:\CQ.Search --init_cq_fts Exception in thread 'main' com.rational.clearquest.cqjni.CQException: Caught a CQException at the JNI Boundary: \bugbert.src\cqobjectmodel\cqresultset.cpp: line 179-CRMDB0001E SQLExecDirect: R ETCODE=-1, State=S1000, Native Error=8292 [IBM Rational DataDirect][ODBC DB2 Wire Protocol driver]No more available statements. Please recreate your package with a larger dynamicSections value. SQL statement='select count(*) from customer_4 where dbid ?? 0' at com.ibm.rational.clearquest.cqtscrawler.common.ConfigGenerator.p rintProcessEntityFields(ConfigGenerator.java:524) at com.ibm.rational.clearquest.cqtscrawler.common.ConfigGenerator.g enerateEntityFile(ConfigGenerator.java:151) at com.ibm.rational.clearquest.cqtscrawler.common.ConfigGenerator.m ain(ConfigGenerator.java:120) The same command works fine using using DB2 drivers.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * **************************************************************** Setting up ClearQuest Full Text Search against a DB2 9.7 FP3 Database results in the following error message: [IBM Rational DataDirect][ODBC DB2 Wire Protocol driver]No more available statements. Please recreate your package with a larger dynamicSections value.
Problem conclusion
A fix is available in ClearQuest 7.1.1.8, 7.1.2.5, and 8.0.0.1
Temporary fix
Comments
APAR Information
APAR number
PM39779
Reported component name
CLEARQUEST WIN
Reported component ID
5724G3600
Reported release
711
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-05-20
Closed date
2011-12-16
Last modified date
2011-12-16
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
R711 PSN
UP
Document Information
Modified date:
16 December 2011