locked
SCOM Discovery failing - Event ID 7104,26308 RRS feed

  • Question

  • I get below error in the Event logs after patching has been done on the DB. Please suggest me a solution as I'm unable to discover any windows or Unix servers through discovery wizard. Also, we see lot of sessions are getting blocked due to load. Please guide. 

    Event ID: 7104:

    Management Group: HUSKY_SCOM2016. Script: SQLAgentJobDiscovery.vbs. Version: 7.0.0.0. Instance: SCOMPRD : SQL Agent Job discovery script 

    'SQLAgentJobDiscovery.vbs' for SQL instance 'SCOMPRD' failed.
    The next errors occurred:
    Query execution failed: [Microsoft][SQL Server Native Client 11.0]Query timeout expired

    Event ID: 26308

    Query notification processing failed due to a sql exception. 

    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'Queue_mid10_200_103_79_pid2596_adid2_r1487888345'.
       at System.Data.SqlClient.SqlConnection.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.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
       at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod, Boolean isInternal)
       at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
       at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult)
       at Microsoft.EnterpriseManagement.DataAccessLayer.QueryNotificationManager.HandleNotifications(Object state)
    ClientConnectionId:246be8a5-40fe-469d-871a-9e5f85d6659c
    Error Number:208,State:12,Class:16

    Tuesday, March 26, 2019 11:02 AM

Answers

  • Hi,

    Thank you for the clarification and we reviewed all the related threads mentioned above. Have we rebooted the database server up to now? If not yet, have a try.

    Regards,

    Alex Zhu
    -----------------------------------------------
    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
    • Marked as answer by Zikki_Asks Wednesday, March 27, 2019 9:05 AM
    Wednesday, March 27, 2019 2:59 AM

All replies