IBM Support

PM39779: Setting up Full Text Search on a db2 9.7 database gives DataDirect error 'No more available statements'

Subscribe

You can track all active APARs for this component.

 

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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
16 December 2011