'An error occurred in GetAccounts for objRS=objCom.Execute sSql: SELECT ADsPath FROM 'LDAP://DC=doma (NETIQKB22729)

  • 7722729
  • 02-Feb-2007
  • 19-Jun-2007

Resolution

Fact

Directory and Resource Administrator 6.x

Symptom

An error occurred in GetAccounts for objRS=objCom.Execute sSql: SELECT ADsPath FROM 'LDAP://DC=domain,DC=com WHERE objectClass='user' when trying to run the UpdateWin2K.xls 

Only 1000 objects are listed in the UpdateWin2K.xls after retrieving data.

Cause

The cause of this issue is the ADO search parameter does not specify a page size in the UpdateWin2k.xls file.  If you do not specify a page size, ADO searches defaults to return 1000 results.  .

Fix

An updated UpdateWin2k.xls which addresses this issue is available under the ADSI & CLI scripts section of the Knowledge Depot at: 
 
https://www.netiq.com/support/dra/extended/knowledgedepot/default.asp

In addition, this is also addressed in the version of the updatewin2k.xls in the DRA 7.0 SDK.



Additional Information

Formerly known as NETIQKB22729