none
SCCM Connector not syncing SCSM. RRS feed

  • Question

  • SCCM Connector  not syncing SCSM.

    Domain: Windos 2016

    SCCM: SCCM1902

    SCSM: SCSM2019

    We are able Sync AD.while syncing SCCM connecting we are getting below error.

    We have provided all required permission on AD and SCCM and SCSM.

    Running with error .. 11%.

    Event ID:      3334

    Log Name:      Operations Manager
    Source:        Lfx Service
    Date:          10/15/2020 6:01:32 PM
    Event ID:      3334
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SCSM2019.ODCNUNI.COM
    Description:
    Data synchronization failed by SCCM.Importer.CMv5_INVENTORY.SCCMConnector.d67fc7daf1864183b002b689aaca1ada.:Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms.SmsConnector.
    Exception type:ConnectorException
    Exception message:getCurrentBatch failed . Exception type:DatabaseLayerException
    Exception message:Command type:Text
    Command:declare @maxWaterMark timestamp, @minWaterMark timestamp,@beginBatchID int, @endBatchID int; set @minWaterMark=convert(timestamp,@waterMarkMin); set @maxWaterMark=convert(timestamp,@waterMarkMax);set @beginBatchID=convert(int,@beginIDBin); set @endBatchID=convert(int,@endBatchIDBin); SELECT N.ResourceID,
                                        N.GroupKey,
                                        N.ChangeAction as Lfx_Status,
                                        N.[TimeStamp],
                                        N.DefaultIPGateway0,
                                        N.IPEnabled0,
                                        N.Index0,
                                        N.DHCPEnabled0,
                                        N.DHCPServer0,
                                        N.DNSDomain0,
                                        N.IPAddress0,
                                        N.IPSubnet0,
                                        N.MACAddress0,
                                        N.ServiceName0
                                from SCCM_Ext.vex_GS_NETWORK_ADAPTER_CONFIGURATION N
                                INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM
                                    ON N.ResourceID = CM.ResourceID
                                INNER JOIN SCCM_Ext.vex_Collection C
                                    ON C.CollectionID = CM.CollectionID  WHERE (N.[rowversion] > @minWaterMark and N.[rowversion] <= @maxWaterMark)  AND (C.ChangeAction = 'U' AND CM.ChangeAction = 'U'
                                    -- inventory from computers not in collection, or if collection is deleted is not interesting
                                    AND C.CollectionID IN ('SMS00001')
                               ) ORDER BY N.rowversion
    Connection state:Closed
    Parameter count:4
    Parameter name:@waterMarkMin,Parameter value:System.Byte[]
    Parameter name:@waterMarkMax,Parameter value:System.Byte[]
    Parameter name:@beginIDBin,Parameter value:System.Byte[]
    Parameter name:@endBatchIDBin,Parameter value:System.Byte[].
    StackTrace:   at Microsoft.EnterpriseManagement.ObjectOrientedDatabaseLayer.DatabaseAccessLayer.GetDataSet(DataSetRequest request)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.Sql.BatchInfoSql.ReadBatch(String tableName)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getBatchData(BatchInfo bi, Boolean batchInfoOnly, Boolean mustReadCache)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getCurrentBatch(SessionBase session, Boolean batchInfoOnly)
    Inner Exception:
    Exception message:Invalid column name 'DefaultIPGateway0'.
    Invalid column name 'IPEnabled0'.
    Invalid column name 'Index0'.
    Invalid column name 'DHCPEnabled0'.
    Invalid column name 'DHCPServer0'.
    Invalid column name 'DNSDomain0'.
    Invalid column name 'IPAddress0'.
    Invalid column name 'IPSubnet0'.
    Invalid column name 'MACAddress0'.
    Invalid column name 'ServiceName0'..
    StackTrace:   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.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
       at Microsoft.EnterpriseManagement.ObjectOrientedDatabaseLayer.DatabaseAccessLayer.GetDataSet(DataSetRequest request).
    StackTrace:   at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.throwConnectorException(String method, String message, Object[] values)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getCurrentBatch(SessionBase session, Boolean batchInfoOnly)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.GetNextBatch(IConnectorSession connectorSession, Boolean batchInfoOnly)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.Datacenter.SessionHost.DataSync()
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Lfx Service" />
        <EventID Qualifiers="0">3334</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2020-10-15T12:31:32.235152900Z" />
        <EventRecordID>369</EventRecordID>
        <Channel>Operations Manager</Channel>
        <Computer>SCSM2019.ODCNUNI.COM</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Data synchronization failed by SCCM.Importer.CMv5_INVENTORY.SCCMConnector.d67fc7daf1864183b002b689aaca1ada.:Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms.SmsConnector.
    Exception type:ConnectorException
    Exception message:getCurrentBatch failed . Exception type:DatabaseLayerException
    Exception message:Command type:Text
    Command:declare @maxWaterMark timestamp, @minWaterMark timestamp,@beginBatchID int, @endBatchID int; set @minWaterMark=convert(timestamp,@waterMarkMin); set @maxWaterMark=convert(timestamp,@waterMarkMax);set @beginBatchID=convert(int,@beginIDBin); set @endBatchID=convert(int,@endBatchIDBin); SELECT N.ResourceID,
                                        N.GroupKey,
                                        N.ChangeAction as Lfx_Status,
                                        N.[TimeStamp],
                                        N.DefaultIPGateway0,
                                        N.IPEnabled0,
                                        N.Index0,
                                        N.DHCPEnabled0,
                                        N.DHCPServer0,
                                        N.DNSDomain0,
                                        N.IPAddress0,
                                        N.IPSubnet0,
                                        N.MACAddress0,
                                        N.ServiceName0
                                from SCCM_Ext.vex_GS_NETWORK_ADAPTER_CONFIGURATION N
                                INNER JOIN SCCM_Ext.vex_FullCollectionMembership CM
                                    ON N.ResourceID = CM.ResourceID
                                INNER JOIN SCCM_Ext.vex_Collection C
                                    ON C.CollectionID = CM.CollectionID  WHERE (N.[rowversion] &gt; @minWaterMark and N.[rowversion] &lt;= @maxWaterMark)  AND (C.ChangeAction = 'U' AND CM.ChangeAction = 'U'
                                    -- inventory from computers not in collection, or if collection is deleted is not interesting
                                    AND C.CollectionID IN ('SMS00001')
                               ) ORDER BY N.rowversion
    Connection state:Closed
    Parameter count:4
    Parameter name:@waterMarkMin,Parameter value:System.Byte[]
    Parameter name:@waterMarkMax,Parameter value:System.Byte[]
    Parameter name:@beginIDBin,Parameter value:System.Byte[]
    Parameter name:@endBatchIDBin,Parameter value:System.Byte[].
    StackTrace:   at Microsoft.EnterpriseManagement.ObjectOrientedDatabaseLayer.DatabaseAccessLayer.GetDataSet(DataSetRequest request)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.Sql.BatchInfoSql.ReadBatch(String tableName)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getBatchData(BatchInfo bi, Boolean batchInfoOnly, Boolean mustReadCache)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getCurrentBatch(SessionBase session, Boolean batchInfoOnly)
    Inner Exception:
    Exception message:Invalid column name 'DefaultIPGateway0'.
    Invalid column name 'IPEnabled0'.
    Invalid column name 'Index0'.
    Invalid column name 'DHCPEnabled0'.
    Invalid column name 'DHCPServer0'.
    Invalid column name 'DNSDomain0'.
    Invalid column name 'IPAddress0'.
    Invalid column name 'IPSubnet0'.
    Invalid column name 'MACAddress0'.
    Invalid column name 'ServiceName0'..
    StackTrace:   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&amp; 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.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
       at Microsoft.EnterpriseManagement.ObjectOrientedDatabaseLayer.DatabaseAccessLayer.GetDataSet(DataSetRequest request).
    StackTrace:   at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.throwConnectorException(String method, String message, Object[] values)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getCurrentBatch(SessionBase session, Boolean batchInfoOnly)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.GetNextBatch(IConnectorSession connectorSession, Boolean batchInfoOnly)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.Datacenter.SessionHost.DataSync()</Data>
      </EventData>
    </Event>

    Please provide the solution.

    Regards,sds,

    Nuni


    N R Raju


    Thursday, October 15, 2020 1:00 PM