CER job failing with error "SQL Data Collector: query returned with message(s). <No information available for this COM error> "

Products

• Control Compliance Suite

Issue/Introduction

CER jobs failing  against the SQL Server asset

Error:
SQL Data Collector: query returned with message(s). <No information available for this COM error> 

DBIFServerConfigurations.cpp(535) | 3: Error: msmdsrv.ini does not exist at path specified by SQLPath: .\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Config\msmdsrv.ini

Cause

 CCS data collector reads SQL Analysis Services data and SQL reporting service data. As the msmdsrv.ini file is missing, the error is observed. 

Resolution

Options 1:  Remove the SQL Analysis services if you are not using it  

Option 2: If SQL Analysis service is installed and actively running, the file msmdsrv.ini should be present  ( location may vary depend upon the Environment ) 
if SQL Server Analysis Services (SSAS) is properly installed, msmdsrv.ini is created by default at following path:

<SQL Install Path>\MSASXX.<InstanceName>\OLAP\Config\

CCS data collection look for the msmdsrv.ini file at this location if SQL analysis service is installed.