Rest Account Import failing with "processAccountEntitlementsByAccToEntMappings try3"

[jsatish]

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

[rushikeshvartak]

Use attached 

[jsatish]

@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]

[rushikeshvartak]

Do you any entitlement with null check with sql query

[jsatish]

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

[jsatish]

@team,

Any leads on this?

Regards,
SJ