Topic
  • 2 replies
  • Latest Post - ‏2014-12-29T09:05:31Z by RAHS
JirongHu
JirongHu
683 Posts

Pinned topic How to force CCCQ UCM disconnect?

‏2012-11-27T01:18:46Z |
Hi

Our CQ test environment is screwed with the following error when I try to login "A fatal error occurred while getting the list of user database from the schema repository. Invalid object name ‘master_global’." I don't know what happened, somebody was trying to create a new schema database.

Is there a way to disconnect the CQ from our CCCQ UCM integration? Of course, I won't be able to do that from GUI. Tons of error when I try to access CQ tab from CC project explorer, same as I do it from the command line as shown below:
C:\Documents and Settings\ccadm01>cleartool chproject -ncr -force QRF@\Informatica_PVOB
cleartool: Error: IDispatch error #19002
SQLNumResultCols: RETCODE=-1, State=S0002, Native Error=208
MicrosoftODBC SQL Server DriverSQL ServerInvalid object name 'master_global'.
MicrosoftODBC SQL Server DriverSQL ServerStatement(s) could not be prepared.
SQL statement="select db_locked from master_global"
cleartool: Error: Unable to find user database "USR02", please check the name.
cleartool: Error: IDispatch error #19002
SQLNumResultCols: RETCODE=-1, State=S0002, Native Error=208
MicrosoftODBC SQL Server DriverSQL ServerInvalid object name 'master_global'.
MicrosoftODBC SQL Server DriverSQL ServerStatement(s) could not be prepared.
SQL statement="select db_locked from master_global"
cleartool: Error: IDispatch error #19002
SQLNumResultCols: RETCODE=-1, State=S0002, Native Error=208
MicrosoftODBC SQL Server DriverSQL ServerInvalid object name 'master_global'.
MicrosoftODBC SQL Server DriverSQL ServerStatement(s) could not be prepared.
SQL statement="select db_locked from master_global"
cleartool: Error: Unable to locate database USR02 in any registered ClearQuest connections.
cleartool: Error: Unable to logon to ClearQuest user database "USR02".
cleartool: Error: Unable to turn off ClearQuest-enabling for project "QRF@\Informatica_PVOB".
Thanks
Jirong
  • bfiles
    bfiles
    1 Post

    Re: How to force CCCQ UCM disconnect?

    ‏2014-12-24T15:23:21Z  

    Hi Jirong, this is an old post, but thought I'd answer in case someone else runs across this issue.

    I use ucmutil to force removal of clearquest link from a UCM project when the user database no longer exists.

    ucmutil> cleanup_crm project:testintl_db2@/vobs/SCMP_proj
    You are about to unconditionally clean up ClearQuest integration on project "project:testintl_db2@/vobs/SCMP_proj". This is a non-reversible operation. Assuming ClearQuest database no longer exists.
    Do you want to continue? [no] yes
    Cleaned ClearQuest integration for testintl_db2.
    Cleaned ClearQuest integration for FEBIN00000034.
    Cleaned ClearQuest integration for FEBIN00000029.
    Cleaned ClearQuest integration for FEBIN00000033.
    Bruce Files - TransUnion LLC
  • RAHS
    RAHS
    65 Posts

    Re: How to force CCCQ UCM disconnect?

    ‏2014-12-29T09:05:31Z  
    • bfiles
    • ‏2014-12-24T15:23:21Z

    Hi Jirong, this is an old post, but thought I'd answer in case someone else runs across this issue.

    I use ucmutil to force removal of clearquest link from a UCM project when the user database no longer exists.

    ucmutil> cleanup_crm project:testintl_db2@/vobs/SCMP_proj
    You are about to unconditionally clean up ClearQuest integration on project "project:testintl_db2@/vobs/SCMP_proj". This is a non-reversible operation. Assuming ClearQuest database no longer exists.
    Do you want to continue? [no] yes
    Cleaned ClearQuest integration for testintl_db2.
    Cleaned ClearQuest integration for FEBIN00000034.
    Cleaned ClearQuest integration for FEBIN00000029.
    Cleaned ClearQuest integration for FEBIN00000033.
    Bruce Files - TransUnion LLC

    Hello Jirong,

    Below Technotes might help in your case:

    Disabling the ClearCase UCM and ClearQuest integration ---> http://www-01.ibm.com/support/docview.wss?uid=swg21150472

    How to re-establish Rational ClearCase UCM integration with Rational ClearQuest when the Rational ClearQuest database has been deleted
    ---> http://www-01.ibm.com/support/docview.wss?uid=swg21195482

    Thanks,
    Raghav