Generic error loading DIM search-based dashboard

Products

• Information Centric Analytics

Issue/Introduction

When Information Centric Analytics (ICA) portal users attempt to load a Data In Motion (DIM) search-based dashboard, the following error message is displayed:

Request Failed

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

Error ID: <error-ID>

This error is displayed for all users, regardless of their assigned portal privileges.

Environment

Version : 6.x

Component : Dashboards

Cause

The underlying cause of this condition is unknown.

Resolution

To resolve this condition, restart both the World Wide Web Publishing service (W3SVC) on the server hosting the ICA application and the SQL Server service (MSSQLSERVER[\<instance-name>]) on the server hosting the RiskFabric relational database.

Additional Information

The error ID displayed to the user refers to an entry in the table dbo.Log_Client. Corresponding errors are also captured in the RiskFabric server log (w3wp_RiskFabric.<yyyyMMdd>.log) containing the failing query in the exception stack trace. For example:

[151:ERROR] DALException.SaveLog() Error: Incorrect syntax near ';'.

When a DIM search-based dashboard is loaded, the application executes a SQL statement that includes an OPENQUERY function containing an MDX query for execution against the RiskFabric cube. Under certain conditions, the query is corrupted by the anomalous presence of HTML character codes, causing the statement to fail. For example:

SELECT  *     FROM OPENQUERY(%%linked_server%%, '%%mdx_query%%') ) x (ID, Measure)  WHERE Measure > 0 ",\r\n  "filter": "Measure > 0 ",\r\n  "return_values": [\r\n    {\r\n      "name": "ID",\r\n      "type": "INT",\r\n      "formatted": "TRY_CAST(CONVERT(VARCHAR(32), ID) AS INT)"\r\n    }\r\n  ]\r\n}',\r\n\t@i_tempTableName = '#DIMIncidentActionID_EntityScoperID_tempTable',\r\n\t@i_bCreateTempTable = 0,\r\n\t@i_bSQLOnly = 0,\r\n\t@i_bSaveToTempTable = 1,\r\n\t@i_bIsDebug = 0;\r\nCREATE CLUSTERED INDEX CLIX_#DIMIncidentActionID_EntityScoperID_tempTable_ID ON #DIMIncidentActionID_EntityScoperID_tempTable (ID ASC);\r\nDROP TABLE IF EXISTS #DIMIncidentStatusID_EntityScoperID_tempTable;\r\nCREATE TABLE #DIMIncidentStatusID_EntityScoperID_tempTable\r\n(\r\n    ID VARCHAR(256) NULL,\r\n\tMeasure VARCHAR(128) NULL\r\n);\r\n\r\nDECLARE @DIMIncidentStatusID_EntityScoperID_defaultValue VARCHAR(50) = '-1';\r\n\r\nEXEC dbo.Search_GetMDXResults\r\n\t@i_sMDXJson = '{\r\n  "mdx": "SELECT NON EMPTY{[Measures].[DIM Incident Count]}ON 0,NON EMPTY FILTER({[DIM Incident Status].[DIM Incident Status ID].CHILDREN},[Measures].[DIM Incident Count]>0)ON 1FROM(SELECT({[DIM Incident Status].[DIM Incident Status].&[Business - Not Reviewed]})ON 0FROM[Risk Fabric])",\r\n  "linked_server": "[RiskFabric_ASDB]",\r\n  "sql_wrapper"