Fixes Defects: PM73122,PM73234,PM76261,PM80296,PM81596,PM85393,PM86937,PM88185,PM90053,PM90807,PM91868,PM92098,PM92638,PM93138,PM93223,PM93910,PM94720,PM95460 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. PM86937: Problem: Under certain circumstances when adding attachments the first time in the ClearQuest Eclipse client, the attachment will not be added to the record and any other modifications to the record will be lost. Fix: The attachment will be added to the ClearQuest Eclipse record and other modifications will not lost, even after the first time. 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. 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. PM94720: Problem: Certain characters in the 932 codepage could not be displayed correctly in the internal recordset used to run ClearQuest Crystal reports. This resulted in an inability to run reports with those characters and/or failure to display that data. Fix: ClearQuest Crystal reports now display all fields with the problematic characters. A newer codepage containing these SJIS characters is now used by our database ODBC drivers. This codepage contains the characters that were problematic before. PM95460: Problem: Symantec PGP Desktop e-mail encryption service causes problems with the Atria Location Broker Demon(ALBD) service startup during install or upgrade operations. The ALBD service is prevented from starting, locking the operation. Fix: The IBM Rational ClearCase installer has been modified to create an interface for selectively disabling the service's final startup sequence, thus preventing PGP Desktop and other third party programs from interfering with the startup operation and causing irrecoverable lock situations.