[Logo] LDAPSoft LDAP And Active Directory Tools Community Forums
  [Search] Search   [Register] Register /  [Login] Login 
 
Mass Update Active Directory  XML
Forum Index » General Discussion
Author Message
don12



Joined: 15/06/2010 16:32:27
Messages: 6
Offline

I'm trying to update about 8500 records in active directory and I'm getting the following error when I run my SQL query:

LDAPException: Sizelimit Exceeded (4) Sizelimit ExceededLDAPException: Matched DN: -- null
Here is my SQL query (with modified values):

UPDATE OU=Users,DC=example,DC=com SET telephoneNumber=NULL WHERE telephoneNumber='519-111-2222' subtreescope

I also changes the Max. Results value to 10000.

If I do a search for all users with that phone number I get 8344 entries returned, so I don't think there is anything wrong with the domain controllers settings. I even set MaxPageSize to 10000 and MaxResultSetSize to 1Mb on the domain controller and I still get the same error.

Any help would be greatly appreciated.
support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

Try one of the following:

Increase MaxPageSize (http://support.microsoft.com/kb/315071) and
disable Enable Ldap Paged Result control from Preference|General (Last
check box)

or

Constraint update to less than 1000 using some attribute for e.g (and sn
like 'a%' or 'b%') and run update sql a few times.

UPDATE OU=Users,DC=example,DC=com SET telephoneNumber=NULL WHERE telephoneNumber='519-111-2222' and sn like 'a%' or 'b%' subtreescope;
don12



Joined: 15/06/2010 16:32:27
Messages: 6
Offline

Thanks, I will do it in increments.

How do I set the value of the attribute so that there is no value that appears in AD? If I do SET telephoneNumber = NULL, NULL appears as the phone number, if I do SET telephoneNumber = '', '' appears as the phone number.
support



Joined: 27/06/2008 19:01:18
Messages: 123
Offline

Try Null in small letters - null - also no space after =

SET telephoneNumber=null
don12



Joined: 15/06/2010 16:32:27
Messages: 6
Offline

Thanks alot, it worked perfectly!
 
Forum Index » General Discussion
Go to:   
[Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
Powered by JForum 2.1.9 © JForum Team