OBS autosuggest feature is slow in PPM

Document ID : KB000115872
Last Modified Date : 09/10/2018
Show Technical Document Details
Issue:
OBS autosuggest feature is slow in CA Project & Portfolio Management (PPM). When typing a value in an OBS lookup field, it is taking slower than normal (between 10-30 seconds) for any results to return. 

Steps to Reproduce:

1. Go to an OBS Field such as in the Project list Filter
2. Start typing part of an OBS in the text box

Expected Results: OBS suggested results appear instantly
Actual Results: It takes a long time for the results to appear, the length varies, but it can take at least 20-30 seconds 
Resolution:
  • On Premise customers:  Have the DBA check to see if there are any slow running queries, if so, rebuilding the execution plan for any slow running queries can help resolve the performance issue.
  • PPM SaaS Customers: Contact CA Support for assistance
    • Note: Generating a PPM Action trace while reproducing the issue can help in determining if there are any slow running queries causing the issue (see steps to enable action trace at: KB000009353)
Additional Information:
Reference KB000115875 for details regarding the Department OBS auto-suggest feature being slow in PPM due to a defect fixed in 15.4.1.