RPC and supported transaction interface errors
search cancel

RPC and supported transaction interface errors

book

Article ID: 382443

calendar_today

Updated On:

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