The Calculate Risk Scores step (19) of the nightly RiskFabric Processing job fails and logs the following error message:
[SQLSTATE 01003] (Message 8153) Error Msg: The requested operation could not be performed because OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB" does not support the required transaction interface.
Alternatively, while drilling-through a dashboard or search to view a DIM incident, a generic error message is displayed in the Risk Fabric console and either of the following errors are recorded in the Risk Fabric server log:
[60:ERROR] DALException.SaveLog() Error: Server 'RiskFabric_ASDB' is not configured for RPC.
[12:ERROR] DALException.SaveLog() System.Data.SqlClient.SqlException (0x80131904): The requested operation could not be performed because OLE DB provider "MSOLAP" for linked server "RiskFabric_ASDB" does not support the required transaction interface.
Version : 6.x
To resolve these errors, configure the RiskFabric_ASDB
linked server as follows:
RiskFabric
relational databaseThe Risk Fabric server log is located on the server hosting Internet Information Services (IIS) and the Information Centric Analytics (ICA) application. The file's naming syntax is w3wp_RiskFabric.<yyyyMMdd>.log
and the file is located in the following path:
%ProgramData%\BayDynamics\Logs