Troubleshooting
Problem
This technote explains "Incorrect syntax" or "Reserved word" errors that can occur when moving or creating IBM Rational ClearQuest databases on Microsoft SQL Server 2005 or 2008.
Symptom
Creating a schema repository or user database with the destination as a SQL Server 2005 back end database prompts this error:
SQLExecDirect: RETCODE=-1, State=37000, Native Error=-3504
SQL statement='select from master_global'
[Microsoft][ODBC Microsoft Access Driver]The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
These similar error messages can also occur:
SQLExecDirect: RETCODE=-1, State=37000, Native Error=156
SQL statement="select from master_global"
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'from'. CRMDB001E SQLExecDirect: RETCODE=-1, State=37000, Native Error=-3504
[Microsoft][ODBC Microsoft Access Driver]The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
SQL statement="select from master_global"
[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database Configuration\/Connectivity - SQL Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0;7.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Designer - Database Administration","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Maintenance tool","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
Rational ClearQuest
Software version:
7.0, 7.1
Operating system(s):
Windows
Document number:
83859
Modified date:
29 September 2018
UID
swg21239777
Manage My Notification Subscriptions