Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Rest Account Import failing with "processAccountEntitlementsByAccToEntMappings try3"

jsatish
Regular Contributor II
Regular Contributor II

Hi All,

Rest Access import is failing with below error. But Account Import and Entitlement association is working fine and no issues with it. 

processAccountEntitlementsByAccToEntMappings try3: "
"2024-04-17T19:24:08.208+00:00","ecm-worker","","null-k5zsk","","org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=612 and ev.status = 1]; nested exception is org.hibernate.QueryException: could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=612 and ev.status = 1] at com.saviynt.provisoning.rest.RestProvisioningService.populateEntitlementMapByConfig(RestProvisioningService.groovy:6158) at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountEntitlementsByAccToEntMappings_closure46.doCall(RestProvisioningService.groovy:7707) at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlementsByAccToEntMappings(RestProvisioningService.groovy:7700) at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountEntitlementParams_closure41_closure114.doCall(RestProvisioningService.groovy:6432) at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountEntitlementParams_closure41.doCall(RestProvisioningService.groovy:6430) at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlementParams(RestProvisioningService.groovy:6429) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFullBySequentialAndIterative(RestProvisioningService.groovy:307) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFull(RestProvisioningService.groovy:169) at com.saviynt.provisoning.rest.RestProvisioningService.doImport(RestProvisioningService.groovy:143) at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:232) at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:211) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)Caused by: org.hibernate.QueryException: could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=612 and ev.status = 1] ... 13 more"
"2024-04-17T19:24:07.398+00:00","ecm-worker","rest.RestProvisioningService","quartzScheduler_Worker-5-k5zsk","DEBUG","Exception in processAccountEntitlementsByAccToEntMappings try3: "
"2024-04-17T19:24:08.208+00:00","ecm-worker","","null-k5zsk","","org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=612 and ev.status = 1]; nested exception is org.hibernate.QueryException: could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=612 and ev.status = 1] at com.saviynt.provisoning.rest.RestProvisioningService.populateEntitlementMapByConfig(RestProvisioningService.groovy:6158) at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountEntitlementsByAccToEntMappings_closure46.doCall(RestProvisioningService.groovy:7707) at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlementsByAccToEntMappings(RestProvisioningService.groovy:7700) at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountEntitlementParams_closure41_closure114.doCall(RestProvisioningService.groovy:6432) at com.saviynt.provisoning.rest.RestProvisioningService$_processAccountEntitlementParams_closure41.doCall(RestProvisioningService.groovy:6430) at com.saviynt.provisoning.rest.RestProvisioningService.processAccountEntitlementParams(RestProvisioningService.groovy:6429) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFullBySequentialAndIterative(RestProvisioningService.groovy:307) at com.saviynt.provisoning.rest.RestProvisioningService.importAccessFull(RestProvisioningService.groovy:169) at com.saviynt.provisoning.rest.RestProvisioningService.doImport(RestProvisioningService.groovy:143) at com.saviynt.ecm.integration.ExternalConnectionCallService.invokeExternalMethod(ExternalConnectionCallService.groovy:232) at ApplicationDataImportJob.execute(ApplicationDataImportJob.groovy:211) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)Caused by: org.hibernate.QueryException: could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=612 and ev.status = 1] ... 13 more"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "countPrincipals": 0,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "version": 12,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "createdBy": 6966,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "createdOn": "2023-09-07T13:13:55.190Z","
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "updatedBy": 6966,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "updatedOn": "2024-01-23T11:04:47.103Z","
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "systemRole": false"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," }, {"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "id": 296,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "name": "ABC_AARI-Test","
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "description": "","
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "countPrincipals": 1,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "version": 8,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "createdBy": 6966,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "createdOn": "2023-07-12T10:13:36.807Z","
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "updatedBy": 6966,"
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "updatedOn": "2024-01-23T11:04:46.013Z","
"2024-04-17T19:24:07.208+00:00","ecm-worker","","null-k5zsk",""," "systemRole": false"

Attaching the ImportAcctEntJSON

If any leads greatly appreciated.
Thanks,

SJ

5 REPLIES 5

rushikeshvartak
All-Star
All-Star

Use attached 


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

jsatish
Regular Contributor II
Regular Contributor II

@rushikeshvartak - Thanks for sharing the updated JSON. But error remains same. 

could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=324 and ev.status = 1]; nested exception is org.hibernate.QueryException: could not resolve property: null of: com.saviynt.ecm.identitywarehouse.domain.Entitlement_values [select new Map(ev.null as null,ev.id as id) from com.saviynt.ecm.identitywarehouse.domain.Entitlement_values ev where ev.entitlementtypekey.id=324 and ev.status = 1]

Do you any entitlement with null check with sql query


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

jsatish
Regular Contributor II
Regular Contributor II

@rushikeshvartak - There are 46 entitlements and all are having Entitlement Value and EntitlementID values.

jsatish
Regular Contributor II
Regular Contributor II

@team,

Any leads on this?

Regards,
SJ