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:
- 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.
- 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:
select schema_num from master_schemas where name = 'ALM'
select id from m_entitydef where name = 'users' and schemaid = [id from step 1]
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:
select id from entitydef where name = 'users'
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.