IBM Support

Invalid Descriptor Index when using cqtool to run a SQL query

Troubleshooting


Problem

An Invalid Descriptor Index error occurs when using the IBM Rational ClearQuest (CQ) command "cqtool" to run a SQL edited query.

Symptom

When using cqtool to run a SQL edited query, this error occurs:

cqcli error: An exception occurred
Caught a CQException at the JNI Boundary: \bugbert.src\cqobjectmodel\cqresultset.cpp: line 179-CRMDB0001E SQLGetData: RETCODE=-1, State=S1002, Native Error=0
[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index


The query works in the Web and Windows Client interfaces, but not in cqtool.

Cause

SQL Server does not recognize the query when cqtool is used to run it.

Resolving The Problem

The problem is not with the ClearQuest, but with the SQL Server Driver. Possible solutions are listed here:

java.sql.SQLException:[Microsoft][ODBC Driver Manager] Invalid descriptor index


One of the causes is that the the driver has trouble with the order of columns in the query. Putting all of the multi-line string fields (Text data type in SQL server) at the end of the query, allows the query to run successfully with cqtool.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Command Line Tools","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.0;8.0.0.1;8.0.0.2;8.0.0.3;8.0.0.4;8.0.0.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21681425

Page Feedback