Thanks for the great advice! I knew I could count on smart people J As it turned out we did not have enough qualifications in the Vendor form table properties. When we limited the table properties to A-E etc as some of you suggested we were able to retrieve all of the records in 5 escalations. Many thanks!
MCD From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Friday, March 07, 2008 6:31 AM To: [email protected] Subject: Re: LDAP arplugin failure problem ** Maria, Another option to get around the LDAP query limitation is to create a single SQL View comprised of multiple SELECTs that are UNIONed together. You can then query this view and retrieve all LDAP entries. See the email from January 9 entitled "Re: LDAP Question". There is a script attached that can be used to create the SQL View. Stephen Remedy Skilled Professional _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: Thursday, March 06, 2008 7:20 PM To: [email protected] Subject: Re: LDAP arplugin failure problem Hi Maria, I would guess that your LDAP server has an entry count limit on the number of records that can be returned by a search. This is fairly common -- usually LDAP servers are set to an entry count limit of 1 or 2 thousand records. If the LDAP admin is unwilling or unable to alter this setting, you might try breaking it up into multiple escalations that search for the users in manageable chunks (e.g., all users with user names starting with "A", then "B", then "C", etc.). Each letter of the alphabet would have to return fewer entries than the LDAP entry count limit, of course. That would a whopping 26 escalations instead of one, but it might work, depending upon how many users you have in LDAP. If you can go another route, I have found that it is much easier to set up this kind of import using a view form to an external database rather than an vendor form using the ARDBC LDAP plugin. --Thomas ----- Original Message ----- From: Maria C Delagarza <mailto:[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: [email protected] Sent: Thursday, March 06, 2008 1:07 PM Subject: LDAP arplugin failure problem ** Hi Listers, I am appealing to people smarter than myself. I currently am having an issue with an LDAP import. Here is the scenario: We are connected to the LDAP and can run queries on the Vendor Form that return the record we want to see. However, when we run the same query through a filter escalation the arplugin fails and does not give an error message..it fails around 50K records or so. Any thoughts? We are running ARS 7.1 Patch 006 MS SQL 2005 Windows Server 2003 Any help is much appreciated, we are trying to get to a pilot on Monday and this problem is preventing our CTM:People population. Thanks. MCD Maria C Delagarza AR System Specialist Eluri Designs eluridesign.com [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
