DIM search Details tab displays no results

Products

• Information Centric Analytics

Issue/Introduction

When loading any DIM search results page in the Information Centric Analytics (ICA) console, a generic error is initially displayed ("An error has occurred"). Both the Summary and Differences tabs load properly and return a count of DIM incidents. When you click the Details page, however, no results are returned.

An error similar to the following is recorded in the Log_Client table of the RiskFabric database with a LogClientID corresponding to the ID displayed in the error message in the console:

REQUEST EXCEPTION    -- Request/response – url:/api/dim/DoIncidentSearch?_dc=1690464990089 api:null params:undefined extraParams:null Status: 500 StatusText: Internal Server Error responseText: {"Message":"An error has occurred."}

The browser's developer tools capture the same 500 error:

"Message": "An error has occurred."

The following error is logged in the RiskFabric server log on the application server:

[25:ERROR] LoggingExceptionFilterAttribute.OnException() http://<hostname>/api/dim/DoIncidentSearch?_dc=1690464990089
System.ArgumentException: Column 'incidentDate' does not belong to table .

Environment

Release : 6.x

Cause

Portions of ICA's C# code are inadvertently converted by a foreign language character set (e.g., Türkçe) on the application (IIS) server despite the server's region and language settings being configured as United States (US) English.

Resolution

Add the following line of code to the <system.web> key in ICA's web.config file to resolve the error:

<globalization culture="en-US" uiCulture="en-US" />

For example:

<system.web>
  <customErrors mode="On" defaultRedirect="~/Error.html" />
     <compilation debug="true" targetFramework="4.7.1" />
  <httpRuntime maxRequestLength="600000000" executionTimeout="3600" requestValidationMode="2.0" enableVersionHeader="false" targetFramework="4.7.1" />
     <httpCookies httpOnlyCookies="true" />
     <authentication mode="Windows" />
  <pages validateRequest="true" controlRenderingCompatibilityVersion="4.0" />
         <trust level="Full" />
  <globalization culture="en-US" uiCulture="en-US" />
</system.web>

This code will be added to a future release of ICA.