IBM Support

ERROR: Invalid object name 'master_global', when not using a read-only username and password in ClearQuest

Troubleshooting


Problem

This technote explains an error "Invalid object name 'master_global'" that can occur in IBM® Rational® ClearQuest® when the database owner and passwords are improperly configured in Microsoft® SQL Server.

Symptom

This error occurs in ClearQuest when a non Read-Only DBO Username and Password is used with a Microsoft SQL Server database:



    Database Error Messages: SQLExecDirect: RETCODE=-1, State=S0002, Native Error=208
    SQL statement="select metaschema_version from master_global"
    [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'master_global'.


    An error was encountered with the database. You may have specified a database of unknown origin or a ClearQuest database instead of a ClearQuest Schema Repository. Please specify a valid ClearQuest Schema Repository.
[{"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":"2003.06.00;2003.06.12;2003.06.13;2003.06.14;2003.06.15;2003.06.16;7.0;7.0.0.1;7.0.0.2;7.0.0.3;7.0.0.4;7.0.0.5;7.0.1;7.0.1.1;7.0.1.2;7.0.1.3;7.0.1.4","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.

Document Information

More support for:
Rational ClearQuest

Software version:
2003.06.00, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15, 2003.06.16, 7.0, 7.0.0.1, 7.0.0.2, 7.0.0.3, 7.0.0.4, 7.0.0.5, 7.0.1, 7.0.1.1, 7.0.1.2, 7.0.1.3, 7.0.1.4

Operating system(s):
Windows

Document number:
326123

Modified date:
16 June 2018

UID

swg21127846

Manage My Notification Subscriptions