RiskFabric Processing job failure on connections between OLAP cube and relational database

Products

• Information Centric Analytics

Issue/Introduction

Information Centric Analytics (ICA) job steps that communicate between SQL Server Analysis Services (SSAS) and SQL Server (MSSQL) are failing in both the nightly RiskFabric Processing and RiskFabric Intraday Processing jobs. The following error message is returned:

<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001." Source="Microsoft SQL Server 2016 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 SQL Server 2016 Analysis Services" HelpFile="" />...</root></results></return>.  The step failed.

Environment

Release : 6.x

Component : Microsoft SQL Server

Resolution

If you encounter this error, contact Microsoft support for assistance.