BSI screen is becoming unresponsive while creating adapters

Document ID : KB000116629
Last Modified Date : 01/10/2018
Show Technical Document Details
Issue:
On creating SQL adapters and at the "Data Source Interface" the TEST QUERY button becomes unresponsive. and a blank pop-up is displayed.
Environment:
CA Business Service Insight 8.3.5
Cause:
Large amount of data is queried (nearly 10 million) and this has caused the latency in response and eventually timeout.
Resolution:
Workaround ececuted to identify the root cause

1. Ran the query on SQL database (backend)
2. Noted the query is fetching huge amount of records
3. Query is submitted in UI, however requested to display a max of 10 records.
Note: Even though 10 records are requested to be displayed on BSI UI page, the underlying DB statement is querying for the entire data.
4. The BSI UI was timing out in caching the data and subsequently and display the blank page in the pop-up window
5. Suggested to modify the query to fetch limited records per requirement