LDAP integration importing wrong data in user (sys_user) table

[rmaroti]

Hi Everyone,

Some external user data will be import in ServiceNow via LDAP integration but it is working fine in test and prod instance but not working proper in Dev instance it is creating duplicate multiple user and wrong mapping (like trim email id.first name. last name in "last name" and "name" field) on target (sys_user) table in DEV Instance i have check transform map, data source, LDAP server and source and target mapping in both dev and test instance are same .

Could you please suggest what will be the cause and please find attached screenshot.

[Shivalika]

Hello @rmaroti  

I think somebody would have altered the mappings in Transform map for LDAP. 

Please share the transform map mappings screenshot in dev instance. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY QQ

[rmaroti]

Hi @Shivalika ,

I have attached  the below two screenshot for two different transform map.

please suggest me if any issue?

[Shivalika]

Hello @rmaroti  Here, field mappings are doing much less of a work and most of the work is being done by transform scripts as you can see yourself as well. 

So, I think this will be a rigorous debugging, trying to figure out which of these 22 scripts can be causing this issue and thing is it can be none of these and something completely different as well. May be you can log a case, because this LDAP Integration is supported by servicenow. 

However, you can let things be as well and just "import and export" correct records since this is just "dev instance" and not "production" and just clone it.

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY QQ

[rmaroti]

Hi @Shivalika ,

I can clone it to the prod via export and import but problem is it still creating new record in system like there are some record created in 28th of march , some of are creating on 31st of march and some are created on yesterday like wise it is creating duplicate record with wrong mapping so i need to find out that root cause and fix it otherwise it will generate lot of duplicate record and i have scheched it scheduled Data import but in the system those all are in active false state stiil i have triggered manually for checking purpose but it creating record which is unique and correct mapping.

Meanwhile, i have tried to loaded 20 record of all data source which has target table us (sys_user) table but they are not generating new record because of the "Coalesce" and they all are working as we accepted nit creating new record. I don't understand form which data source those unwanted record created in system and those all record created by  "LDAP_Integration_User_copy" if you see the sceenshot.