On the Weekly Detail or Booking Status Portlets in CA Project & Portfolio Management (PPM), the query takes huge amount of time to return results. The performance degrades as the data volume increases.
This happens when the user has instance or OBS Level access to a larger number of resources.
Steps to Reproduce:
- Log in to the application as an administrator user
- Create a user profile granting 'Instance' or 'OBS' security access rights to view or book other resources for resource planning purposes (it does not matter how many instances the user has access granted to view)
Example: Grant 'Resource - View Book', 'Resource - View Book - All' and 'Project - View Management' to a user through an OBS unit - Log in as the user defined with non-global security access rights to view resources
- Navigate to Home, Resource Planning, Weekly Detail or Booking Status portlet
Expected Result: To display results in a reasonable time regardless of the security access granted to the user.
Actual Result: It takes a long time to display results or never returns results. Performance degrades as the number of instances increases granted to the user access.