Fixes Defects:

PM48834,PM50106,PM73122,PM73234,PM76261,PM80296,PM81596,PM85393,PM86562,PM88185,PM90053,PM90807,PM91868,PM92098,PM92131,PM92638,PM92657,PM93138,PM93223,PM93775,PM93910,PM94769,PM94772,PM94775,PM94776,PM94777,PM94778,PM94780



This patch contains the following software changes:


PM48834:

   Problem: Problems can occur when attempting to use ClearQuest Web server as an OSLC provider in a load-balanced deployment. 

   Fix: The ClearQuest Web server is updated to fully support OSLC integrations in a load-balanced deployment.  See the ClearQuest Information Center for information about configuring load-balanced ClearQuest Web systems to support OSLC integrations.


PM50106:

   Problem: If a ClearQuest child record has a reference field to a stateful parent record, queries run against the child record type will return the incorrect result set if the parent reference.state (dot State) is set as a displayed field.  Child records whose parent reference field are null are not displayed in the query result set.

   Fix: ClearQuest child records that do not have parent reference field now display in the result set.  In order to receive this fix, users must upgrade their ClearQuest Databases to Feature Level 8.


PM73122:

   Problem: In ClearQuest Eclipse, importing values separated by a single LF (Line Feed) character into a multi-line string field results in a CR (Carriage Return) being added before the LF in all values except for the last one.  This is typically the case when a multi-line string field which has a constant-list for its Choice List gets exported and imported again.

   Fix: The ClearQuest Eclipse import no longer results in a CR (Carriage Return) being added before the  LF (Line Feed) in all values except for the last one.


PM73234:

   Problem: Expanding a ClearQuest Web workspace folder can take a considerable amount of time, depending on the number of items within the folder.  The performance tends to be slower when using ClearQuest Web on unix.

   Fix: A ClearQuest Web enhancement between the cqrpc and CMServer layers has been added which improves workspace folder performance.


PM76261:

   Problem: The time zone on ClearQuest e-mail notifications (as displayed in the user's inbox) is sometimes different than the actual time zone recorded in the ClearQuest record.  NOTE - This problem appears when viewing e-mail notifications on some e-mail clients like Microsoft Outlook.  This problem occurs when the email notification is generated from any ClearQuest client (Web, Eclipse or native). 

   Fix: ClearQuest e-mail notifications now display the correct times in a user's inbox.  The ICU libraries were upgraded in ClearQuest 8.X from version 3.8 to 4.8.  The default datetime offset of the new libraries was changed, and ClearQuest was not properly parsing and reformatting it to be RFC #822 compliant.  This has been fixed so the time zone information now displays correct for email generated by all ClearQuest clients


PM80296:

   Problem: When using the Crystal Reports isNull function to test for an empty ClearQuest string field, the result is inconsistent between the desktop clients and the Report Server for Crystal Reports.  When running a report using the Report Server for Crystal Reports, the isNull function returns false for cases where a value of true is expected.

   Fix: The ClearQuest Reporting Driver was updated to treat empty string values as nulls.


PM81596:

   Problem: It takes longer to log out of ClearQuest Web as a restricted user than it does as a normal user.

   Fix: Logging out of ClearQuest Web now takes the same amount of time for both a restricted and a normal user.


PM85393:

   Problem: In the ClearQuest Windows client, queries that use an ORDER BY clause (ASC or DESC) to add items to a reference list, result in an error message that blocks the user from seeing the query result set. The error message says "A column has been specified more than once in the order by list. Columns in the order by list must be unique."

   Fix: ClearQuest Windows client users are able to use a query with ORDER BY clause (ASC or DESC) to add items to a reference list.  This is now consistent with the ClearQuest Web and Eclipse clients.


PM86562:

   Problem: ClearQuest Web on Internet Explorer may take a long time to display a workspace folder if there are many folders and queries in it.

   Fix: Opening ClearQuest Web workspace folders now takes about as long using Internet Explorer as FireFox.


PM88185:

   Problem: A ClearQuest Web security problem was found.

   Fix: A ClearQuest Web security problem was fixed.


PM90053:

   Problem: ClearQuest Web security problem was found.

   Fix: ClearQuest Web security problem was fixed.


PM90807:

   Problem: When using the count aggregate function to display fields in a query, the records are not grouped in the result set in the ClearQuest Web client.

   Fix: ClearQuest Web records can be now be grouped in a result set by using the count aggregate function.


PM91868:

   Problem: ClearQuest Full Text Search terms with mixed letters and numbers, such as "00960964.01.t01", will not get a hit if searching for "00960964.01.t".  This is caused by the current Solr 3.6.1 schema.xml analyzer setting.

   Fix: The Solr 3.6.1 schema.xml was fixed so terms with mixed numbers and letters, such as "00960964.01.t01", will now get a hit when doing a ClearQuest Full Text Search on "00960964.01.t01", "00960964.01.t" or "00960964".


PM92098:

   Problem: Exporting records in the ClearQuest Eclipse client exports into a format which cannot be imported into Microsoft Excel when records contain data with carriage returns.

   Fix: Exported records that contain carriage returns can now be viewed correctly in Microsoft Excel.  A new ClearQuest Eclipse export format "ClearQuest import format (Strip CR LF)" has been added.  The new format quotes fields and strips Carriage returns/line feeds, replacing the line feed with a single space.


PM92131:

   Problem: Executing queries with ClearQuest OSLC using the IN operator for a REFERENCE or REFERENCE_LIST field fail with a response HTTP Status 400  "com.ibm.rational.cm.rest.query.InvalidQuerySyntax" error.  
For example, a query for Defect records that have referenced customer records using the IN operator on the customer name:
http://<SERVER>/cqweb/oslc/repo/8.0.0/db/SAMPL/simpleQuery/16777224?oslc.where=cq:customer{cq:Name in ["Ethan Hunt","Jane Smith"]}

   Fix: ClearQuest OSLC queries now work when using the IN operator for a REFERENCE or REFERENCE_LIST field.


PM92638:

   Problem: The ClearQuest global script utility package (GSU_CQXE) is throwing different errors when calling "GSU_CQXE_OpenForm" and "GSU_CQXE_OpenURL" on the ClearQuest Web Client.  Calling GSU_CQXE_OpenForm results in a "NullPointerException" and calling GSU_CQXE_OpenURL results in a "Fire script alias failed" error.   This is regression that was introduced in ClearQuest Web 8.0.0.7 and 8.0.1.

   Fix: The API calls GSU_CQXE_OpenForm and GSU_CQXE_OpenURL now work correctly in ClearQuest Web.


PM92657:

   Problem: In the ClearQuest 8.0.1 Information Center, the information about configuring the IBM DB2 database is missing.

   Fix: The information about configuring the IBM DB2 database has been restored to the ClearQuest 8.0.1 Information Center at http://pic.dhe.ibm.com/infocenter/cqhelp/v8m0r1/topic/com.ibm.rational.clearquest.install_upgrade.doc/topics/c_config_db2.htm.


PM93138:

   Problem: Under certain conditions, the ClearQuest Reporting Data Pull CM adapter driver may fail with a "java.lang.NumberFormatException" error.

   Fix: The ClearQuest Reporting Data Pull CM adapter driver has been fixed to no longer throw the error.


PM93223:

   Problem: ClearQuest Web users encounter errors when using the rest API to pre-fill forms with lengthy field values.  This can sometimes cause the ClearQuest / DOORs integration to freeze while selecting multiple requirements to submit an implementation request.

   Fix: ClearQuest Web users are now able to pre-fill forms with lengthy field values using the rest API.


PM93775:

   Problem: The ClearQuest behavior flag LICENSE_HOST_OVERRIDE can be used to explicitly set a hostname for license checkouts.  It does not work on some Unix platforms including Linux.

   Fix: The ClearQuest behavior flag LICENSE_HOST_OVERRIDE was made operational on Unix.


PM93910:

   Problem: ClearQuest Web Button hooks do not always fire on the first click when using Internet Explorer. The user sometimes needs to click on the button twice for the hook to fire. The problem does not happen when using Fire Fox.

   Fix: ClearQuest Web Button hooks now fire on the first click for both Internet Explorer and Fire Fox.


PM94769:

   Problem: The JAWS (Job Access With Speech) screen reader cannot locate and read the X button to close the ClearQuest Web welcome screen

   Fix: A new keyboard access key was added that allows ClearQuest Web users to quickly navigate to the currently selected tab in the result set.  A user can quickly navigate to these tabs using either of the following access keys: ALT+SHIFT+T (FireFox) or ALT+T (Internet Explorer).  That will cause the focus to go to the currently selected tab.  A user can then switch between tabs using the [LEFT] & [RIGHT] arrows.  Once the user has navigated to the tab they would like to close, the user can simply press the DELETE button and it will close the tab.


PM94772:

   Problem: The JAWS (Job Access With Speech) screen reader is unable to navigate to the ClearQuest Web personal queries and public queries folders.

   Fix: A keyboard access key is now available that maps to the 'Personal Queries' folder in the 'Navigator' view.  A keyboard user can navigate to the 'Personal Queries' folder in FireFox by pressing ALT+SHIFT+N, or ALT+N on Microsoft Internet Explorer.  This will bring focus to the 'Personal Queries' folder.


PM94775:

   Problem: The JAWS (Job Access With Speech) screen reader is unable to allow ClearQuest Web users to run queries without help from a sighted person.

   Fix: A keyboard access key is now available that maps to the 'Personal Queries' folder in the 'Navigator' view.  A keyboard user can navigate to the 'Personal Queries' folder in FireFox by pressing ALT+SHIFT+N, or ALT+N in Microsoft Internet Explorer.  This will bring focus to the 'Personal Queries' folder.   As a user navigates up and down the tree, using the arrow keys, JAWS will read the corresponding tree item.  Once the user has navigated to the desired query, chart, or report, the user can press ENTER to run the query, chart, or report.


PM94776:

   Problem: The JAWS (Job Access With Speech) screen reader is unable to navigate between the left and right ClearQuest Web pane.

   Fix: The following access keys were added to improve the workspace navigation in the ClearQuest Web client:
 
 Workspace Navigation Keys (FireFox)
 ALT+SHIFT+L  -> Performs Logout/Login
 ALT+SHIFT+T  -> Moves focus to the selected tab in the top right section of CQ Web (i.e where the 'Welcome' & result set tabs reside)
 ALT+SHIFT+N  -> Expands/Collapses the 'Personal Queries' folder in the 'Navigator' view
 ALT+SHIFT+F  -> Focus goes to the 'Search' text field
 
 Workspace Navigation Keys (Internet Explorer)
 ALT+L -> Focus goes to the Logout/Login button
 ALT+T -> Focus goes to the selected tab in the top right section of CQ Web (i.e where the 'Welcome' & result set tabs reside)
 ALT+N -> Focus goes to the 'Personal Queries' folder in Navigator view
 ALT+F -> Focus goes to the 'Search' text field


PM94777:

   Problem: The JAWS (Job Access With Speech) screen reader is unable to access the right mouse click to copy workspace items in ClearQuest Web.

   Fix: The context menu will now appear in the workspace 'Navigator', 'Favorites', & 'Recent Items' views when the context menu is invoked through the keyboard using SHIFT+F10.  From within the context menu, all actions that would normally appear in the context menu (i.e Copy, Rename, etc.) will be available for the user.


PM94778:

   Problem: The JAWS (Job Access With Speech) screen reader is unable to paste to the personal and public ClearQuest Web queries folders

   Fix: The context menu will now appear in the 'Navigator', 'Favorites', & 'Recent Items' views when the context menu is invoked through the keyboard using SHIFT+F10.  From within the context menu, all actions that would normally appear in the context menu (i.e Copy, Paste, Rename, etc.) will be available to the user.


PM94780:

   Problem: The JAWS (Job Access With Speech) screen reader is unable to rename a ClearQuest Web query without sighted assistance.

   Fix: The context menu will now appear in the ClearQuest Web 'Navigator', 'Favorites', & 'Recent Items' views when the context menu is invoked through the keyboard using SHIFT+F10.  From within the context menu, all actions that would normally appear in the context menu (i.e Copy, Paste, Rename, etc.) will be available for use by the user.