Rational ClearQuest adapter

Using the ClearQuest® adapter for IBM® Rational® Insight Data Services.
You get a licensing error
Make sure you can open the ClearQuest database on the Rational Insight Data Service server using the ClearQuest client. Use the License Key Administrator to apply the appropriate license. For information on how to apply ClearQuest licenses, see the ClearQuest documentation.
Databases are missing from the service
Make sure that the databases are registered and can be opened on the Data Services machine. Instructions for doing so are listed in the Installing and upgrading topics:

If you get errors opening the database, see the ClearQuest documentation.

If the databases are still not listed by the data service:
  1. Run regedit.exe and check for the following registry keys:
    • HKEY_LOCAL_MACHINE\SOFTWARE\Rational Software\ClearQuest\7.0.0\Core\Databases
    • HKEY_CURRENT_USER\Software\Rational Software\ClearQuest\7.0.0\Core\Databases
    Each database will be represented by child keys in the registry. If there are registry keys for databases in HKEY_CURRENT_USER that are not in HKEY_LOCAL_MACHINE, then the data service will not list those databases.
  2. Do either of the following:
    • Log on as an administrative user and use the CQ maintenance tool to register the missing databases.
    • Modify the system service named "IBM WebSphere® Application Server V6.1 – RationalInsight" to run as the same user that has the HKEY_CURRENT_USER registry keys.
User records are not returned from databases created using the ALM schema with a version of ClearQuest earlier than version 7.1
Modify the ALM schema so that any user databases created from this schema do not show this history field for the users. Run the following commands:
  1. select schema_num from master_schemas where name = 'ALM'
  2. select id from m_entitydef where name = 'users' and schemaid = [id from step 1]
  3. update m_fielddef set is_visible = 0 where entitydef_id = [id from step 2] and schema_id = [id from step 1] and name = 'history'
If you already created a user db from the original schema, update the user database by running the following commands:
  1. select id from entitydef where name = 'users'
  2. update fielddef set is_visible = 0 where entitydef_id = [id from step 1]
The operation could not be completed because of a licensing error.
Make sure you can open the database on the Data Services server using the ClearQuest client. Use the License Key Administrator to apply the appropriate license. For information on how to apply ClearQuest licenses, see the IBM Rational ClearQuest documentation.
Failure during ETL collections with SQL Edit privilege error
Ask the ClearQuest administrator for that database to add the SQL Edit privilege to the user being used for the ETL collections or to create another user with the privilege.

Feedback