When attempting to drillthrough a chart or graph in a dashboard, or in the Analyzer, a generic error is displayed in the console and an error similar to the following is logged in the RiskFabric.Log_Client table:
-- Request/response -- url:/api/analyzer/CreateUpdateEventSetNoCubeView api:null params:undefined extraParams:null Status: 400 StatusText: Bad Request responseText: "Bad Request" -- portalConfig -- _PortalUserId :01bb73c0-56e5-eb11-bde1-00155d002e00 _Administrator :true _CanViewMetrics :true _CanViewDIMRemediation :true _CanRemediateDIM :true _CanViewComplianceRemediation :true _CanRemediateCompliance :true _ExceptionAdministrator :true _CanViewScanExclusionS3 :false _CanViewScanExclusionAdmin :null _ScanExclusionAdministrator :true _CanViewPII :true -- S3 -- User.SelectedUser :1 User.TopUser :1
This is accompanied by an error similar to the following in the RiskFabric server log:
2022-12-12 18:12:42,834 [109:ERROR] AnalyzerController.CreateUpdateEventSetNoCubeView() Bad Request
System.Data.DataException: Error parsing column 13 (FilterValueType=MDX - String) ---> System.ArgumentException: Requested value 'MDX' was not found.
at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
at Deserializee6cd69cf-7b95-435f-921c-20150398d2d7(IDataReader )
--- End of inner exception stack trace ---
at RiskFabric.Web.Library.DALException.ControlThrow(Exception ex)
at RiskFabric.Web.Library.Utils.DapperRFExtensions.ExecuteAndLogTime[T](DALTimer timer, String sql, Object parms, Func`1 command)
at RiskFabric.Web.Library.Utils.DapperRFExtensions.QueryRF[T](IDbConnection connection, String sql, Object param, IDbTransaction transaction, Boolean buffered, Nullable`1 commandTimeout, Nullable`1 commandType, Action`1 fConverter)
at RiskFabric.Web.Library.Analyzer.DTOs.EntityScoperFilterByMeasureAndDimensionController.GetAll()
at System.Lazy`1.CreateValue()
at System.Lazy`1.LazyInitValue()
at RiskFabric.Web.Library.Analyzer.DTOs.EntityScoperFilterAccessor.<>c.<.ctor>b__6_0()
at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Lazy`1.get_Value()
at RiskFabric.Web.Library.Analyzer.DTOs.EntityScoperFilterAccessor.TryGetFilters(Guid cubeID, String measureName, String dimensionName, IEnumerable`1& filters)
at RiskFabric.Web.Library.Analyzer.Search.BaseSearchBuilder.DimensionScoperFilterSet.AddHierarchy(IHierarchy hierarchy)
at RiskFabric.Web.Library.Analyzer.Search.BaseSearchBuilder.BuildSearchFilters()
at RiskFabric.Web.Library.Analyzer.Search.BaseSearchBuilder.Build()
at RiskFabric.Web.Library.Analyzer.EventSetCreateOrUpdateRequestHandler.HandleRequest(IEventSetActionRequest request, SqlConnection sqlConnection, SqlTransactionWithPostActions sqlTransaction)
at RiskFabric.Web.Library.Analyzer.EventSetCreateOrUpdateRequestHandler.HandleRequest(IEventSetActionRequest request)
at RiskFabric.Web.Controllers.AnalyzerController.CreateUpdateEventSetNoCubeView(EventSetActionRequest request)
Release : 6.5.4
The database version is 6.5.4 MP1 (6.5.4.0010) but the application version is base 6.5.4 (6.5.4.0000). The MDX filter type was introduced in MP1, so the base 6.5.4 application code doesn't recognize that filter type and throws an error.
Run the Information Centric Analytics (ICA) 6.5.4 MP1 installer and select the option Full Install. Use all existing settings, including the database and cube. Enable verbose logging during installation and save the output to a file. If this problem persists after reinstalling, open a case with Broadcom support and upload the verbose log file to the case, along with the following details:
SELECT * FROM RiskFabric.dbo.Versions;
%SystemDrive%\Program Files\Bay Dynamics\Risk Fabric Server Web\bin