Fixes Defects: PM28461,PM29685,PM16938,PM22111,PM25986,PM29600,PM23933,PM24638,PM11834,PM28958,PM30146,PM27142,PM21564,PM21162,PM23188,PM33552,PM22929,PM27914,PM26339,PK97318,PM12849,PM29205,PM28287,PK64886,PM27843,PM24971,PM33112,PM30919,PM26485,PM22774,PM26327,PM28047,PM28528,PM23574,PM20102,PM26665,PM23934,PM27326,PM27328,PM17571,PM26981,PM10323,PM25557,PM08655,PM12687,PM18438,PM22813,PM09711,PM32457,PM08654,PM05122,PM19849,PM31733,PM03816,PM18373,PM28649,PM05792,PM21289,PK65225,PM28185,RATLC01991662 This patch contains the following software changes: PM28461: Fixes a problem in the ClearQuest Web client where updating a record using a URL produces a CRVSV0078E error. PM29685: Resolves a formatting issue in the ClearQuest Web client where the end-range number in the pagination box of the result set overlaps the total count number when the browser is Internet Explorer 7. PM16938: Corrects a problem in the ClearQuest Web client where only the first column in a reference list displays the correct data while the remaining columns contain incorrect data. PM22111: Corrects a ClearQuest defect where the UNIX login time increases as the schema grows larger. PM25986: Fixes a defect in the ClearQuest Full Text Search where viewing records past 1000 produces a Status 500 Internal error that reads, "Cache size 1000 can not be smaller than page size 1001". PM29600: Addresses security issues in the ClearQuest Web client where malicious users can save HTML code through the dynamic filter in queries or they can exploit Javascript vulnerabilities. PM23933: Fixes a ClearQuest problem where the cqrpc process does not handle permission denied errors correctly and produces a Null Pointer exception. PM24638: Addresses a ClearQuest issue where the cqprc process was not exiting gracefully when it failed but was crashing in a manner that could result in data loss. PM11834: Addresses an issue in the ClearQuest Web client where attachments accumulate in a temporary folder indefinitely, which could eventually cause performance problems and system errors due to lack of space. PM28958: Fixes a ClearQuest defect where attempting to create a Public Folder without having privileges to do so produces a "Microsoft C++ exception" error. PM30146: Fixes a problem in ClearQuest Reports where reports based on dynamic queries show incorrect data if the filter value contains spaces. PM27142: Resolves an issue in the ClearQuest Web client where ClearQuest constructs an incorrect SQL query when running a CrystalReports report that contains a ClearQuest field name which differs from the corresponding database field name. PM21564: Added a note at the top of the “Setting available MBean attributes” help topic that customers should not change undocumented MBean atrributes unless instructed by IBM Support to do so. PM21162: Fixes a problem in the ClearQuest Eclipse client where the label for a radio button group box disappears in the ClearQuest Designer if the schema is closed without checking it in. PM23188: In the IBM Rational ClearQuest Web client help, updated the definition of a ‘restricted user group’ to make it clearer. PM33552: Fixes a defect in the ClearQuest Web client where running some reports that use ClearQuest field paths longer than 30 characters can produce a java.lang.NullPointerException error. PM22929: Fixes a ClearQuest problem where running the "cqtool new_query –id" command does not display the record ID. PM27914: Corrects a ClearQuest import problem where the import of records starting with an empty field fails or is corrupted if the import file contains more than one record. PM26339: Addresses a ClearQuest issue where ClearQuest did not check the user’s login ID before passing it to LDAP for authentication. PK97318: Fixes a ClearQuest problem where the ClearQuest "FireNamedHook" API produces a "Caught An Unhandled Exception At The OLE Call Boundary" error when the HOOKS diagnostic trace flag is enabled on Windows XP. PM12849: Fixes a memory leak in the Rational Change Management Server, when used with ClearQuest, which is occurring in CqRecordAutoTransitionCallbackAdapter. PM29205: Addresses an issue in the ClearQuest Web client where the "content-type" listed in the response header of some HTTP responses is "text/html" instead of "application/json". PM28287: Corrects a problem in the ClearCase Remote Client where keyboard shortcuts are not available in the ClearCase Details view. PK64886: Addresses an issue with the ClearCase integration with Microsoft Visual Studio .NET 2008 where launching ClearCase Front Desk causes Visual Studio .NET to crash. PM27843: Corrects a problem in the ClearQuest Web client where editing a title name in the query presentation of a personal query truncates the result set field. PM24971: Fixes a problem in the ClearQuest Web client where a URL that contains encoded or unencoded single quotation marks displays correctly but the actual hyperlink is truncated after the first single quotation mark. PM33112: Fixes a ClearQuest problem where the Full Text Search "cqtsdbcrawler" is not indexing modifications to records, which produces incorrect results in Full Text Searches PM30919: Fixes a ClearQuest Web client defect where a login call to get accessible databases fails with an error message that reads: "CRVSV0078E Error from RPC server: CRVSV0814E Internal error: cqrpc_get_accessible_databases: Unexpected Exception." PM26485: Corrects a problem where ClearQuest is failing to properly import stated records and references. PM22774: Fixes a problem in the Rational Change Management Server, when used with ClearQuest Web, where the server is hanging with a high number of threads due to a lock issue in the stprpc_xdr code. PM26327: Addresses an issue in the ClearQuest Web client where users are able to view various record types through REST URI even though security context is enabled. PM28047: Addresses a ClearQuest Windows client issue when used with an Oracle database where the List View users list is not being alphabetically sorted. PM28528: Fixes a ClearQuest Web client problem when using the ALM schema where closing a parent record that was opened using the API and then saving or canceling a child record produces an error. PM23574: Resolves a problem in the ClearQuest Web client where a query that contains a date value which is set for a dynamic filter executes correctly the first time it is run but, in subsequent runs, the query executes as if there was no filter. PM20102: Fixes a ClearQuest EmailPlus problem where line breaks are dropped from a multiline string field when the field is part of an email generated by EmailPlus. PM26665: Corrects a ClearQuest Web client problem where closing a window that is loading a ClearQuest record with a reference list in it can produce a "Server Error" in the browser. PM23934: Addresses a ClearQuest Web client issue where a fatal error in the cqrpc.exe process produces a dialog box instead of a silent exit. PM27326: Corrects a problem in the ClearQuest Web client where the result set column returned by a query is truncated by the column width if the field value has no spaces. PM27328: Fixes a ClearQuest Web client defect where changing the title of a column in the query presentation makes the column narrower because the column is being displayed according to the field instead of the title. PM17571: In the ClearQuest Web Administrator help topic "Generating an encrypted password for the Rational ClearQuest administrative account", corrected the encrypted admin password in the code example extracted from the Deploy_RCQR_eWAS.py file. PM26981: Updated the ClearQuest API reference documentation for FieldInfo Object GetValueAsList function to correct error in Perl code sample. PM10323: Fixes a security problem in the ClearQuest Web client where the WebSphere Application Server administrator credentials in the CqServerConn.properties file are not being encrypted. PM25557: Resolves a ClearCase installation issue on Windows 2008 R2 platforms where the update.bat file is missing from the installation area which prevents further upgrades of the installation. PM08655: Fixes a problem in the ClearQuest Web client where creating multiple Add buttons for one reference list (Parent/Child control) and associating a Pre-action hook to one of the buttons and a Post-action hook to the other button produces a situation where clicking one of the buttons runs the correct hook the first time but subsequently clicking the other button fails to trigger the associated hook. PM12687: Addresses a ClearQuest Web client issue where attempting to modify unsupported fields when using the Multi-Record Update feature produces a confusing error message. PM18438: Addresses a ClearQuest issue where reports based on SQL edited queries that were created in earlier versions of ClearQuest cannot run when using a reporting driver from a later version of ClearQuest. PM22813: Fixes a problem in the ClearQuest Web client where removing an attachment which contains a name that is more than 50 characters in length produces a "resource not found" error message. PM09711: Resolves a ClearQuest installation issue where the IBM Installation Manager installs the User Administration tool along with native client. PM32457: Addresses a ClearQuest problem where back-reference fields are not modifiable. PM08654: Corrects a behavior in the ClearQuest Web client where a user cannot remove a second child record when the Delete button has an associated "Prehook". PM05122: Addresses a ClearQuest installation issue where the configuration of the Crystal Reports CQJRC is lost during an upgrade procedure. PM19849: Corrects a problem in the ClearQuest Web client where the comparison of date fields that are 100 years apart is inaccurate. PM31733: Resolves a problem in the ClearQuest Web client where using the same name for the schema repository and the user database produces an error message in the browser. PM03816: Resolves a ClearQuest problem where the Dynamic List [Limit to List] option in the Choice List Hook does not transfer when using exportintegration and exportschema. PM18373: Corrects a ClearQuest issue in full text search where an implementation that contains several ClearQuest record-types and performs frequent changes to the ClearQuest database experiences heavy resource consumption. PM28649: Addresses a ClearQuest issue when running with Microsoft SQL Server where ClearQuest is not preventing the execution of "UPDATE" and "DELETE" statements. PM05792: Fixes a problem in the ClearQuest for Windows client where users were able to create and save queries containing incorrect static filter values for DATE_TIME fields. PM21289: Addresses performance issues in the ClearQuest Web client where loading the choice list for a dynamic filter is taking longer than 6 seconds when the browser is Internet Explorer 6 or 7. PK65225: Fixes a problem in the ClearQuest Eclipse client on Linux platforms where modifying a UCM activity and clicking Apply resets the values of the fields that have changed to their original settings. PM28185: Resolves a problem in the ClearQuest Web client where the date format in a query changes from long to short when the user returns to the query through its tab and then changes filters. RATLC01991662: Adds a new ClearQuest schema property to enable the Oracle hint NO_UNNEST. The new schema property is named ENABLE_ORACLE_HINT_NO_UNNEST.