Fixes Defects: PM73122,PM73234,PM76261,PM80296,PM81596,PM85393,PM88185,PM90053,PM90807,PM91868,PM92098,PM92638,PM93138,PM93223,PM93775,PM93910 This patch contains the following software changes: 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. 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. 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. 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.