Fixes are available
Rational ClearQuest Fix Pack 14 (8.0.1.14) for 8.0.1
Rational ClearQuest Fix Pack 4 (9.0.0.4) for 9.0
Rational ClearQuest Fix Pack 15 (8.0.1.15) for 8.0.1
Rational ClearQuest Fix Pack 5 (9.0.0.5) for 9.0
Rational ClearQuest Fix Pack 16 (8.0.1.16) for 8.0.1
Rational ClearQuest Fix Pack 6 (9.0.0.6) for 9.0
Rational ClearQuest Fix Pack 17 (8.0.1.17) for 8.0.1
Rational ClearQuest Fix Pack 18 (8.0.1.18) for 8.0.1
Rational ClearQuest Fix Pack 19 (8.0.1.19) for 8.0.1
Rational ClearQuest Fix Pack 20 (8.0.1.20) for 8.0.1
Rational ClearQuest Fix Pack 21 (8.0.1.21) for 8.0.1
Rational ClearQuest Fix Pack 22 (8.0.1.22) for 8.0.1
Rational ClearQuest Fix Pack 23 (8.0.1.23) for 8.0.1
Rational ClearQuest Fix Pack 24 (8.0.1.24) for 8.0.1
Rational ClearQuest Fix Pack 25 (8.0.1.25) for 8.0.1
APAR status
Closed as program error.
Error description
After upgrading to CQ V.9.0.0.3 users cannot create/edit/save queries. Execute existing queries within the query folders is possible. Giving the user the SQL Editor right within user administration helps as workarounds. Error: CRVAP0065E Not all properties were successfully updated) Detail: - execute existing queries -> OK - open query in editor and run -> ERROR - open query in editor, change and save -> ERROR - create query, define, execute, save -> OK - create query, define, save, run (in query editor) -> ERROR - create query, define, save, close query editor, execute query in folder with double click -> OK Steps to reproduce: Create a sample non-admin user Follow the steps mentioned above to see the error If the user is given with "SQL Editor" privilege, no error is observed in doing any step mentioned above
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * ClearQuest Web * **************************************************************** * PROBLEM DESCRIPTION: * * Saving or running queries from the query editor in * * ClearQuest Web fails for users that do not have SQL Editor * * privilege. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
A fix is available in ClearQuest 8.0.1.14 and 9.0.0.4. Saving or running queries from the query editor in ClearQuest Web works appropriately for non SQL Editor users, provided the change does not explicitly set new SQL.
Temporary fix
Comments
APAR Information
APAR number
PI74220
Reported component name
CLEARQUEST WIN
Reported component ID
5724G3600
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-12-28
Closed date
2017-03-20
Last modified date
2017-03-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
CLEARQUEST WIN
Fixed component ID
5724G3600
Applicable component levels
Document Information
Modified date:
09 August 2024