Extract all users from AD group and facing error when I extract when there are more than 1000 users.

[kishore3k]

Hi All,

I have issue extracting more than 1000 users from AD group with below error message.

Is there somewhere can we edit this parameter to change to 10000? I have more than 3300+ user at the moment and it will increase over time. 

20220406T134808.948+0200 EQ_QVX_SIZELIMIT_EXCEEDED: The size limit for this request was exceeded.
20220406T134808.948+0200 This query was stopped because it tried to read beyond a restricted limit. One of the tables in the query has a limit of maximum 1000 rows. 

I have attached sample code below . (Code is used from Qlikview Cookbook)

//AD Members Extract from Application and respective AD groups

ApplicationGroup:
LOAD distinct
    'ONEVIEW' as "Application Name",
    'APP-GLOBAL-OneView-NationalUsers' as ADGroup //Provide AD Group name
AutoGenerate (1);


LIB CONNECT TO 'LDAP_DSO';
SET RootDse = 'DC=domain, DC=com';//enter domain


For i = 0 to NoOfRows('ApplicationGroup') - 1

LET vGroup = peek('ADGroup', $(i), 'ApplicationGroup');
LET vAppName= peek('Application Name', $(i), 'ApplicationGroup');
LET vDomain='DOMAIN';

Group:
LOAD 
		'$(vAppName)' 				as [App Name],
        upper(trim(name))    		as GROUPNAME,
        distinguishedName    		as GroupDN, 
        upper(trim(displayname))    as GroupDisplayName
         ;
SQL select  
          name,
          distinguishedName,
          displayname        
FROM 'LDAP://$(RootDse)'  
WHERE objectCategory='group' 
AND name='$(vGroup)';
NEXT i;

For i = 0 to NoOfRows('Group') - 1
LET vUserGroup = peek('GroupDN', $(i), 'Group');
LET vAppName1=peek('App Name', $(i), 'Group');
LET vGroupDisplayName=peek('GroupDisplayName', $(i), 'Group');


GroupsMembers:
LOAD 
//      '$(vAppName1)'
//      &'-'&applymap('TeamMapping','$(vDomain)' & '\' &upper(TextBetween(distinguishedName,'=', ',')),'Users')
//      &'-'&'$(vDomain)' & '\' & upper(TextBetween(distinguishedName,'=', ',')) as Key,
      '$(vAppName1)' as [App Name],
      '$(vGroupDisplayName)' as GroupDisplayName,
      '$(vDomain)' & '\' & upper(TextBetween(distinguishedName,'=', ',')) AS NTNAME,
      '$(vDomain)' & '\' & upper(TextBetween(distinguishedName,'=', ',')) AS USERID,            
      Capitalize(givenname) &' '&Capitalize(sn) AS UserFullName,
      distinguishedName as UserDN,
       '$(vUserGroup)' as GroupDN,
       co as Country,
       title as Title,
       mail as Email;
 SELECT  
     distinguishedName,
     givenname,
     sn,
     co,
     title,
     mail
FROM 'LDAP://$(RootDse)' 
WHERE objectCategory='person' 
AND MemberOf='$(vUserGroup)'
;
Next i;
drop table Group;

exit script