Unable to get newly created connectors to run - SCCM and AD Connector (Network Steve Forum)

Unable to get newly created connectors to run - SCCM and AD Connector

Hi,

I am unable to get any newly created Configuration Manager or AD connectors to run in SCSM. I am able to create the connectors, but can not get them to run. I do not have a date for when this started, but any connector I have always had running has no issues.

I checked the event log and found a couple of errors with the source "Data Connectors" , that I will place below. Does anyone know of how to resolve this issue?

AD Connector Errors

1. The group expansion workflow for connector Group Connector has encountered the following error:

Error: Error resolving group with domain (MY DOMAIN NAME WAS HERE) and name EA. Exception: System.DirectoryServices.AccountManagement.MultipleMatchesException: Multiple principals contain a matching Identity.

at System.DirectoryServices.AccountManagement.ADStoreCtx.FindPrincipalByIdentRefHelper(Type principalType, String urnScheme, String urnValue, DateTime referenceDate, Boolean useSidHistory)

at System.DirectoryServices.AccountManagement.ADStoreCtx.FindPrincipalByIdentRef(Type principalType, String urnScheme, String urnValue, DateTime referenceDate)

at System.DirectoryServices.AccountManagement.Principal.FindByIdentityWithTypeHelper(PrincipalContext context, Type principalType, Nullable`1 identityType, String identityValue, DateTime refDate)

at System.DirectoryServices.AccountManagement.GroupPrincipal.FindByIdentity(PrincipalContext context, String identityValue)

at Microsoft.EnterpriseManagement.ServiceManager.Sdk.Connectors.Lfx.Workflows.ADGroupExpander.Start(Guid connectorId)

2. The group expansion workflow for connector Group Connector has encountered the following error:

Error: System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.EnterpriseManagement.ServiceManager.Sdk.Connectors.Lfx.Workflows.ADPersonCreator.Flush()

at Microsoft.EnterpriseManagement.ServiceManager.Sdk.Connectors.Lfx.Workflows.CSVImportCreator.AddObjectToQueue(BatchCommitObject adObject)

at Microsoft.EnterpriseManagement.ServiceManager.Sdk.Connectors.Lfx.Workflows.ADGroupExpander.ExpandGroup(GroupPrincipal groupPrincipal)

Additionally, I also get information logs that show as if data is being imported even though the console does not show the connector as running

Config Manager Connector

Connector Configuration Manager Connector imported 20 changes for data of type Microsoft.SystemCenter.ConfigurationManager.NonComplianceRefersComputer from cache table Cached_CMv5_DCMNonCompliantConfigItems.

AD Connector

Connector Group Connector,ADConnector.0b729dc46a2e4734837c4c26c2b7c454 saving 9 datarows returned by query to table/view ADGroups. These include creates/updates or deletions at source.

August 20th, 2015 4:33pm

Hi,

This envirorment is new?

Or did you delete old connectors and create new ones?

Frat

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 6:24am

Hello,

I deleted old connectors and tried to create new ones.

August 21st, 2015 9:36am

is this after installing any UR?

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 1:42pm

I currently have UR5 installed. The connectors were running after I installed UR5.

August 21st, 2015 2:11pm

Ok run this sql command to service manager DB and check old records are still exist?

use ServiceManager
select * from lfx.DataSource

Edited by Firat YASAR 11 hours 55 minutes ago

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 3:20pm

Yes, the old records still exist.

August 21st, 2015 3:38pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR 10 hours 44 minutes ago

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 4:24pm

Ok run this sql command to service manager DB and check old records are still exist?

use ServiceManager
select * from lfx.DataSource

Edited by Firat YASAR Friday, August 21, 2015 7:19 PM

August 21st, 2015 7:18pm

Ok run this sql command to service manager DB and check old records are still exist?

use ServiceManager
select * from lfx.DataSource

Edited by Firat YASAR Friday, August 21, 2015 7:19 PM

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 7:18pm

Ok run this sql command to service manager DB and check old records are still exist?

use ServiceManager
select * from lfx.DataSource

Edited by Firat YASAR Friday, August 21, 2015 7:19 PM

August 21st, 2015 7:18pm

Ok run this sql command to service manager DB and check old records are still exist?

use ServiceManager
select * from lfx.DataSource

Edited by Firat YASAR Friday, August 21, 2015 7:19 PM

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 7:18pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM 10 hours 4 minutes ago

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM
Marked as answer by Xin GuoMicrosoft contingent staff, Moderator 20 hours 5 minutes ago

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM
Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, September 03, 2015 11:10 AM

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM
Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, September 03, 2015 11:10 AM

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM
Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, September 03, 2015 11:10 AM
Unmarked as answer by ETechnetG 12 hours 0 minutes ago
Unproposed as answer by ETechnetG 10 hours 28 minutes ago

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM
Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, September 03, 2015 11:10 AM
Unmarked as answer by ETechnetG Thursday, September 10, 2015 7:11 PM
Unproposed as answer by ETechnetG Thursday, September 10, 2015 8:44 PM

Free Windows Admin Tool Kit Click here and download it now

August 21st, 2015 8:22pm

ok . backup your service manager db and run this script,

Write in the data source names that you got after running the query I had sent.

use ServiceManager
DECLARE @DataSourceId INT
DECLARE @out VARCHAR(2000)

DECLARE myCursor CURSOR FOR
select DataSourceId from lfx.DataSource where DataSourceName in 
(
--Replace the stale datasource name here (old Datasource name)
'ADConnector.3a347a9903604c8c9843b01cef5e31cd',
'ADConnector.9843b01cef5e31cdbb03604c8c73231c',
)

OPEN myCursor
FETCH NEXT FROM myCursor INTO @DataSourceId

WHILE @@FETCH_STATUS = 0
BEGIN
      
      EXEC LFX.DEL_DataSource @DataSourceId, @out
      SELECT @out
      FETCH NEXT FROM myCursor INTO @DataSourceId
END

CLOSE myCursor
DEALLOCATE myCursor

Then export your "Service Manager Linking Framework Configuration" management pack. Opent it in xml editor. delete old datasource "write action" on that management pack . As below.

Then Re-import changed MP to service manager. delete SM cache on server.

For this process,

1- Stop Health service (Microsoft Monitoring agent service)

2- Rename Health service state folder, (C:\ProgramFiles\System Center Service Manager 2012 R2\Health Service State) like Health Service StateOLD

3- Start Service Again.

Frat

Edited by Firat YASAR Friday, August 21, 2015 8:30 PM
Proposed as answer by Zeki YARDIM Tuesday, August 25, 2015 9:12 PM
Marked as answer by Xin GuoMicrosoft contingent staff, Moderator Thursday, September 03, 2015 11:10 AM
Unmarked as answer by ETechnetG Thursday, September 10, 2015 7:11 PM
Unproposed as answer by ETechnetG Thursday, September 10, 2015 8:44 PM

August 21st, 2015 8:22pm

Is it Works for you?

Free Windows Admin Tool Kit Click here and download it now

August 30th, 2015 6:38pm

This topic is archived. No further replies will be accepted.