Error: 'The report response is invalid' when you click on Home

Products

• Mail Security for Microsoft Exchange

Issue/Introduction

When you open Symantec Mail Security for Microsoft Exchange (SMSMSE) and click Home an error, 'The report response is invalid' appears.

An error, similar to the following, appears in the Application Event Log:

 Time : Thursday, October 18, 2018 3:37:25 PM
 Outer Exception Type: System.InvalidOperationException
 Outer Exception Message: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
 Outer Exception Source: System.Data
 ---Outer Exception Stack Trace---
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Symantec.Cmaf.Reporting.DataAccess.ReportingDBAccess.SelectHomePageData(VirusStatistics& virusStatistics, Statistics& statistics, ChartData& chartData)

Source : System.Runtime.Remoting.Messaging.StackBuilderSink::_PrivateProcessMessage Thread:18
_PrivateProcessMessage at offset 0 in file:line:column <filename unknown>:0:0

Environment

 

Cause

A call to Microsoft MDAC made by SMSMSE returned the message, The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Resolution

Perform a repair of the Microsoft Access Database Engine 2010 application:

1. open Control Panel
2. Click on Program and Features or Uninstall Program
3. Right click on Microsoft Access Database Engine 2010  and select repair.