Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/22/2024 07:08 AM
Hello,
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 (r.id as id, r.roleName as name, rua.enddate as expiryDate, 'Roles' as accessType) from com.saviynt.ssm.entity.Roles r, RoleUserAccount rua where r.id = 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,
Iván
05/22/2024 07:36 AM
Hi @Ivan5533 , can you share your json once to review?
05/22/2024 09:41 AM
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....
UserImportJson:
{
"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": "completeResponseMap.total"
}
}
}
Thank you,
Ivan
05/22/2024 08:19 PM
You are trying to import users with account import json. Please use correct job to import users.