We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Data not syncing to AD

nitishdas
New Contributor
New Contributor

Hi Team,

Currently we are using the below code to send data to of the AD attribute that is extensionattribute25 but the required data is not getting synced.

"extensionAttribute25":"${'false'.equalsIgnoreCase(user.customproperty7)?(user.jobcodedesc?.toUpperCase()+' ')+('isManager'.equalsIgnoreCase(user.customproperty62) && com.saviynt.ecm.identitywarehouse.domain.Users.findAllWhere(owner:user.username).find{it.employeeType=='Internal'&&it.statuskey==1}?'People Manager':'Individual Contributor'):''}",

To explain the scenario:

Once user's JobCodeDesc is "MEP" and in CP62 the value is updated as "isManager" for a user and he is the owner of some users than the extensionattribute25 should be updated as "MEP People Manager". But this is currently not happening and the attribute value in AD it is showing as "MEP Individual Contributor". Could you please suggest if the above code is wrong or it is right as per the requirement.

13 REPLIES 13

rushikeshvartak
All-Star
All-Star
  • Does other part of json is working ?
  • share complete json
  • share logs. After running wsretry job

 


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

Hi @rushikeshvartak ,

yeah rest eveyrthing is working fine.

Please find the JSON below:

 

{
"c":"${user.customproperty8}",
"sn":"${user?.lastname.toUpperCase()}",
"co":"${user.country}",
"department":"${if(null != user.departmentname && user.departmentname.length() > 32){user.departmentname.substring(0,32)} else {user.departmentname}}",
"employeeType":"${if(null!=user.customproperty7 && user.customproperty7.equalsIgnoreCase('false')){'INTERNAL'}else{'CONTRACTOR'}}",
"extensionAttribute3":"${user.customproperty19}",
"extensionAttribute5":"${user.customproperty27}",
"extensionAttribute6":"${user.customproperty30}",
"extensionAttribute16":"${user.customproperty35}",
"extensionAttribute7":"${user.customproperty13}",
"extensionAttribute10":"${user.orgunitid}",
"extensionAttribute11":"${user.customproperty2}",
"extensionAttribute14":"${user.job_function}",
"extensionAttribute17":"${user.customproperty34}",
"extensionAttribute20":"${'false'.equalsIgnoreCase(user.customproperty7)?user.jobCode:''}",
"extensionAttribute18":"${if(null!=user.customproperty28){user.customproperty28}else{user.username}}",
"extensionAttribute21":"${user.customproperty56}",
"extensionAttribute22":"${user.customproperty57}",
"extensionAttribute23":"${user.customproperty58}",
"extensionAttribute24":"${user.location}",
"extensionAttribute19":"${user.customproperty52}",
"extensionAttribute9":"${if(null!=user.customproperty7 && user.customproperty7.equalsIgnoreCase('false')){if(null!=user.location && user.location.length() > 5)user.location.substring(0, 5)}else if(null!=manager){manager.location}}",
"title":"${user?.title?.replace('"','\\"')}",
"company":"${user.companyname}",
"physicalDeliveryOfficeName":"${user.locationnumber?.replace('"','\\"')}",
"telephoneNumber":"${user.customproperty17}",
"mobile":"${user.customproperty18}",
"manager":"${if(null!=managerAccount)managerAccount.accountID}",
"extensionAttribute2":"${user.costcenter}",
"extensionAttribute8":"${if(null!=user.startdate){(new java.text.SimpleDateFormat('yyyy-MM-DD HH:mm:ss').parse(new java.text.SimpleDateFormat('yyyy-MM-DD HH:mm:ss').format(user.startdate)).getTime()*10000L)+116444736000000000L}}",
"extensionAttribute25":"${'false'.equalsIgnoreCase(user.customproperty7)?(user.jobcodedesc?.toUpperCase()+' ')+('isManager'.equalsIgnoreCase(user.customproperty62) && com.saviynt.ecm.identitywarehouse.domain.Users.findAllWhere(owner: user.username).find{it.employeeType=='Internal'&&it.statuskey==1}?'People Manager':'Individual Contributor'):''}",
"accountExpires":"${if(null!=user.customproperty7 && user.customproperty7.equalsIgnoreCase('true') && null!=user.enddate){(new java.text.SimpleDateFormat('yyyy-MM-DD HH:mm:ss').parse(new java.text.SimpleDateFormat('yyyy-MM-DD HH:mm:ss').format(user.enddate)).getTime()*10000L)+116445600000000000L}else{'000000000000000000'}}"
}

nitishdas
New Contributor
New Contributor

Hi Team,

Could anyone help me on this as this requirement is bit urgent.

nitishdas
New Contributor
New Contributor

Hi @rushikeshvartak ,

Could you please help me here as this requirement is bit urgent.

nitishdas
New Contributor
New Contributor

Hi team,

Could you please help me on this as this bit critical and need to be resolved soon.

nitishdas
New Contributor
New Contributor

Hi Team,

Could anyone help me on this please.

adarshk
Saviynt Employee
Saviynt Employee

Hi Nitish,

Can you confirm if you are able to set the value directly without the condition? If yes, please validate the syntax used to calculate

Also, please validate if the user is satisfying the mentioned conditions here:

"${'false'.equalsIgnoreCase(user.customproperty7)?(user.jobcodedesc?.toUpperCase()+' ')+('isManager'.equalsIgnoreCase(user.customproperty62) && com.saviynt.ecm.identitywarehouse.domain.Users.findAllWhere(owner: user.username).find{it.employeeType=='Internal'&&it.statuskey==1}?'People Manager':'Individual Contributor'):''}",

Try the above condition only by setting Jobcodedesc+'People Manager' (remove the else part)

Regards,
Adarsh Kulkarni

Hi @adarshk ,

We cannot make such changes in Prod for testing as this is the critical application. In PreProd same code is working. For your information we tested for few users in Prod and we saw it went fine for one user and rest it did not. All the users were matching the conditions as per the code like user's Job Code Desc was MEP and customproperty62 is set as "isManager" and that particular user is active with employeeType set as "Internal". No sure if it is really a code issue.

adarshk
Saviynt Employee
Saviynt Employee

Can you confirm if both of your environments are on same version? 

Hi @adarshk ,

Yes, both are of same version.

adarshk
Saviynt Employee
Saviynt Employee

Thanks for confirming.
Any specific error in logs that you have observed? 

Please reinitiate the provisioning on a user where you are seeing the issue and share the logs/ observations for further troubleshooting. 

Thanks,
Adarsh Kulkarni

We have reinitiated the provisioning for one user (436055) and this is the log:

 

adarshk
Saviynt Employee
Saviynt Employee

Is this issue still seen? If fixed, please share the action taken. 

This will help community users to track the issue and its solution.