how to populate manager field from AD, we have tried everything as per the Wiki article, but still no luck, we are using Sam AccountName as query

manpreet
Kilo Contributor

how to populate manager field from AD, we have tried everything as per the Wiki article, but still no luck, we are using Sam AccountName as query

1 ACCEPTED SOLUTION

jhauptmann
Kilo Guru

I just recently had the same issue and a colleague suggested I check the field lengths in the import set table.   What worked was increasing the field length for "manager" to 250 from the default which was 40.



Under Tables look at the User(imp_user) table and see what the field length is.   We also bumped up source, dn and bumped memberOf way up (2000) as that value can be quite long.



This may not work for you since you've been using SN for a while but might be worth checking.



Regards,


John


View solution in original post

11 REPLIES 11

jhauptmann
Kilo Guru

I just recently had the same issue and a colleague suggested I check the field lengths in the import set table.   What worked was increasing the field length for "manager" to 250 from the default which was 40.



Under Tables look at the User(imp_user) table and see what the field length is.   We also bumped up source, dn and bumped memberOf way up (2000) as that value can be quite long.



This may not work for you since you've been using SN for a while but might be worth checking.



Regards,


John


Hey John,



Good point as well.   We also had issues with the field lengths in the import set table and had to extend them.   I believe those field lengths are defined the first time you run an import and will not "increase" automatically.



Happy Friday,



Jim


Thank you to everyone who suggested a solution. For us, it was the field length. We made length as 300 for all available fields and it worked just fine! Everything that is out of box is all we used and changed the field length. We dint enter any values in attributes and therefore got all AD attributes invariably.


I just recently had the same issue and a colleague suggested I check the field lengths in the import set table.  

Brian Dailey1
Kilo Sage

Hi Manpreet,



Can you copy/paste your transform script that is attempting to update the manager?




Thanks,


-Brian