This server patch contains fixes for the following defects:

[Backport 5.0.2] Dashboard report is showing the last time the Java ETLs were run not when the last DCC ETLs were run.

[Backport 5.0.2] CQPAR00108139: Job status shows failure for all resource groups even though only one of them actually failed.

[Backport 5.0.2] [DCC] Records marked as softdeleted in TIMESHEET could be active again - DCC.

[Backport 5.0.2] DCC - Timesheet ETL issues.

[Backport 5.0.2] DCC open file descriptor Leaks behavior.

[Backport 5.0.2] DCC: ODS Collector jobs are in waiting state forever if there was a temporary DB connection problem.

[Backport 5.0.2] CQPAR00140514: DCC Quality Management job failing.

[Backport 5.0.2] CQPAR00143712: DCC handling of Oracle BINARY_DOUBE is wrong.

[Backport 5.0.2] DCC Web UI corrupts the delta time when web browser language is e.g., french.

[Backport 5.0.2] [363201] DCC should log SQLException when failing to prepare statement.

[Backport 5.0.2] 375622: CQPAR00163680: Delete Fact Table Data DCC job took long time but could not finish.

[Backport 5.0.2] 360532: Ghost links appearing in traceability report.

[Backport 5.0.2] JRS data source issues when using LDAP and custom DW extension names that end with “.‿.

[Backport 5.0.2] CQPAR00118878: Custom Enumerations in certain case display as literal ID instead of name.

[Backport 5.0.2] CQPAR00118829: JRS Not able to Handle RQM Categories like Attributes.

[Backport 5.0.2] Missing custom link types for requirements.

[Backport 5.0.2] Issues with RM custom attributes.

[Backport 5.0.2] Able to download query spreadsheet non-authenticated/authorized, potential for malicious use and phishing attack.

[Backport 5.0.2] JRS using the data warehouse is showing no results in non CM-enabled project traceability reports from requirements.

[Backport 5.0.2] DW data source SQL queries do not handle a schema prefix.

[Backport 5.0.2] Report Builder lists Soft Deleted project areas when selecting Scope.

[Backport 5.0.2] JRS Failing to Input Validate and output encode data, leading to potential XSS (Cross Site Scripting) Vulnerability.

[Backport 5.0.2] Project List Excludes Project Areas that do not have team areas.

[Backport 5.0.2] Metamodel initialization should happen on server startup.

[Backport 5.0.2] CQPAR00143896: Statement that checks if connection is valid can cause problems.

[Backport 5.0.2] CQPAR00139305: JRS - Set Conditions - No values to select for Filed Against Attribute.

[Backport 5.0.2] Version check fails for Oracle 12c data warehouse.

[Backport 5.0.2] JRS server rename fails with multiple mapping events or if server is restarted during rename process.

[Backport 5.0.2] IE9 Report name, title and visibility all disabled.

[Backport 5.0.2] Help > Help contents link in the Report Builder UI should point to the information for the respective version.

[Backport 5.0.2] The unparser should handle the INTERSECT clause.

Workaround: Action is required for a remote floating license server after an upgrade to version 5.0.2.

NPE in ManagedFloatingLicenseClient$LeaseCache.getCheckoutOperations.

Backport defect 342550 to 5.0.2 Maintenance Staging to correct the JVM threads names once they are reused from the Thread pool.

Adding new roles in Web UI makes it VERY easy to seriously corrupt roles database - Chrome only.

Diagnostics Oracle JDBC Driver version check does not accept 12.1.0.2.

Error during creation of Life Cycle Project in CLM 5.0.2RC1 with JazzProjectAdmins permission.

Investigate implications of two components having the same ID.

Issue #1 Maintenance 5.0.2 - PMC 341917.

Issue #3 Maintenance 5.0.2 - PMC 341970.

Don't cause an SQLException to determine if a MARKER exists (5.0.2iFix007).

RTC ETL's should be able to handle date values where the year is not 4 digits long.

DelegatedAuthHandler and LoginPageStatusHandler ignores com.ibm.team.jfs.app.oauth.OAuthHelper.disableSecureCookies property.

The iteration type should not be restored if it's not archived.

The LPA templates can not be retrieved after a migration from 5.0.1 (with a server rename) to 5.0.2.

5.x Indexer for Excel can run out of memory.

All Project Areas are deleted during upgrade to RDNG 5.0.2 if finalizeApplicationMigration is rerun following a failure.

Adopt Report caching slow on Oracle (344963).

Project Dashboard shows incorrect content after loading a WI or Query Result and then performing a browser refresh in IE.

Full Text Search stemming doesn't work correctly in non-English European languages (Backport 345158 to 5.0.2 ).

Online Migration can skip states in the event of a retry-able DB exception (fix in 5.0.2).

Creating iterations can break if translation is wrong (Fix in 5.0.2).

Handle the query cancellation in query iterator and QueryFilter (resource context filter).

VVC cache storage to concept misses causes bad performance.

Query Results from performQuery can be unexpectedly cached (Backport 348143 to 502ifix ).

Online migration can skip states on subsequent runs.

Deleting resource in no-history storage area should not update history index to 502 (Backport 351405 to 502).

Lucene crashes because of Mmap issue (Backport to 502).

TeamAreaRole ETL flips two columns (354920).

[RTC 5.0.2] [wi 356278] - ETL should ignore Item not found exceptions.

RRC Project Baselines are inaccessible after migration from 4.0.x in a server renamed environment.

Text query service doesn't work after server rename.

IACS should support Functional outbound to local targets - backport (334135) to 502.

Production Data Warehouse shows duplicate work item records [Defect 356581].

Timelines widget does not display team area timeline assignments.

Login to fronting apps (other than RTC and RQM) is broken.

Error when opening RM Admin Active Services ( copied from rm wi 92500 ).

Auth challenge issued by DelegatedAuthHandler not detected by IACS.

As a CLM deployment engineer, i need to be able to create friend relationship between Apps automatically during install or upgrades 6.0 [364095] to 5.0.2.

Backport JFS bulk delete can cause a OOM (371253). to 502.

DM needs to be able to change dependencies of immutable configurations managed by VVCConfigurationCacheService [backport to 5.0.2].

SimpleDateFormat is not thread safe and cannot be shared among threads (Extracting Work Items via reportable API can return wrong modification dates for history entries).

[wi 361771] Ability to filter certain WI types out of DCC ETL.

ItemStateQueue must account for differences in collation order of non alphanumeric characters.

Online Migration may repeat states if DB collate order is not IDENTITY.

[RTC 5.0.2iFix009] WI: 360995: Ghost links appearing in traceability report.

(5.0.2) No Secure Token Error for JRS Widgets using Internet Explorer 11.

Backport defect 369390 TransactionalStateCache stores stale state data 502 Maintenance.

Regression from Defect 46203: No scrollbar on plan sidebar when needed.

Load for project area is not correct when there are subteams.

NullPointerException error exporting a plan.

repotools -renindex gives an error: SEVERE: Failed to register SecureProtocolSocketFactory.

RTC Planned-For drop down shows limited values.

Build subset not building all dependent items as expected.

Missing color expressions in 5.0.1. and newer (Server).

'undefined' state shown in dynamic query selection from Work Item widget.

Adding literal to enumeration shows error.

Removing the summary from the header section causes formatting problems - Advanced Fix.

Removing the summary from the header section causes formatting problems.

Back-port defect 345830 to 5.0.2 iFix006 - userId in Git pre-receive hook is too brittle.

Back-port defect 347359 to 5.0.2 iFix005 - AbstractScmTypeHandler should implement INewTypeHandler.onTransactionFailed.

Backporting defect 353382.

SetBuildMapComponentUUIDTask - only the first 512 build maps are migrated.

Kanban/Taskboard group by owner is slow with many users.

Poor plan loading performance when there is a tree display with many layers.

Dependency build baseline creation should fail the build if the stream resource does not exist.

Dependency build failed when a stream is locked by a scan that was interrupted.

Clicking on "Select More Items" does not open the window "Access Context Selection" in the web client.

Long option labels are not shown in QueryableComboView.

parent links label when generated from work item template does not reflect latest summary when printed from the WebUI.

[5.0.2 iFix 002] Improve user experience when dealing with large (1000+ 2048+) numbers of components.

[Oracle] ROWNUM limit is applied before ORDER BY.

Visual Studio: ORA-01795: maximum number of expressions.

Eclipse and WebUI do not generate the same descriptor for parameterized queries.

Records marked as softdeleted in TIMESHEET could be active again - Java ETL.

ORA-01795 maximum number of expressions in a list is 1000 during CCM rebuildTextIndices.

WebUI - infinite calls to PlanRestService#postGetItems2() when loading a plan that has restricted visibility children.

DependencyQueryService should run against the file without dependencies once.

[RTC 5.0.2] [wi 339730] - MS932 encoded file is garbled in IE 10.

custom enum-type attribute is unexpectedly displayed in the history without "Synchronize Attributes" operation.

Removed team member is still visible in the Work Breakdown view on WebUI.

Dependency build automatically unlock the stream after 10 minutes.

Source Code Data scanning service not picking up file name changes.

Back-port defect 327641 to 5.0.2 iFix003 - Visual Studio: Cannot resolve a conflict because of this error message "Sync item with id '...' is not a conflict".

Unexpected tab "Ups..." after creating new plan.

Work items incorrectly linked to build when using subset builds.

Clicking "Owned by" header in the plan view sorts the owners based on UUID, not the name.

WorkItemPublisher does not check for array size in tagWorkItems().

Correct NPE when non-BF engine is defined for a BF definition for 5.0.2.

Browser gets locked up in taskboard plan view with many owners.

Backport blocking synchronization requests from 3rd party tool with an external system (RTC) to 5.0.2.

class ISparqlQueryService failed to load for SystemDefinitionService.

Fix defect 342786 for 5.0.2 iFix stream.

Back-port defect 343463 to 5.0.2 iFix003 - RTC warehouse job SCM fails due to the error: [SQL0199] Keyword CONTENT not expected.

Slow performance accepting change sets on MS SQL Server.

Custom enum-type attribute is unexpectedly displayed in the work item editor without "Synchronize Attributes" operation.

Plans with Circular Tracks References do Not Open.

Adopt Only enumeration display name or value can be returned by Reportable REST API and not both (344297).

Getting errors when executing concurrent builds during accept changes.

Work Item Promotion creates a build property that can grow large enough to terminate the BFA process.

Backport defect 340225 to 5.0.2 iFix004 - Unable To View .h and .c Files in Web Client.

Drag &apm; Drop Edit of "Work Item" Editor Presentation Layout is not working in 5.0.2.

Investigate using transactional caches during history for versionable.

[Defect 344131] Investigate using transactional caches during history for versionable.

Promotion fails when there are more than 41 work-items.

buildReport.xml not available in post-build script.

Query Resolution column sometimes shows blank for Unassigned.

Can't query buildPath from build maps anymore.

When a gap is detected during promotion preview the error message displays the wrong change set.

Cross repository tracks links with Accumulated Time column causes refresh loop and empty summary.

[RTC 5.0.2] [WI 324870] Tool-tip for long values in the selection pulldowns disappear when search filter is applied.

Exclude plan items related filter does not work in Taskboard view.

Checkbox respond is slow when configuring Taskboard/Kanban States in Column Display tab.

User work environment hangs on "Loading" and never load any timeline/project areas.

Inconsistent case in translation of "Unassigned" fails to load work items ~ "Não Designado" vs. "Não designado".

Back-port defect 346552 to 5.0.2 iFix005 - RecentChangeSetsAffectingIterator pulls too much from the inner nodes affecting iterator.

Creating a new linked WI in another Project Area is not working anymore. It will always create a new WI in the SAME Project Area/.

Quick Planner default type issue.

Back-port defect 350470 to 5.0.2 iFix005 AcceptImpl.detectGaps should exhaust current page of iterator results before requerying.

Back-port defect 350386 to 5.0.2 iFix006 - Conflict move fails if changes include a folder swap and related file moves.

Backport of cross component move links from change sets that were migrated from 4.x are not resolved before distributing them to other servers.

Collecting buildable files takes a long time for dependency build after all the files changed.

Backport for error while saving the Build Forge BOM log on RTC.

The Build Forge step logs are published out of order in RTC when using inlines.

Tracks links missing in Plan View.

After 5.0.2 update from 4.x, Plans fail to load due to a NullPointerException.

Improve discard support in the preprocessor.

Adopt 355424: Timesheet reports are showing blank data.

Opening item from Recent Work Items list while a plan is open causes web browser to hang for over a minute.

Query feeds "My Teams..." and "My Work Item Changes" broken out-of-the-box.

Unable to import Unassigned owner from csv file to update the owner.

Quick Planner for Rational Team Concert.

Back-port defect 335485 to 5.0.2 iFix007 - Copy paste link from the "Modified" text next to the file path in the git commit details page in the web browser gives an error message.

configDetermineAncestorsInHistory should batch files in calls to getChangeSetsAffecting.

[RTC 5.0.2][WI 335146] Resolved work items no longer marked with strike through font on work item link tab.

Backport fix for the 2048 item limitation for EE logic.

Each build request initiated from RTC creates additional buildResultUUID parameter in the corresponding Jenkins workflow job for 5.0.2.

[RTC 5.0.2][372897] Compile problems in TransactionalCacheWrapper.java in rtc.601 RTC-I20151020-1437.

correctly handle duplicate buildPath entries for buildmaps to 502.

Service for script based value set provider may be running for long if http connector doesn't return response.

[RTC 5.0.2 iFix] [WI 352326] Fix for Error running Lifecycle Queries.

ConcurrentModificationException JFS exception thrown during concurrent builds.

Source code data scanning not handling component replacement correctly.

Backport of Defect 355395, fix for Defect 220917 causes behavior change and confusion.

Auto-resolve of conflict after reorder due to baseline accept picks wrong state for 5.0.2.

Unresolvable conflict can result from cross component move and subsequent pre-move changes with duplicate merges for 5.0.2.

Group should not show Items if all of them are outplaced.

[RTC 5.0.2][Defect 357856] Versionable change state not recalculated of folder add.

Select query from widget hangs on "Loading".

Attribute customization script calculation fails in Web UI.

Back-port defect 361277 to 5.0.2 iFix007 - Git Preview screen shows garbled characters for japanese labels.

[wi 361771] Ability to filter certain WI types out of DCC ETL.

Backport for force full analysis should cause dependency set comparison.

[5.0.2] Taskboard does not sort stories by anything other than Rank.

Modified By and Modified Date are set to Unassigned and None when a Custom Attribute is added to a Task.

[RTC 5.0.2] Unable to save links on draft work items.

Backport to RTC 5.0.2 iFix009 [Defect 363063] Unable to accept after merge - "not a file" error.

[RTC 5.0.2][WI 364981] ccm.log is flooded by CRJAZ0368E A database query could not run on the server.

[RTC 5.0.2iFix009] [WI 365108] Advanced Release Burndown widget counts workitems of excluded types.

[Defect WI 365747] Workspace load with many components takes more time than loading one component having the same total size of files.

StreamResource should be created, even if there's no file to scan in stream.

Backport to RTC 5.0.2 iFix009  - [366521] Migration fails if an HistoricBasis item gets modified after online migration has started.

[RTC 5.0.2iFix009] WI: 360995: Ghost links appearing in traceability report.

[RTC 5.0.2 iFix9][359058] Select query from widget hangs on "Loading" with NPE.

[RTC502][WI 366360]Eclipse hangs at Resolving unresolved links during CSV WI Import with Parent Links.

[RTC 5.0.2 ifix 12][wi 367748] Cannot access copied work item with custom category attribute after upgrade to 5.0.2.

EE Garbage collection should delete more BuildBaselines to 502.

DependencyQueryService no longer honors the Index Update Wait Time advanced property for 5.0.2.

[RTC 5.0.2] [wi 368139] Plan Statistics widget does not show all valid categories.

[RTC 5.0.2][WI 373469] RTC editable fields get reset when refreshed in Web UI.

Backport fix for more than 1000 build definitions with JBE for 5.0.2.

The 'com.ibm.team.enterprise.jfs.commons.query.JfsQuery' class constructor has changed between the 6.00 and the 6.01 version to 502.

Replace ProcessAreaDTO in GitRepositoryDescriptorDTO with a light-weight alternative.

[RTC 5.0.2 iFix] [WI 374493] Backport request for Defect 374493/PI51986 to iFix - Work Item getEditableProperties allValues for owner attribute load time grows proportionate to team size.

PLI source file leads to incorrect dependency path.

Customers migrating from RTC 4.x to RTC 6.x need to be able to skip redundant EE migration steps.

This client update site contains fixes for the following defects: