Description:
On the Weekly Detail or Booking Status Portlets, 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 rights (via OBS, direct etc) to a larger number of resources.
Steps to Reproduce:
- Login 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 - Login 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.
Solution:
The intention of the design and use of these portlets is for a Resource Manager having access to a limited number of resources in the system for managing the planning aspect of investment work. It is not intended for use as a reporting tool, please use a reporting tool or the data warehouse.
Configuring a user with Instance or OBS Unit access for a larger number of resources may impact the performance of these portlets. There are a few configuration changes that can be implemented that will help to improve the performance for these portlets. You can implement some or all configuration ideas.
- Grant the global access right 'Resource - View Book - All'. Note this configuration change will allow the user to view all resources in the system. In extreme cases where a resource manager manages a large portion of the user base the use of global rights might be considered. Warning: Granting of global rights can cause other performance issues when aggregation rows are added to the portlets.
- When navigating to the page with the portlet and to reduce the amount of data returned in the results, the 'Show All' button can be removed in the Filter section by configuring at least one filter attribute as a 'Required' field.
The field that is configured as 'Required' can be any available field. When a 'Required' field is configured as a visible attribute in the Filter Section, it will ask for a default value. Once the field has been configured and saved, this becomes the system default filter criteria and you will no longer see the 'Show All' button. Be sure to 'Publish' this configuration change. NOTE: Publishing this change will erase any user-saved configurations or filters. - Increase network timeout settings to allow for longer response time in this area
- In Studio, change the portlet configuration option not to show any results until the user provides filtering criteria. Making this change will force the user to provide specific filtering to improve performance response times.
- Login to the application as an administrator user
- Administration, Studio: Portlets
- Search for and open the 'Booking Status' portlet (ID = projmgr.bookingStatus)
- Go to List Column Section, Options
- Select/checkmark the filter option 'Do not show results until I filter'
- Click 'Save' button
- Go to the portlet General Tab, click 'Publish' button - this will reset all end user portlet personal configuration on this portlet
- Repeat steps 3-7 for the 'Resource Workloads' portlet (ID = projmgr.resourceWorkloads) or other Resource Planning portlets