The following error is logged on the job step Risk Fabric cube processing (16) while running the RiskFabric Processing job:
<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error." Source="Microsoft Analysis Services" HelpFile="" /><Error ErrorCode="3239182436" Description="Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'RiskFabric', Name of 'RiskFabric'." Source="Microsoft Analysis Services" HelpFile="" />
The RiskFabric relational database is hosted on a named instance of SQL Server. No other database engine instances are hosted, including the default instance. In SQL Server Analysis Services (SSAS), the data source connection string pointing to the RiskFabric relational database specifies both the server and instance name hosting the database, rather than the fully qualified domain name (FQDN) with no reference to a specific instance. Port 1433 is open on the server hosting SQL Server. A SQL Server Profiler trace shows a connection established between the SSAS and SQL servers, but the connection abruptly closes during processing.
Release : 6.x
The default instance of the Microsoft SQL Server database engine listens for TCP connections on port 1433. Named instances use dynamic ports. In an environment in which specific ports or port ranges are restricted by firewall rules, the use of a named instance in the data source connection string causes a connection to be made using dynamic ports, resulting in connectivity failures even though port 1433 has been explicitly opened for communication between the two servers and only one database engine instance exists on the SQL Server.
Modify the data source connection string by following this procedure: