Test Query Button is becoming unresponsive

Products

• CA Business Service Insight

Issue/Introduction

On creating SQL adapters, at the "Data Source Interface" screen the TEST QUERY button becomes unresponsive and a blank pop-up is displayed.

Environment

CA Business Service Insight 8.3.5 and 9.x

Cause

Large amount of data is queried which causes latency in response and eventual timeout.

Resolution

To determine if large data request is causing the issue:

1. Run the query being used with the SQL Adapter directly against the BSI database

2. Note how many records the query retrieves

Note:  Regardless of how many records are requested to be displayed on BSI UI page, the underlying database query will query the entire data result set.

3.  Modify the query to fetch a limited set of records