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

Rest Account Import failing with "processAccountEntitlementsByAccToEntMappings try3"

jsatish
Regular Contributor
Regular Contributor

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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

@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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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

jsatish
Regular Contributor
Regular Contributor

@team,

Any leads on this?

Regards,
SJ