RPC and supported transaction interface errors

Products

• Information Centric Analytics

Issue/Introduction

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.

Environment

Version : 6.x

Resolution

To resolve these errors, configure the RiskFabric_ASDB linked server as follows:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Database Engine hosting the RiskFabric relational database
3. In Object Explorer, navigate to Server Objects > Linked Servers
4. Right-click the RiskFabric_ASDB linked server and select Properties
   The Linked Server Properties - RiskFabric_ASDB window opens
5. Select the Server Options page
6. Configure the settings on this page as follows:
   

   Collation Compatible	False
   Data Access	True
   RPC	False
   RPC Out	True
   Use Remote Collation	True
   Collation Name
   Connection Timeout	0
   Query Timeout	0
   Distributor	False
   Publisher	False
   Subscriber	False
   Lazy Schema Validation	False
   Enable Promotion of Distributed Transactions for RPC	False

7. Click the OK button to save changes and close the Linked Server Properties - RiskFabric_ASDB window

Additional Information

The 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