LDAP - Manager field not getting populated

[ericroberts]

I have a new LDAP setup and the managers have never correctly loaded in.  One of our folks noticed that the incoming 'manager' field was being truncated...so he increased the default char size of the ldap_import table manager field to 160.  Manager is still not loading in. 

To try to isolate the issue I nuked all users from the sys_user table (except admin accounts) ... and now I am only pulling in 4 names from LDAP.  One manager (Sally) and 3 direct reports as defined in Active Directory and verified in LDAP.  (Joe, John, Bill).  I clean out the sys_user table...force a scheduled load of these 4 names...they come in fine.  But no manager field.  

In my transform map I have it set to Run script...and I even added the following code to the end of the script to prove it was firing:

target.u_usda_eauth_id_test='USDAEAUTHTESTID';

After the load of the LDAP records all users have this USDAEAUTHTESTID string in that field...so I assume 

ldapUtils.setManager(source, target);

is firing.  

Everything else is out of the box for onBefore, onStart and onComplete.  

I even tried running the ldapUtils.processManagers() in a Background Scripts window...it says it ran with no errors...but again, no managers.

gs.include("LDAPUtils");
var ldapUtils = new LDAPUtils();
//ldapUtils.setLog(log);
ldapUtils.processManagers();

Any ideas?

Thank you !!!

ER

PS: On a side note...where do I find ldapUtils to go look at how it works??

[alexbones]

Do those managers you are trying to map have a user record created already? Do you have the source field being mapped? Does the system have access to the OU the managers are saved in? Did you say you have a field mapping to the manager field? If you did, you shouldn't need it mapped as that is what the manager util does.

[ericroberts]

We got it figured out ... with the help of a contractor working with us.  I didn't follow it all ... but I think that as it turns out there are a few fields in the ldap_import table that come out of the box at 40 chars.  The contractor had already increased the manager field to 160 chars as we knew up front that that field was being cut off. 

What he realized later today was that there were 2 more fields that were being trimmed at 40 and they are used by the LDAPUtils in some way ... I think it was the DN field and the source field.  Once we increased both of those fields the script ran to completion and viola...we have managers.

Thanks!

ER

PS: Very big thank you to Mike Patel for all his help and trying to work through it with me. 

[Michael Culhan1]

Your post saved me so much time trying to figure this out, thanks so much.

[Pratibha Singh]

Thank you for this post. It really helped. Although in my case I had to increase max size of atleast 20more fields other than dn and source. Then it worked. Thanks alot for this convo .