none
SCCM Software Usage Connectors Status = Finished with Errors at 25% since CU3 Install

    Question

  • We recently installed CU3 and we are finding our SCCM Connector is Finishing with Errors at 25% and now we cant get it to run again at all????
    Monday, January 16, 2012 7:55 PM

All replies

  • Hi,

    Any errors in the event log (Application logs -> Operations Manager)?

    Regards
    //Anders


    Anders Asp | Lumagate | www.lumagate.com | Sweden | My blog: www.scsm.se
    Monday, January 16, 2012 7:56 PM
  • I am seeing the followingL

     

    Log Name:      Operations Manager
    Source:        Lfx Service
    Date:          1/16/2012 4:01:48 AM
    Event ID:      3334
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      HTNPSCSM07VM.cam.corp
    Description:
    Data synchronization failed by SCCM.Connector.SoftwareUsage ccc.coopcam.com.Importer.MonthlyUsageSummary.SCCMConnector.95cbd47db20c4d1abaae56c1947fc28e.:Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms.SmsConnector.
    Exception type:ConnectorException
    Exception message:getCurrentBatch failed . Exception type:InvalidOperationException
    Exception message:Column 'PrincipalName' does not allow DBNull.Value..
    StackTrace:   at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
       at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
       at Microsoft.EnterpriseManagement.ObjectOrientedDatabaseLayer.DatabaseAccessLayer.BatchInsert(DataSet ds, DataTable schema, String tableName)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.BatchInfo.SaveBatchToCache(DataSet ds)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getCurrentBatch(SessionBase session, Boolean batchInfoOnly).
    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.GetNextBatch(IConnectorSession session)
       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="2012-01-16T10:01:48.000000000Z" />
        <EventRecordID>864660</EventRecordID>
        <Channel>Operations Manager</Channel>
        <Computer>HTNPSCSM07VM.cam.corp</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Data synchronization failed by SCCM.Connector.SoftwareUsage ccc.coopcam.com.Importer.MonthlyUsageSummary.SCCMConnector.95cbd47db20c4d1abaae56c1947fc28e.:Microsoft.EnterpriseManagement.ServiceManager.Connector.Sms.SmsConnector.
    Exception type:ConnectorException
    Exception message:getCurrentBatch failed . Exception type:InvalidOperationException
    Exception message:Column 'PrincipalName' does not allow DBNull.Value..
    StackTrace:   at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
       at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
       at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
       at Microsoft.EnterpriseManagement.ObjectOrientedDatabaseLayer.DatabaseAccessLayer.BatchInsert(DataSet ds, DataTable schema, String tableName)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.BatchInfo.SaveBatchToCache(DataSet ds)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.SessionManager.DataProvider.getCurrentBatch(SessionBase session, Boolean batchInfoOnly).
    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.GetNextBatch(IConnectorSession session)
       at Microsoft.EnterpriseManagement.ServiceManager.Connector.Datacenter.SessionHost.DataSync()</Data>
      </EventData>
    </Event>


    Thanks, Angelia Towler
    Monday, January 16, 2012 8:05 PM