Troubleshooting
Problem
This technote explains the error "ORA-00933: SQL command not properly ended", when building Distribution Charts in IBM® Rational® ClearQuest®.
Cause
Attempting to build a simple Query in the ClearQuest client, and sorting on a Multi-line string field yields the following error message:
"ERROR! SQLExecDirect: RETCODE=-1, State=S1000, Native Error=933... SQL Statement="select T1.dbid,T1.id, T8.data as keywords, T2.name from Defect T1, multiline_text T8,ratl_replicas T2 where T1.dbid=T8.entity_dbid(+) and ...>
[OpenLink][ODBC][Oracle Server]ORA-00933: SQL command not properly ended".
The same error message also appears when a Multi-line string field is selected when creating Distribution Charts.
Resolving The Problem
This issue is a reported defect in ClearQuest. It is tracked by APAR number IC38127. This defect has been closed as an Oracle limitation. The distribution chart requires that you perform a SQL "GROUP BY" on the column used for the horizontal axis. Oracle does not permit the use of multiline text fields (LONG or CLOB) in a GROUP BY clause.
As a workaround, do not sort on Multi-line string fields in Queries. Also do not choose Multi-line fields when building Distribution Charts.
Note: This issue did not occur in ClearQuest 2001A since multiline string fields could not be selected to display either in a Distribution chart or Query result set.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21147337