Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Error while importing AD groups for the first time

kollusunil
New Contributor III
New Contributor III

Hi,

We are trying to import AD groups for the first time(Initial implementation), but when we run the import job getting below error


Below is the import group mapping JSON:

{
"importGroupHierarchy": "true",
"entitlementTypeName": "",
"performGroupAccountLinking": "true",
"incrementalTimeField": "whenChanged",
"groupObjectClass": "(objectclass=group)",
"mapping": "memberHash:member_char,customProperty1:sAMAccountType_char,customProperty2:instanceType_char,customProperty3:uSNCreated_char,customProperty4:groupType_char,customProperty5:dSCorePropagationData_char,customProperty12:dn_char,customProperty13:cn_char,lastscandate:whenCreated_date,customProperty15:managedBy_char,entitlement_glossary:description_char,description:description_char,displayname:name_char,customProperty9:name_char,customProperty10:objectCategory_char,customProperty11:sAMAccountName_char,entitlement_value:distinguishedName_char,entitlementid:distinguishedName_char,customProperty14:objectClass_char,updatedate:whenChanged_date,customProperty17:distinguishedName_char,RECONCILATION_FIELD:customProperty17,customProperty18:objectGUID_Binary",
"activeGroupPossibleValues": ["active", "a", "l", "TRUE"]
}

Error we are getting after running job is below:

Error - Importing AD Data :
Error-Connecting-or-Importing-AD - could not
resolve property: customProperty17 of:
com.saviynt.ecm.identitywarehouse.domain.Entitleme
nt_values [select new Map(a.entitlement_value as
entitlement_value, a.entitlementtypekey.id as
entitlementtypekey, a.id as id, a.customProperty17
as UNIQUE_COL) from
com.saviynt.ecm.identitywarehouse.domain.Entitleme
nt_values a where
a.entitlementtypekey.id in (2)]; nested exception
is org.hibernate.QueryException: could not resolve
property: customProperty17 of:
com.saviynt.ecm.identitywarehouse.domain.Entitleme
nt_values [select new Map(a.entitlement_value as
entitlement_value, a.entitlementtypekey.id as
entitlementtypekey, a.id as id, a.customProperty17
as UNIQUE_COL) from
com.saviynt.ecm.identitywarehouse.domain.Entitleme
nt_values a where
a.entitlementtypekey.id in (2)]

Kindly help if there is any error in mapping or someother is missing?

Thanks

3 REPLIES 3

Srinivas
Saviynt Employee
Saviynt Employee

Hi @kollusunil 

Could you please make customProperty17 to customproperty17 ( lower case ) & then Save & Test Connection.

Thanks & Regards

Srinivas

rushikeshvartak
All-Star
All-Star

Make customproperty as small in json


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

kollusunil
New Contributor III
New Contributor III

Thank you @Srinivas @rushikeshvartak , it is working now. 

Regards,

Sunil