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 in Saviynt 4 Saviynt import Job

Regular Contributor
Regular Contributor


I am trying to implement Saviynt4Saviynt to be able to assign SAV Roles in the technical rules, for this, I have followed the following configuration guide:

I have configured the following JOB to import the accounts:


And I am getting the following error:
Error in fetching userAccessExpirydetails :: {}|java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: RoleUserAccount is not mapped [select distinct new Map ( as id, r.roleName as name, rua.enddate as expiryDate, 'Roles' as accessType) from com.saviynt.ssm.entity.Roles r, RoleUserAccount rua where = rua.rolekey and r.status = 1 and rua.enddate is not null and rua.userkey = :userkey and rua.startdate between :startDate and :endDate]| at...

Can you help me to solve this error and to be able to assign SAV roles in the technical rules?

Thank you,



Valued Contributor II
Valued Contributor II

Hi @Ivan5533 , can you share your json once to review?

Regular Contributor
Regular Contributor

Hi, which one?

After several attempts I see no errors, but the job is still failing and the logs I see about it are as follows:

2024-05-22T18:30:05+02:00-ecm-worker-services.JobManagementGuardRailService-quartzScheduler_Worker-6-v8qcn-DEBUG-Conflicting job group found for SapImportJob
2024-05-22T18:30:05+02:00-ecm-worker-services.JobManagementGuardRailService-quartzScheduler_Worker-6-v8qcn-DEBUG-Checking if any of the currently running Jobs belongs to conflicting Job Group of SapImportJob

I have no job called SapImportJob....


"connection": "userAuth",
"url": "####/ECM/api/v5/getUser",
"httpMethod": "POST",
"httpHeaders": {
"Authorization": "${access_token}",
"contentType": "application/json"
"httpParams": "{\"userQuery\":\"user.username is not null\"}",
"httpContentType": "application/json",
"colsToPropsMap": {
"username": "username~#~char",
"employeeType": "employeeType~#~char"
"userResponsePath": "userdetails",
"pagination": {
"offset": {
"offsetParam": "offset",
"batchParam": "max",
"batchSize": 10000,
"totalCountPath": ""


Thank you,




You are trying to import users with account import json. Please use correct job to import users. 



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