Hi Team
Here is our account import mapping JSON:
{
"ImportType": "RAAS",
"ResponsePath": "wd:Report_Data.wd:Report_Entry",
"ImportMapping": {
"NAME": "wd:User_Name~#~char",
"ACCOUNTID": "wd:Worker_group.wd:SAV_User_Name~#~char",
"DISPLAYNAME": "wd:Worker_group.wd:Full_Name~#~char",
"CUSTOMPROPERTY1": "wd:Worker_group.wd:Manager.wd:Descriptor~#~char",
"CUSTOMPROPERTY2": "wd:Worker_group.wd:Cost_Center.wd:Descriptor~#~char",
"CUSTOMPROPERTY3": "wd:Most_Recent_Sign_On.wd:Descriptor~#~char",
"CUSTOMPROPERTY4": "wd:Time_of_Most_Recent_Sign_On~#~char",
"CUSTOMPROPERTY6": "wd:Worker_group.wd:Company.wd:Descriptor~#~char",
"CUSTOMPROPERTY5": "wd:Account_Locked__Disabled_Expired~#~char"
}
}
Here is our Access List on the connection form. We want to import only Security Groups and Organization Roles into Saviynt from Workday
Security Group, Organizational Role
Here is our Status_Threshold_Config JSON:
{
"statusAndThresholdConfig":
{
"statusColumn": "customproperty5",
"activeStatus": ["0"],
"deleteLinks": false,
"accountThresholdValue": 0,
"correlateInactiveAccounts": false,
"inactivateAccountsNotInFile": false
}
}
Accounts/Accessess(Not fully) are getting imported successfully. Accounts are not getting associated with their respective accesses. I see below error in debug logs:
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 org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:757) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:114) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at jdk.internal.reflect.GeneratedMethodAccessor34.invoke(Unknown Source) ~[na:na]|Caused by: 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 org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.java:79) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:220) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:112) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]|Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: RoleUserAccount is not mapped| at org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:170) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:91) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:77) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:334) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3782) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]| at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3671) ~[hibernate-core-5.6.15.Final.jar!/:5.6.15.Final]|
Any assistance is greatly appreciated.
Regards
Sangita Ladi