AD group Owner Import

[Community_User]

Originally posted on September 21 2020 at 15:50 UTC

Hello,

Saviynt version - 5.5 SP3,

I am not able to import AD group owners. Here is the JSON for groupImportMapping-

{

"importGroupHierarchy": "true",

"entitlementTypeName": "memberOf",

"performGroupAccountLinking": "true",

"groupObjectClass":"(objectclass=group)",

"mapping":"entitlement_value:distinguishedName_char,entitlement_glossary:description_char,lastscandate:whenCreated_date,displayName:name_char,customProperty9:name_char,customProperty40:managedBy_char,RECONCILATION_FIELD:entitlement_value,EntitlementOwnerAttribute:managedBy_char,

"tableFieldAttribute":"accountID",

"activeGroupPossibleValues":["active","a","l","TRUE"]

}

Error-

Shows inventory movement and provides access to transactional details impacting the subledger.' WHERE ENTITLEMENT_VALUEKEY=532268

2020-09-21 14:25:10,271 [quartzScheduler_Worker-3] ERROR services.AdImportService - Error - Failed to Connect or Import AD Data :

java.sql.BatchUpdateException: Unknown column 'entitlementownerattribute' in 'field list'

at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1196)

at com.saviynt.ecm.services.AdImportService$_createEntitlementValues_closure30.doCall(AdImportService.groovy:1915)

at com.saviynt.ecm.services.AdImportService.createEntitlementValues(AdImportService.groovy:1912)

at com.saviynt.ecm.services.AdImportService.mapDataToDbEntitlements(AdImportService.groovy:2323)

at com.saviynt.ecm.services.AdImportService.importAccess(AdImportService.groovy:2196)

at com.saviynt.ecm.services.AdImportService.doImport(AdImportService.groovy:167)

at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:142)

at SapImportJob.execute(SapImportJob.groovy:104)

at org.quartz.core.JobRunShell.run(JobRunShell.java:199)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)

2020-09-21 14:25:10,272 [quartzScheduler_Worker-3] DEBUG services.ImportUtilityService - Writing job history to import logs.

Also, the groups have managedBy attribute, which is a owner groups. How can we manage that in Saviynt.

Regards,

Yashpal

[Community_User · Accepted solution]

Originally posted on September 22 2020 at 04:58 UTC

Hi Yashpal,

Greetings!!

There was a bug reported for similar issue and it is fixed.

Please get in touch with your Saviynt Partner/ Saviynt executive for a patch of this fix.

Thanks & Regards,

Anand Kumar Jha