Troubleshooting
Problem
An error may occur when using Microsoft® SQL Server while performing database maintenance steps when certain permissions exist: Invalid object name 'master_global' and SQLNumResultCols: RETCODE=-1, State=S0002, Native Error=208 This technote addresses one issue that has been known to cause the "Invalid object name and SQLNumResultCols" errors in IBM® Rational® ClearQuest®, when you are using a SQL Server database back-end.
Symptom
The following errors might be return if the SQL Server databases used by ClearQuest are improperly configured:
From ClearQuest Maintenance Tool the error:
When trying to login to ClearQuest Web you may see the error:
When trying to login to ClearQuest Eclipse you may see the error:
When trying to login to ClearQuest Windows you may see the error:
[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database Configuration\/Connectivity - SQL Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"8.0;8.0.1;9.0","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
Modified date:
15 June 2026
UID
swg21980762