web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Microsoft.Crm.Monitori...
Microsoft Dynamics CRM (Archived)

Microsoft.Crm.Monitoring.Engine.MonitoringRuntime exception Event id: 18690

(1) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I would appreciate if somebody give me a clue what could be probably wrong with our production CRM 2015 on-prem instance. Since sometime I see lots of errors from CRM Monitoring Engine on back-end servers only.  But at the same time everything seems working fine. The instance consists 4 servers: 2 web,  2 async+sandbox + SQL AlwaysOn enabled fabric. The error reoccurs every 10 minutes.

If somebody can advise what could be the cause and how to fix it, it would be great.

Thank you very much in advance.

Regards,

Slava.

 

Monitoring runtime failed: Machine: MCHAPPP01: Exception: The type initializer for 'Microsoft.Crm.Monitoring.Engine.MonitoringRuntime' threw an exception.

at Microsoft.Crm.Monitoring.Engine.MonitoringRuntime.RetrieveServerRolesForMachine(String machineName)
at Microsoft.Crm.Monitoring.Engine.MonitoringRuntime..ctor(TestFrequency testFrequency)

InnerException Type:System.TypeInitializationException
The type initializer for 'Microsoft.Crm.Monitoring.MonitoringSettings' threw an exception.
at Microsoft.Crm.Monitoring.MonitoringSettings.get_StoreResultsInDatabase()
at Microsoft.Crm.SmokeTests.Execute.ExecuteMonitoringTests(ServerRoles targetRoles, TestFrequency testFrequency, Boolean inService)
at Microsoft.Crm.SmokeTests.Execute.Main(String[] args)
at Microsoft.Crm.Monitoring.Service.MonitoringService.ExecuteTestsThreadProc(Object args)

InnerException Type:System.TypeInitializationException
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
at Microsoft.Crm.CrmDbConnection.Open()
at Microsoft.Crm.SharedDatabase.DatabaseMetadata.LoadMetadataXmlFromDatabase(CrmDBConnectionType connectionType, String connectionString, Int32& maxBlobSize)
at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.LoadCache(String connectionString)
at Microsoft.Crm.ConfigurationDatabase.ConfigurationMetadata.get_Cache()
at Microsoft.Crm.SharedDatabase.DatabaseService.Initialize(String tableName)
at Microsoft.Crm.SharedDatabase.DatabaseService.RetrieveInternal(String tableName, String[] columns, PropertyBag[] conditions, Nullable`1 top, Nullable`1 offset, IList`1 orderBy, QueryHints hints, IDictionary collectionToFill)
at Microsoft.Crm.SharedDatabase.DatabaseService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
at Microsoft.Crm.ServerLocatorService.Retrieve(String tableName, String[] columns, PropertyBag[] conditions)
at Microsoft.Crm.Monitoring.MonitoringSettings..cctor()

InnerException Type:System.Data.SqlClient.SqlException
.

*This post is locked for comments

I have the same question (0)
  • Sumeet_MSFT Profile Picture
    Sumeet_MSFT on at

    Hello Slava,

    Thank you for your query.

    The issue might be due to firewall.

    Please add the Dynamic port of the SQL named instance in the firewall rule.

    If you want to change SQL instance Dynamics Port to Static port.

    Follow these steps to configure Static TCP Port

    1.      Click Start à All Programsà Microsoft SQL Server à Configuration Tools à Launch  “SQL Server Configuration Manager”

    2.      Under “SQL Server Network Configuration” à Select “Protocols for <Instance Name” à Got to TCP/IP Properties

    3.      Select “IP Addresses Tab” à Go to “IPAll” section

    4.      Remove TCP Dynamic ports and update TCP Port: <Static port>

    Please restart the SQL Server and check if the issue still persist.

    Hope this helps for you!

    Thanks & Regards,

    Sumeet Deshmukh

    Microsoft Dynamics™ CRM Support Engineer

    Please mark my post as "Verified" If it helped to solve your Issue. 

  • CU21020959-0 Profile Picture
    CU21020959-0 2,601 on at

    Did you ever fix this?  I'm having the same issue

  • CU21020959-0 Profile Picture
    CU21020959-0 2,601 on at

    For me this was a problem with the Account the CRM Monitoring Service was running under.  Running an SETSPN command resolved the issues.

  • Community Member Profile Picture
    Community Member on at

    can you please provide some more information , how did you run the setspn command  .

    Thanks

  • Suggested answer
    CU21020959-0 Profile Picture
    CU21020959-0 2,601 on at

    On the Server I ran the following command

    SETSPN -A MSCRMMonitoringService/localhost {ACCOUNT}

    {ACCOUNT} is the account that's running the Microsoft Dynamics CRM Monitoring Service

    See https://technet.microsoft.com/en-us/library/hh699825.aspx section on Microsoft Dynamics CRM Monitoring Service.

    Hope that helps :)

  • Community Member Profile Picture
    Community Member on at

    Thanks for the info. I had the same problem and that solved it.

  • Michael Macchiaroli Profile Picture
    Michael Macchiaroli on at

    Harjit you rock. Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans