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

Ivan5533
Regular Contributor
Regular Contributor

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:

https://docs.saviyntcloud.com/bundle/Saviynt-REST-based-Guide/page/Content/Understanding-Integration...

I have configured the following JOB to import the accounts:

Ivan5533_0-1716386640252.png

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

3 REPLIES 3

NM
Valued Contributor
Valued Contributor

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

Ivan5533
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....

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

 

 

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

rushikeshvartak_0-1716434383533.png

 


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