SMS_DISCOVERY_DATA_MANAGER Message ID 2639: Discovery Data Manager failed to process the discovery data record

[Sana]

Hi,

 

I am seeing this critical error on my primary.

 

SMS_DISCOVERY_DATA_MANAGER Message ID 2636 and 620. Every time its a new DDR and there are tons of them.

 

Discovery Data Manager failed to process the discovery data record (DDR) "D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\userddrsonly\adu65oa0.DDR", because it cannot update the data source.

Possible cause: On a Primary site, it is probably a SQL Server problem.
Solution:
1. Review the immediately preceding status messages from this component about SQL Server errors.
2. Verify that this computer can reach the SQL Server computer.
3. Verify that SQL Server services are running.
4. Verify that the site can access the site database.
5. Verify that the site database, transaction log, and tempdb are not full.
6. Verify that there are at least 50 SQL Server user connections, plus 5 for each Configuration Manager Console.

If the problem persists, check the SQL Server error logs.

Possible cause: On a secondary site, Discovery Data Manager probably cannot write to a file on the site server, so check for low disk space on the site server.
Solution: Make more space available on the site server.

 

I have checked

Configuration Manager\inboxes\auth\ddm.box\userddrsonly\BAD_DDRS folder and found out that there are a bunch of ddr files in there. I am not sure if I can delete them or not. So I moved them to a temp folder.

 

I am also monitoring DDM.log and adusrdis.log. I saw no errors on adusrdis.log but I saw a couple of error messages in ddm.log for the users the ddr files were created.

 

DDM.log

 

QL>>>With SubTable(ItemKey, [sMS_Resident_Sites0]) AS ( SELECT ItemKey, [sMS_Resident_Sites0] FROM [system_SMS_Resident_ARR] WHERE ItemKey = 2097172281 ) MERGE INTO SubTable AS Target USING (SELECT DISTINCT 2097172281, [sMS_Resident_Sites0] FROM (VALUES (N'AAA')) AS tempSourceTable([sMS_Resident_Sites0])) AS Source (ItemKey, [sMS_Resident_Sites0]) ON (Target.ItemKey = Source.ItemKey AND Target.[sMS_Resident_Sites0] = Source.[sMS_Resident_Sites0]) WHEN NOT MATCHED BY TARGET THEN INSERT (ItemKey, [sMS_Resident_Sites0]) VALUES (Source.ItemKey, Source.[sMS_Resident_Sites0]) WHEN NOT MATCHED BY SOURCE AND (Target.ItemKey = 2097172281) THEN DELETE ; SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 10324 (0x2854)
SQL>>>update User_DISC set DiscArchKey = 4, title0 = N'Preferred Banking Offices Management', extensionAttribute40 = N'Employee' where ItemKey = 2063598788 SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)
*** [22001][8152][Microsoft]

[sql Server]String or binary data would be truncated. SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)

CDiscoverySource_SQL::UpdateItem - could not execute sql- update User_DISC set DiscArchKey = 4, title0 = N'Preferred Banking Offices Management', extensionAttribute40 = N'Employee' where ItemKey = 2063598788 SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)
CDiscoverDataManager::ProcessDDRs - Unable to update data source SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)

uuSTATMSG: ID=2636 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_DISCOVERY_DATA_MANAGER" SYS=abcdefgh.corp.xxxxxxxxxx.com SITE=AAA PID=2800 TID=9644 GMTDATE=Thu Aug 14 17:15:04.324 2014 ISTR0="D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\userddrsonly\adu9yyx1.DDR" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)
Moving bad file adu9yyx1.DDR to D:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\userddrsonly\BAD_DDRS\adu9yyx1.DDR. SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)
CDiscoverDataManager::ProcessUserDDRs_PS - Moved bad DDR SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)
CDiscoverDataManager::ProcessUserDDRs_PS - error encountered. Stopping for 1 minute(s) SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)
CDiscoverDataManager::THREAD_ProcessUserDDRs - Failed to manage files in inbox. Will retry in at least 60 seconds SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 9644 (0x25AC)
SQL>>>>> Done. SMS_DISCOVERY_DATA_MANAGER 8/14/2014 10:15:04 AM 10324 (0x2854)

 

 

Any thoughts?

 

Thanks!!!!

UK

[Sana]

Here are the contents of ddr file.. This is for users.

 

FV° ) <User>
BEGIN_PROPERTY
<8><Unique User Name><19><32><rrr\kyuyu>
END_PROPERTY
BEGIN_PROPERTY
<0><User Name><19><32><kyuyu>
END_PROPERTY
BEGIN_PROPERTY
<0><Full User Name><19><32><kyuyu>
END_PROPERTY
BEGIN_PROPERTY
<0><Windows NT Domain><19><32><rrr>
END_PROPERTY
BEGIN_PROPERTY
<0><Full Domain Name><19><32><CORP.yuyuyuyuy.C OM>
END_PROPERTY
BEGIN_PROPERTY
<0><Distinguished Name><19><96><CN=kyuyu,OU=Standard,OU=Users,OU=La Mesa,OU=rrr Sites,DC=corp,DC=yuyuyuyuy,DC=com>
END_PROPERTY
BEGIN_PROPERTY
<0><Network Operating System><19><32><Windows NT>
END_PROPERTY
BEGIN_PROPERTY
<17><User OU Name><19><96>
BEGIN_ARRAY_VALUES
<CORP.yuyuyuyuy.COM/rrr SITES><CORP.yuyuyuyuy.COM/rrr SITES/LA MESA><CORP.yuyuyuyuy.COM/rrr SITES/LA MESA/USERS><CORP.yuyuyuyuy.COM/rrr SITES/LA MESA/USERS/STANDARD>
END_ARRAY_VALUES
END_PROPERTY
BEGIN_PROPERTY
<17><User Container Name><19><96>
BEGIN_ARRAY_VALUES

END_ARRAY_VALUES
END_PROPERTY
BEGIN_PROPERTY
<0><Primary Group ID><8><4><513>
END_PROPERTY
BEGIN_PROPERTY
<0><User Account Control><8><4><512>
END_PROPERTY
BEGIN_PROPERTY
<0><SID><19><64><S-1-5-21-1751263204-1070006853-2113807418-142364>
END_PROPERTY
BEGIN_PROPERTY
<0><Object GUID><3><16><0x612663F144ABD54E816A641FF7C0EBEB>
END_PROPERTY
BEGIN_PROPERTY
<0><Mail><19><32><uuuu@kkkkkk.com>
END_PROPERTY
BEGIN_PROPERTY
<8><User Principal Name><19><32><kyuyu@corp.yuyuyuyuy.com>
END_PROPERTY
BEGIN_PROPERTY
<0><title><19><64><Preferred Office Management>
END_PROPERTY
BEGIN_PROPERTY
<0><department><19><32><Preferred Offices>
END_PROPERTY
BEGIN_PROPERTY
<0><extensionAttribute4><19><32><Employee>
END_PROPERTY
AGENTINFO<SMS_AD_USER_DISCOVERY_AGENT><FR1><08/15/2014 07:20:01>
FEOF
FV

[Sana]

I figured out what's goin on.

 

This errors are caused by the numerous AD loops in our environment(Huge binary values). Which we have to live with for next few months.