Reports are slow and do not complete when there are many rows in the Data Warehouse (DWH) security tables.
Steps to Reproduce:
Expected Result: Report Filters load and do not take several minutes to load. Reports complete
Actual Result: Report Filters take several minutes to load or never load. Many reports never complete.
Applies to all supported PAS environments for specified releases.
Problem reproduced internally with customer's database on PPM 14.2 Patch 4 and also reproduced on v14.3
Caused by CLRT-79214
Resolved in CA PPM 14.2 Generic Patch #7.
Targeted for resolution in CA PPM 14.3 Generic Patch #3.
Targeted for resolution in next CA PPM release (Armstrong)
Reference TEC1398937 : PPM 14.2 Generic Patch available to resolve reported issues
Reference TEC1696455 : PPM 14.3 Generic Patch available to resolve reported issues