Drillthrough timeout on filtered Analyzer view

Products

• Information Centric Analytics

Issue/Introduction

After creating a view in the Analyzer that contains one or more filtered dimensions and attempting to drillthrough to the result set, the page loads for ten minutes and then displays the following error message:

Request Timed Out

Your request just timed out. Click 'OK' to close this window or 'Refresh' to refresh the page. Try again or contact the site administrator.

Error ID: <ID>

If the Analyzer view was saved as a rollup and used in an aging view dashboard widget, the following error message may also be captured in the RiskFabric server log:

158:ERROR] LoggingExceptionFilterAttribute.OnException() https://<host-name>/api/WidgetAgingView/GetSectionData
System.NullReferenceException: Object reference not set to an instance of an object.

Environment

Version : 6.x

Component : Analyzer

Cause

Drillthrough from an Analyzer view transposes the MDX query used in the Analyzer into a SQL OPENQUERY function. When a large number of values are passed to filter the MDX query result set, performance is degraded and may run up against the hardcoded query timeout of 600 seconds (SqlCommand.CommandTimeout).

An aging view widget error is a secondary thread concurrency failure caused by the two operations running in parallel, with the failing thread expecting the result set from the MDX subquery.

Resolution

This performance limitation is under investigation and will be addressed in a future release of ICA.

Reducing the number of explicitly selected or excluded filter values may resolve this issue. If the view is intended to serve as a dashboard widget and it's not possible to change the filter selections without negatively impacting the view's functionality, use a SQL query widget instead of an Analyzer widget and craft a SQL statement to return the desired result set from the RiskFabric SQL database. This will bypass the use of MDX with OPENQUERY.

Additional Information

The RiskFabric server log is located in the following default path on the application (IIS) server:

%ProgramData%\BayDynamics\Logs

The file name syntax is:

w3wp_RiskFabric.<yyyyMMdd>.log